Implement, via SQL, a small database in the Oracle RDBMS from a provided logical model case study, followed by the insert of appropriate data to the created tables. Once populated used the database to: carry out specified DML commands and make specified changes to the database structure via SQL.
This task covers learning outcomes:
- Apply the theories of the relational database model.
- Implement a relational database based on a sound database design.
- Manage data that meets user requirements, including queries and
transactions
The specifications of the project is written in FIT3171_Assignment2_Specifications