Describe the attributes for each database table

Assignment Help Accounting Basics
Reference no: EM132597721

Clooney and Bullock is a large manufacturer of trophies that is headquartered in Boston, MA. The Entity-Relationship diagram on the next page shows a simplified version of the company's process for purchasing and paying for equipment and supplies.

Required:

Question 1. Insert appropriate cardinalities for the relationships in the Entity-Relationship model developed with the REA data modeling approach.

Question 2. Describe the attributes for each database table that would be created using this model. You will need a table for each entity as well as one or more relationship tables. Identify the table name, and then include all attributes within parentheses. Next, indicate the primary key by underlining it. Show any foreign keys by framing them in brackets (e.g., [Vendor#1]). Include at least three fields in each table. Following is an example for the Vendor table and the Order Goods table

 

Reference no: EM132597721

Questions Cloud

Develop a list of topics that non-purchasing personnel : Develop a list of topics that non-purchasing personnel should be allowed to talk about with their counterparts at suppliers.
Describe the potential benefits to the organization : Your overall thoughts of the potential benefits to the organization by implementing your change recommendations. References for all slides (full APA formatted).
How to determine the revenue in year one : Payments of P59,300 each year to start on December 31, 20x3. The project is 60% complete by the end of year 1. Determine the revenue in year 1.
Explain why celebrating innovations is important : Explain why celebrating innovations is important four (4) wayscelebrate and in which you as a leader can successful innovations.
Describe the attributes for each database table : Describe the attributes for each database table that would be created using this model. You will need table for each entity as well as one or more relationship
Research on legislations relating to sustainability : Conduct your own research on legislations relating to sustainability.
What are the qualifications of the authors : Knowledge about the issues you are trying to solve for Sun Coast.
Affordable Care Act : As the Federal Government continues to discuss the various types of health care reform such as the Affordable Care Act (ACA),
What is the total revenue to be reported by the franchisor : On january 1, 2021 a franchisor entered into a franchise, What is the total revenue to be reported by the franchisor for the year ended December 31, 2021?

Reviews

Write a Review

Accounting Basics Questions & Answers

  From past experience the company has learned that 20 of a

silver company makes a product that is very popular as a mothers day gift. thus peak sales occur in may of each year as

  What price per unit would have been charged to the customer

If the job contained 520 units and the company billed at 60% above the unit product cost on the job cost sheet, what price per unit would have been charged to the customer?

  Evaluating a capital expenditure proposal

Mouser Company is evaluating a capital expenditure proposal with the following predicted cash flows

  Enter the overhead costs incurred and the amounts applied

in december 2012 a company established its predetermined overhead rate for movies produced during year 2013 by using

  Compute the ending inventory for martin company

Compute the ending inventory for Martin Company for 2007 through 2012 using the dollar-value LIFO method

  Analysis of the report of the special investigative

ACCT -Report Summary and Analysis of the Report of the Special Investigative Committee of the Board of Directors of Enron Corporation (Powers Report) and Description of the related party transactions reported on by Arthur Andersen & Co.

  Did ahmad and partner owe a duty of care to xing investments

Did Ahmad and Partner owe a duty of care to Xing Investments? What are some of the arguments Ahmad & Partners could make in their defence?

  What is the combined present value of cash flows

Moving Cash Flow You are scheduled to receive a $440 cash flow in one year, a $740 cash flow in two years, and pay a $340 payment in three years.

  Morgan leasing company signs agreement on january 1 2014 to

morgan leasing company signs an agreement on january 1 2014 to lease equipment to cole company. the following

  How should vivian and melvin record these transactions

As of December 31, year 2, Melvin still has not transferred title to the building, How should Vivian and Melvin record these transactions

  Prepare the journal entries for perry company

Prepare the journal entries for Perry Company for (a) the initiation of the loan, (b) the recognition of interest expense for the quarter

  Report its operating activities according to direct method

Refer to Kazaam Company's financial statements and related information in Problem. Required Prepare a complete statement of cash flows.

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!

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