Scribd
Upload
11 views1 page

Assignment 2

Uploaded by

hifsaaslam111
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
11 views1 page

Assignment 2

Uploaded by

hifsaaslam111
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Question#1: Solution:

Doctor

Doctor ID, Name, Specialty, Schedule, Contact Info

Appointment

Appointment ID, Date, Time, Status

Patient

Patient ID, Name, Contact Info, Medial History

Hospital

Hospital ID, Name, Location, Contact Info

Receptionist

Receptionist ID, Name, Contact Info

Appointment
Name
ID
DoctorID Specialty

Doctor Date
Have

Appointment

schedule Contact info

Time

Status

Have
Have
schedule

Patient ID
Hospital Name
ID
Receptionist
Name
Hospital Visit Patient

Receptionist Contact
ID, info Contact
info
Name Contact
Location info
Medial
History

You might also like