Purpose This script is designed for testing and demonstrating the functionality of a Human Resource Management System (HRMS) within an Oracle Database environment. It serves as a foundation for evaluating database operations, trigger automation, and data manipulation techniques.
This was the final exam submission for UD's database class
The HRMS SQL script encompasses the following components:
SQL Script: A comprehensive set of SQL commands that define the database structure and functionalities for managing human resources.
PL/SQL Triggers: Automated procedures that respond to specific events within the database, ensuring efficient task execution.
Stored Procedures: Encapsulated SQL code that can be executed as a single unit, allowing for complex data manipulations and business logic implementation.
SQL Queries: A variety of data retrieval and manipulation queries designed to test database interactions and validate data integrity.