$1.$ Choose one of the following case studies from your textbook:

The University Accommodation Office case study

The EasyDrive School of Motoring case study

The Wellmeadows Hospital case study

See Appendix B in your text for case study details.

$2.$ Create a conceptual data model for the case study. State any assumptions necessary to support your design. Check that the conceptual data model supports the required transactions.

$3.$ Create and validate a logical data model from the conceptual data model

$4.$ Based on the logical data model developed create a physical database design based on the DBMS that you have access to$/$are familiar with.

Submission: Submit the three models to your instructor as directed.