D1. One A4 page, state clearly any assumptions (i.e. Enterprise or Business rules) that you make
about the data; in particular,
D2. One A4 page containing the conceptual data model diagram
D3. For the above model, produce a relational schema
D4. Normalisation check: You need to check your produced Relational Schema above for 3rd NF.
D5. Create a DB for the above schema in an appropriate relational DBMS and populate each table
with typical records to clearly demonstrate the application results.
D6. Write the SQL code only (i.e. no form or report) for applications A1-A4 above.
D7. Using the appropriate tool from the chosen DBMS, create a simple form to enable end user to
D8. Using the appropriate tool from the chosen DBMS, produce a report for application A5
D9. This is for application A6 above. Using the appropriate tool from the chosen DBMS create a
master/detail form to per