User Account

All Pages

Identify all foreign keys needed in the database design

Assignment Help Accounting Basics
Reference no: EM132916342

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).

Requirements

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: Create an ER diagram using Visio include the associative tables based on your analysis.

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

Reference no: EM132916342

Questions Cloud

Children identities and continued development : What are your continued thoughts with regard to the ways in which bias and discomfort influence children's identities and continued development?
Determine the amount available for distribution : B Ltd. sold its assets on January 2, 2021, two days after its December 31, 2020 year-end for $1,300,000. Determine the amount available for distribution
How tools are effective in resolving potential conflict : Stockholders and Management Interests, Explain how your selected tools are effective in resolving potential conflicts among managers and stockholders.
Compute the cost of ending inventory : During February, Dexter sold 155 units and has 65 units left on hand at the end of the month. Compute the cost of ending inventory
Identify all foreign keys needed in the database design : Identify all foreign keys needed in the database design. Identify the attributes and primary keys needed for each of the entities.
What is the annual nominal yield to maturity on the bond : A face value of $100, and makes semiannual payments. If the price is $93.496, what is the annual nominal yield to maturity on the bond
Evaluate who are the stakeholders in the scenario : Recommend a decision. Make sure to provide the rationale for your decision. Evaluate who are the stakeholders in this scenario.
Determine cost of goods manufactured for the month : Question - A manufacturer reports the following for the month: 1,000 advertising. Determine cost of goods manufactured for the month
Oral language and listening activity presentation : Create an activity that demonstrates the oral language or listening enhancing feature of the literature selection.

Reviews

Write a Review

Accounting Basics Questions & Answers

  What is the effect on Pink Corporation

On this date, the value of the land has decreased to $500,000. What is the effect of each of the following on Pink Corporation? Which option should be selected

  Compute accrual-basis net income

Compute 2020 accrual-basis net income. Compute 2020 cash-basis net income. Blossom Industries collected $104,000 from customers in 2020.

  What is the dollar amount of inventory at the end of year

Second purchase 30 units at $3,500/unit. What is the dollar amount of inventory at the end of the year according to the last-in, first-out (LIFO) method?

  Will colin have enough money to buy the scooter

Will Colin have enough money to buy the scooter if he deposits his money in an account paying 8% compounded semi-annually

  Kopecky corp had the following balances in receivable

kopecky corp. had the following balances in receivable accounts at october 31 2012 in thousands allowance for doubtful

  What is the effect on corporation earning and eandp

What is the effect on corporation's earning and E&P. The property is subject to Liability of $10,000 which shareholder assumes.

  Determine each corporation Federal income tax liability

Three C corporations reported the following results for the calendar tax year 2019. Determine each corporation Federal income tax liability

  Compute the cost of goods destroyed

Compute the cost of goods destroyed, assuming that the gross profit is 33 1/3% of sales.(Round ratios for computational purposes to 5 decimal places)

  Discuss proprietorship business transactions

many small businesses might operate on a cash basis, most of the larger ones use the accrual basis to record business events

  What project would you recommend pursuing

Situation: A college is determining which projects to pursue in 2020. What project would you recommend pursuing based on a Payback Period Analysis

  Colasuonno corporation has two divisions the west division

colasuonno corporation has two divisions the west division and the east division. the corporations net operating income

  Prepare the stockholders equity section at December

Whispering Winds Corporation has been authorized to issue 20,000 shares of $100 par value, Prepare the stockholders equity section at December

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