BIS 245 Team Case Study DATABASE DESIGN
BIS245 Team Case Study DATABASE DESIGN Primary Keys and Attributes The primary keys will include, 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 We understand that the patient can have many doctors (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).
Información del documento
- Subido en
- 12 de marzo de 2021
- Número de páginas
- 5
- Escrito en
- 2020/2021
- Tipo
- Caso
- Profesor(es)
- N\\a
- Grado
- A+
