You are required to draw the ER diagram only for t h e above description following the convention of the textbook. Draw an ER-diagram for the database, identifying the following: (i) all the entity sets; (ii) all the relationship sets and their multiplicity;
(iii) the primary key for each entity set (and weak entity set, if any) and each relationship set.
Indicate which properties in the problem description (if any) are NOT reflected by your design. For each of these properties you give (again, if any), use as an example situation that is allowed by your ERD but this situation contradicts the property in the description.
Given the above description, do the following:
1. Draw an ER-diagram for the database, identifying the following:
(i) all the entity sets;
(ii) all the relationship sets and their multiplicity;
(iii) the primary key for each entity set (and weak entity set, if any) and each relationship set.
Invent more attribute(s) for the entity sets if you like.
2. Indicate (what and why) feature(s)/property(ies) (if any) in the above description that are NOT captured by your ER-diagram;
4. Create an SQL script (and run it on Oracle) to create all the relational tables corresponding to the ER diagram in (1) and insert at least two tuples to each table.
When you create tables in SQL, for each table
• Indicate its attributes
• Indicate its primary key
• Indicate additional uniqueness constraints if any
• Indicate foreign keys if any
• Indicate NOT NULL constraints if any
Note: Please type your solution if possible. Otherwise, write clearly. Always assume that the grader will INCORRECTLY decipher difficult handwriting. For question (4) you need to submit a separate file with the SQL script.
