Running Head: DATABASE DESIGN 1
Database Design
BIS245
Case Study
Week 5 report
, DATABASE DESIGN 2
DATABASE DESIGN
Primary Keys and Attributes
The primary keys will be the followings:
DoctorID
AppointmentID
MedicalProcedureID
and PatientID.
Attributes for each entity
▪ Patient entity: Names, Contact, DOB, InsuranceID Sex, and Phone.
▪ Doctor entity: DoctorID, DoctorName, and Speciality.
▪ Appointment entity: AppointmentID, DoctorID, Patient ID, Date, and Time.
▪ Medical Procedure entity: MedicalProcedureID, OrderNumber, PatientID, DoctorID,
and TreatmentID
▪ Treatment entity: Treatment ID, TreatmentFee, TreatmentName
Entity Relationships
Here it shows that the patient can have many doctors meaning of, (one to many relationship).
The doctor can order several tests (one to many relationship). One doctor can perform a
single procedure (one to one relationship).
Database Design
BIS245
Case Study
Week 5 report
, DATABASE DESIGN 2
DATABASE DESIGN
Primary Keys and Attributes
The primary keys will be the followings:
DoctorID
AppointmentID
MedicalProcedureID
and PatientID.
Attributes for each entity
▪ Patient entity: Names, Contact, DOB, InsuranceID Sex, and Phone.
▪ Doctor entity: DoctorID, DoctorName, and Speciality.
▪ Appointment entity: AppointmentID, DoctorID, Patient ID, Date, and Time.
▪ Medical Procedure entity: MedicalProcedureID, OrderNumber, PatientID, DoctorID,
and TreatmentID
▪ Treatment entity: Treatment ID, TreatmentFee, TreatmentName
Entity Relationships
Here it shows that the patient can have many doctors meaning of, (one to many relationship).
The doctor can order several tests (one to many relationship). One doctor can perform a
single procedure (one to one relationship).
