Posted: February 21st, 2022

Bis 245 case study guide – small surgery center(paper sold two

 

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

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.

  • 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.
    • Use the ER matrix to determine the relationships.
  • Create an ER diagram using Visio based on your analysis.
  • Identify all foreign keys needed in the database design.
  • Create the database in Access and populate the tables.
  • To use the database as the main office application, what other entities and attributes might be needed?

NOTE: The Case Study is an individual project.

Due Week 5

  • Upload completed Visio Conceptual Design.
  • Upload completed Access database file
  • 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.

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

Expert paper writers are just a few clicks away

Place an order in 3 easy steps. Takes less than 5 mins.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00
Open chat
1
Order through WhatsApp!
affordablepaperwritings.com
Hello!
You Can Now Place your Order through WhatsApp

Order your essay today and save 30% with the discount code DISCOUNTS2022