Table of Contents
**Only Milestone 1**
Case Study Overview
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).
Requirements
- Please 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.
- Create an ER diagram using Visio include 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 (unless your Professor wants you to type the data into the tables).
- Write a 3-5-page APA paper discussing the following topics:
- Discuss Database impact on the workplace,
- Discuss database benefits when businesses use querie,
- Forms, and reports.
- Discuss at least two security concerns should be discussed with a proposed solution to mitigate the security issues.
The Case Study is an individual project that has two project Milestones. Milestone 1 is due Week 4 and Milestone 2 is due Week 8.
Case Study Files
Please download the Case Study Files (Links to an external site.) needed for this assignment.
Grading Rubrics
Milestone 1 – Due Week 4 – 50 Points
Step | Task | Points |
---|---|---|
1a | Primary key identified for each entity (four tables): patients, doctors, procedures and appointments | 5 |
1b | Attributes identified for each entity (four tables): patients, doctors, procedures and appointments | 5 |
2 | Data Types | |
2a | Identified data types | 5 |
3 | Relationships | |
3a | Identify one-to-many relationships | 5 |
3b | Identify many-to-many relationships | 5 |
4 | Foreign Keys | |
4a | Add foreign keys to tables as needed | 10 |
5 | ER Diagrams | |
5a | Create an ER diagram using Visio | 15 |
Total | 50 |
Milestone 2 – Due Week 8 – 90 Points
Step | Task | Points |
---|---|---|
6 | Create and Populate the Database | |
6a | Create the tables and relationships in Access | 15 |
6b | Integrate the data from the spreadsheets | 20 |
6c | Create query 1 – Create an 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 professor | 10 |
6d | Create query 2. – Multiple criterion query | 10 |
6e | Create query 3. – Crosstab query | 10 |
7 | Written report | |
7a | Discuss database benefits when businesses use queries, forms, and reports | 10 |
7b | Discuss at least two security concerns should be discussed with a proposed solution to mitigate the security issues | 10 |
7c | Edit, spellcheck, and list references | 5 |
Total | 90 |
What Students Are Saying About Us
.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐"Honestly, I was afraid to send my paper to you, but you proved you are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"
.......... Customer ID: 11***| Rating: ⭐⭐⭐⭐⭐
"This company is the best there is. They saved me so many times, I cannot even keep count. Now I recommend it to all my friends, and none of them have complained about it. The writers here are excellent."