BIS 245: Case Study Guide - Small Surgery Center - DeVry University, Chicago
BIS 245: Case Study Guide - Small Surgery Center - DeVry University, ChicagoA small surgery center requires a new database. The office manager has identified the following types of data: patients, doctors, procedures and appointments. From this data requirement the following main entities have been created: Patient, Doctor, Appointment and Procedure. The relationships between the main entities can be explained as follows: • Doctors can see many patients (many to many relationship) • Patients can have many procedures (many to many relationship) • Doctors can service many appointments (many to many relationship) Due to the multiple many to many relationships between the main entities, then it is necessary to create associative tables to join the main tables together. The associative tables are: Join Patient Procedure, Join Doctor Patient and Join Doctor Appointment. The following tables
Document information
- Uploaded on
- June 7, 2022
- Number of pages
- 6
- Written in
- 2020/2021
- Type
- Case
- Professor(s)
- Master
- Grade
- A