DATABASE TECHNOLOGIES.

Running head: DATABASE TECHNOLOGIES
Database Technologies
Name of Student-
Name of University-
Author’s Note-

DATABASE TECHNOLOGIES1
Section B
1. Database Design
a. The entities that are related with the case study of Knox Private Hospital are:
i. Patients
ii. Doctors
iii. Prescriptions
iv. Drug
v. Pharmacy
b. Attributes of the entities
i. Patient (PatientID, PatientName, Address, Age)
ii. Doctors (DoctorID, DoctorName, Speciality, YoE, PatientID)
iii. Prescriptions (PID, PatientID, DoctorID)
iv. Drug (DrugID, DrugName, QuantityPerStrips, PID)
v. Pharmacy (PCode, Pname, PAddress, PNum, DrugID, Price)
c. Relationships
i. Every patients has one or more doctors – one to many relationship
ii. Every patients has more than one prescriptions – one to many relationship
iii. Every doctors has one prescriptions – one to one relationship

DATABASE TECHNOLOGIES2
iv. Every doctors has one or more patients – one to many relationship
v. Every prescriptions has many rugs – one to many relationship
vi. Every prescriptions has many one doctor – one to one relationship
vii. Every drugs are present in one or more pharmacy – one to many relationship
viii. Every drug is present on more than one prescription - one to many relationship
d. Functional dependencies
PatientID -> PatientName, Address, Age
DoctorID -> DoctorName, Speciality, YoE
PID -> PatientID, DoctorID
DrugID -> DrugName, QuantityPerStrips
PCode -> Pname, PAddress, PNum, DrugID, Price