A complete relational database schema designed for an Employee Management System, built using Oracle SQL.
Includes table creation scripts, constraints, sample data, and sequences.
✔ Structured Schema – Tables for employees, jobs, departments, locations, and regions.
✔ Referential Integrity – Primary and Foreign Keys enforcing database consistency.
✔ Preloaded Data – Sample employees, jobs, and locations included.
✔ Auto-Increment – ID sequences to manage unique keys.
The database includes:
- Tables: Employees, Departments, Jobs, Locations, Countries, Regions.
- Constraints: Primary Keys, Foreign Keys, and Unique Constraints.
- Sequences: Auto-incrementing ID values for primary keys.
Clone this repository: git clone https://github.com/seu-usuario/oracle-employee-database.git
Open Oracle SQL Developer and connect to your database. Run the schema creation script: @schema.sql
Insert sample data: @data.sql
Start querying the database!
📝 License This project is licensed under the MIT License. Feel free to use and modify it as needed!
🔹 Suggestions or improvements? Feel free to contribute! 🚀