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. State any assumptions you make when creating the ER model (if necessary).
(30 marks)
- Produce a Data Dictionary for the ER diagram in task (1).
(25 marks)
- Implement the set of relational tables created in task (2) using Oracle.
You must include your CREATE TABLE statements in the report.