Computer Science Homework Help

BIS 245 DeVry University Database in Healthcare Settings Case Study

 

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.

Note

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.