BIS 245 Database in Healthcare Settings Case Study

 

https://homeworklance.com/downloads/bis-245-database-healthcare-settings-case-study/

 

To Buy above Tutorial Copy & Paste Link into Your Browser

 

To Order Original Papers written from scratch email us at ;( info.homeworklance@Gmail.com )

Or Fill order form by following this link: http://homeworklance.com/homework-help/

 

BIS 245 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.