1. Create an entity-relationship model (using UML notation). Specify the cardinality ratio and participation constraint of each relationship type. State any assumptions you make when creating the ER...

1.    Create an entity-relationship model (using UML notation). Specify the cardinality ratio and participation constraint of each relationship type. State any assumptions you make when creating the ER model (if necessary).


2.    Produce a Data Dictionary for the ER diagram in task (1).




3.    Implement the set of relational tables created in task (2) using Oracle.


You must include your CREATE TABLE statements in the report.


4.    Populate the tables with relevant data.


A screen shot of the populated tables must be included in the report.


5.    A full discussion of  the  constraints  used,  covering  the  three  types:  entity, referential and column. Explain why you used them and how they ensure that the integrity and consistency of your data is maintained.


6.    Write 3 queries to demonstrate that your database meets the data requirements of the system. You have to work out what you consider to be the best 3 queries that demonstrate the database meets the data requirements of the system.   In your queries you are expected to use a range of SQL queries. ***


A screen shot of the query output must be included in the report.