Can you help please.


Here is the assignment descriptions and attached is the page which should be use to do the homework. 

Part I – Entity Relationship Modeling.

In chapter 4, page 204 and 205, using case exercise number 3 as a reference:


Dr. Z in the MS Center is using the MS Clinic Management System from an external vendor to keep track of clinical information regarding his patients. The application uses a relational database. Before seeing a patient, Dr. Z reviews a printout of the worksheet shown in MVCH Figure 4- 6.


·         Use MySQL Workbench to create a 3NF ERD model of the worksheet shown in Figure 4-6, page 205. Be sure to include all necessary relationships and to account for all pertinent data represented on the worksheet.  Submit the diagram as a PDF or Word document to the group D2L folder.


·         Write the SQL CREATE statements that will implement this model in MySQL.  Remember to include the appropriate entity and referential constraints in each table structure. Submit as a text file or Word document to the group D2L folder.

  You will be evaluated on how clearly you explain your model and the choices you made in your design.