User Account

All Pages

Help to design database

Assignment Help Business Management
Reference no: EM131652274

Scenario

A small surgery center needs your help to design database. The office manager has identified the following types of data (entities): Patients, Doctors, Procedures and Appointments.

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

Activities

  1. Complete the case study's tasks which includes a completed Access database, Visio diagram, and a Word file reporting the results of the analysis and the additional entities needed to use the database as the main office application.

Reference no: EM131652274

Questions Cloud

Important element of organizational strategy : Organizational structure is an important element of organizational strategy.
Calculate your taxable income for this year : Two years ago, you had a net loss of $95,000 and last year, you had a net loss of $70,000. Calculate your taxable income for this year
Probability that an emergency call is received : If a unit is busy when an emergency call is received, the call is immediately routed to another service. The company is considering buying a second ambulance.
Complete the task to configure a printer : Describe the process that you used to complete the task to configure a printer. Desrcibe whether the processes that were followed to complete
Help to design database : A small surgery center needs your help to design database. The office manager has identified the following types of data (entities): Patients
Steering committee to evaluate the security risks : Security Steering Committee Must post first. You are in charge of forming a steering committee to evaluate the security risks at a hospital.
Find probability that a randomly sampled battery will last : What is the probability that a randomly sampled battery of this type will last between 15 and 17 hours?
Difference between odbc and jdbc database interfaces : What is the difference between ODBC and JDBC database interfaces? Why is it important to have effective and powerful interfaces like these for databases?
How would you make sure they are properly trained : As the Office Manager, how would you make sure they are properly trained?

Reviews

Write a Review

Business Management Questions & Answers

  Identify how your recommended hr strategies will promote

Possible HR strategies that will support each organizations mission, vision, values and core business practices for each company. Support your recommendations.

  What tool are use to measure effectiveness of ethics program

Competency 310.2.3- What tools are used to measure the effectiveness of your ethics program? What is the frequency of review? Who will conduct the review? How will improvements be implemented?

  What is the most important problem facing visa

Strategic Management and Business Policy - What is the most important problem facing VISA

  What strategies do readings suggest for aligning business

What is marketing? Why is important? Review the Readings. Consider how marketing strategies and orientation might contribute to or reduce an organisation's profitability. What strategies do the Readings suggest for aligning business and marketing ..

  Environmental preservation and behaviors

Considering what you've learned in this course, outline the three most important aspects of the environment that we should protect at the highest priority. How do your current behaviors affect these three things? What can you do to change your beh..

  Function of demand and supply

Economic theory generally holds that in competitive markets price is a function of demand and supply.

  Development of ambulatory care centers

what can you do to forge positive relationships with other health care providers? How can you defend accepting certain patients while denying others service in your facility?

  Winner''s curse

In section 1 of your document, you should examine where, when, and by who your particular research topic was conceived and what it 'looked' like at that time. Your research should include the seminal work that laid the foundation for your topic.

  Model and come up with a vialble replacement solution

You have been asked to research replacement desktops for our Dell Optiplex 755 systems running 4GB of RAM with 500GB of storage. Take time to research this model and come up with a vialble replacement solution.

  Describe the difference between efficiency and effectiveness

Describe the difference between efficiency and effectiveness and identify real organizations you think are, or are not, efficient and/or effective?

  Antidumping duties for prevent unfair trading practices

The World Trade Organization was founded in January of 1995 to improve trade interactions between nations. Unfortunately, the WTO does not eliminate all unfair trading practices.

  Describe porter 5 forces model

Describe Porter's 5 forces model, give at least one example of each force, and explain which force you believe to be most important in the competitive environment.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd