ASSIGNMENT - Project 5

For the revised customer care database, revisit the Chen ERD that was submitted in Final Project Part 1. Make any revisions to the original Chen diagram to reflect the following additional design requirements:

A single status table. that way, the patients, prescriptions, and doctors can all have a status (such as Active or Inactive) from a single status source. This is a better method than using an ENUM or VARCHAR data type for Status.

A single table for city and state. This way, patients and doctors can reside in the same city/state without repetitive entries.

A single table for the names of drugs. This table only contains drug names - not prescriptions. However, since many prescriptions can exist for the same drug name, a separate table for the drug name is appropriate.

Submit a Word document with the revised Chen diagram and a Crow's Foot ERD. In the Crow's Foot ERD list all column names and mark those that are Primary Keys for the tables.