Produce an Entity-Relationship Model for the scenario described above (15 marks) Develop a top-down design of the data in the form of an entity-relationship diagram. You should note all assumptions...

Produce an Entity-Relationship Model for the scenario described above (15 marks)
Develop a top-down design of the data in the form of an entity-relationship diagram.  You should note all assumptions you make about the data and the reasoning behind your design choices.  Also include any appropriate constraints and a list of entity types showing their attributes and identifiers.
2. Design a set of relations conforming to Boyce-Codd Normal Form (BCNF). (15 marks)
Once you are satisfied that the ER diagram is a good representation of the data, produce a logical design by mapping the E-R diagram to a set of (normalized) relations. Clearly show all intermediate steps.
3. Implement your final database design. (15 marks)
Take each of the relations from your relational model and implement them as SQL tables. You must include all primary and foreign keys as well as any other table or column constraints you feel are appropriate. Then, using appropriate sample data and your own imagination, populate your finished tables.
4. Query your database. (20 marks)
Using SQL, write a set of realistic sample queries based on the above scenario (use your imagination for details of each query) but they should include the following SQL query techniques: