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.

  • March 15, 2018
Click Here to Leave a Comment Below 0 comments

Leave a Reply:

University of Nairobi