Homework
A small surgery center needs your help to create a database. The office manager has identified the following types of data (entities): patients, doctors, procedures and appointments using the following business rules:
Patients can have many doctors and many doctors can see many patients.
Patients can have many procedures and many procedures are done on patients.
Doctors can have multiple appointments. (hint: these are many to many relationships, so associative tables need to be added)
• Identify the attributes and primary keys needed for each of the entities.
• Identify the data types you would use for each of the attributes.
• Determine the relationships between the entities and find the one-to-many and many-to-many relationships.
o Use the ER matrix to determine the relationships.
• Create an ER diagram using Visio including the associative tables based on your analysis.
• Identify all foreign keys needed in the database design.
• Create the database and relationships in Access and populate the tables using the spreadsheets.
• To use the database as the main office application, what other entities and attributes might be needed?
Format your homework according to the give formatting requirements:
• The answer must be using Times New Roman font (size 12), double spaced, typed, with one-inch margins on all sides.
• The response also includes a cover page containing the student's name, the title of the homework, the course title, and the date. The cover page is not included in the required page length.
• Also include a reference page. The references and Citations should follow APA format. The reference page is not included in the required page length.