Use the Microsoft Visio $2013$ application and the template shown in the following figure to create the diagram

Chen's Database Notation

Provided by: Microsoft Corporation

Model a database using Chen's Notation to create

an Entity Relationship diagram.

Download size: $9KB$

Metric Units

US Units

Create

Database model

Contents of the fields in the patient table:

Patient ID

Patient's last name

Patient's first name

Phone

E$-$Mail

Contents of the fields of the consultation table:

Patient ID

Date of consultation

Consultation time

Appointment time

Flag indicating whether the appointment is urgent. Possible values are "YES" or $"$NO$".$

Flag indicating whether the patient attended the appointment or not. Possible values are "YES" and $"$NO$".$