User Account

All Pages

Determine the relationships use the er matrix

Assignment Help Financial Accounting
Reference no: EM132502985

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:

  1. Patients can have many doctors and many doctors can see many patients.
  2. Patients can have many procedures and many procedures are done on patients.
  3. Doctors can have multiple appointments. (hint: these are many to many relationships, so associative tables need to be added)

Question 1: Please identify the attributes and primary keys needed for each of the entities.

Question 2: Identify the data types you would use for each of the attributes.

Question 3: Determine the relationships between the entities and find the one-to-many and many-to-many relationships.

Question 4: Use the ER matrix to determine the relationships.

Question 5: Create an ER diagram using Visio including the associative tables based on your analysis.

Question 6: Identify all foreign keys needed in the database design.

Question 7: Create the database and relationships in Access and populate the tables using the spreadsheets.

Question 8: To use the database as the main office application, what other entities and attributes might be needed?

Reference no: EM132502985

Questions Cloud

Post restatement of assigned position on sampling strategies : Post a restatement of your assigned position on sampling strategies. Explain why this position is the best strategy for selecting research participants.
Determine the impact of the sarbanes-oxley act : Determine the Impact of the Sarbanes-Oxley Act. Create an argument that the same goals may be achieved if the company remains a privately held entity
How to score a scale until after you have competed it : As noted in your text, chronic stress (long-term reactions to stressors) and daily hassles can be damaging to your physical and psychological health.
What is relevant costs in decision making : What is relevant costs in decision making? Please discuss a few of the things you learned and how they are important to consider when making internal business
Determine the relationships use the er matrix : 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.
Discuss about the differences of each treatment listed : Write a 750-1,000-word assignment that gives a general overview of commonly used substance use disorder treatment approaches. In addition, you are to select.
ENM3218 Fluid Mechanics Assignment : ENM3218 Fluid Mechanics Assignment Help and Solution - Edith Cowan University, ECU, Australia - Assessment Writing Service
Explain how auditors get into audit : What the metrics are? Adopt and report at least 5 or 6 key metrics the company is reporting on (sustainability metrics). (The Global Reporting Initiative
Difference between a principle and a rule : What is the difference between a profession and a professional and What is the difference between a principle and a rule

Reviews

Write a Review

Financial Accounting Questions & Answers

  Financial statement analysis and preparation

Financial Statement Analysis and Preparation

  Shareholder of a company

Describe the ways that a person can become a shareholder of a company. Why Wal-Mart would split its stock?

  Financial and accounting principles

An understanding of financial and accounting principles can be a valuable tool for managers. While not all managers will find themselves calculating financial ratios or preparing annual financial data.

  Prepare a statement of cash flow using the direct method

Prepare a Statement of Cash Flow using the Direct Method and Prepare the Operations section of the Statement of Cash Flow using the Indirect Method.

  Financial accounting assignment

This assignment has one case study and two question apart from case study. Questions related to document Liquidation question and Company financial statements question - Torquay Limited

  Prepare general journal entries for goela

Prepare general journal entries for Goela Ltd

  Principles of financial accounting

Prepare the journal entry to record the acquisition of the assets.

  Prepare general journal entries to record the transactions

Prepare general journal entries to record the transactions, assuming use of the periodic inventory system

  Global reporting initiative

Compare the view espoused by the economist Milton Friedman about the social responsibilities of business with the views express by Stigler.

  Explain the iasb conceptual frameworks

Explain the IASB Conceptual Framework's perspective of users and their decisions.

  Determine the company''s financial statements

T he focus of the report is to determine the extent to which you are comfortable relying on the financial statements as presented by management .

  Computation of free cash flow

Computation of Free Cash Flow

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