BIS 245 Week 8 Assignment | Devry University
- Devry University / BIS 245
- 30 Aug 2021
- Price: $17
- Computer Science Assignment Help / Microsoft Office Assignment Help
BIS 245 Week 8 Assignment | Devry University
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
1. Please identify the
attributes and primary keys needed for each of the entities.
2. Identify the data
types you would use for each of the attributes.
3. Determine the
relationships between the entities and find the one-to-many and many-to-many
relationships.
4. Create an ER
diagram using Visio include the associative tables based on your analysis.
5. Identify all
foreign keys needed in the database design.
6. 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).
7. Write a 3-5-page
APA paper discussing the following topics:
a. Discuss Database
impact on the workplace,
b. Discuss database
benefits when businesses use querie,
c. Forms, and reports.
d. Discuss at least
two security concerns should be discussed with a proposed solution to mitigate
the security issues.