Scenario

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).

StepTaskPoints6Create and Populate the Database

6a) Create the tables and relationships in Access15

6b) Integrate the data from the spreadsheets20

6c) Create query 1 - Create any Action query 1 - Action queries can delete records, update data, append data from one or more tables to another table, and make a new table. See your professor1

6d) Create query 2. - Multiple criterion query10

6e) Create query 3. - Crosstab query or create a Form of your choice10

7Written report

7a) Discuss database benefits when businesses use queries, forms, and reports10

7b) Discuss at least two security concerns should be discussed with a proposed solution to mitigate the security issues10

7c) Edit, spellcheck, and list references5Total