Answer Happy

CIT-461 System Analysis and Design Lab
Lab Assignment #10
Data Design: Ajman Clinic Appointment
System
We have been working on Clinic Appointment Booking system until
now in many previous lab assignments.
As previously mentioned, “Ajman Clinic” would like you to do the
appointment booking system for them.
Previously, we discovered our data stores for the system, we had
the patient data store, the appointment data store, the doctor data
store and the schedule data store.
A patient can make zero or many appointments, an appointment can
be made by one patient.
A patient can select one or many doctors, and a doctor can be
selected by zero or many patients.
A doctor will have one schedule, a schedule belongs to one
doctor.
Task 1: Entities, attributes and primary
key
Based on previous knowledge of the system, build up for every
data store/entity its attributes and identify the corresponding
primary key.
Task 2: ERD and Foreign Key
For the entities found, create the corresponding ERD and
indicates the foreign keys.