You must develop entity relationship diagram erd for the system

COP 2937 Database Concepts

School of Information

For this phase of the project, you must develop an Entity Relationship Diagram (ERD) for the system. Entity types for this system include:

• Doctors,

• Appointments

Be sure to design in the ability to record the cost to the patient. The purpose of this phase is to communicate with the doctor how you envision the relationships in the data generated by the office. Remember, the doctor is not a technical expert, so a simple way of communicating the design of the system is valuable.

• Generate a list of patients who have appointments for today.

• Determine which patients most frequently come to the office.