Answers to the questions below must be compiled into a single Word document. Do not forget to include
your exam number in the heading of the document. Do not forget to name your file by your exam ID
Consider and fully follow the conceptual ER model. Don’t add/remove/revise/extend/optimize any designs of the following conceptual ER model.
Questions a) Create a new schema and develop the EER model using MySQL Workbench. Screenshot of your EER diagram and paste to your Word document. [30% marks]
b) Forward engineer your EER design to build the database and copy the auto-generated SQL script and
paste to your Word document.
Sun | Mon | Tue | Wed | Thu | Fri | Sat |
---|---|---|---|---|---|---|
27 | 28 | 29 | 30 | 1 | 2 | 3 |
4 | 5 | 6 | 7 | 8 | 9 | 10 |
11 | 12 | 13 | 14 | 15 | 16 | 17 |
18 | 19 | 20 | 21 | 22 | 23 | 24 |
25 | 26 | 27 | 28 | 29 | 30 | 31 |