BIS 245 Case Study/ Case Study Database Design BIS 245 DeVry University

Case Study Database Design BIS 245 DeVry University CASE STUDY – DATABASE DESIGN Case Study Database Design BIS 245 DeVry University 2 CASE STUDY – DATABASE A small surgery center requires a new database. DESIGN 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 detail the entities, their attributes, the data types of each attribute, if the attribute is a primary or foreign key and whether or not the attribute is required