Create an entity-relationship model (using UML notation). Specify the cardinality ratio and participation constraint of each relationship type.

Create an entity-relationship model (using UML notation). Specify the cardinality ratio and participation constraint of each relationship type.

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).

(30 marks)

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

(25 marks)

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

You must include your CREATE TABLE statements in the report.