Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

14-24. Clooney and Bullock Manufacturing (Data Modeling with REA) Clooney and Bullock is large manufacturer of trophies that is headquartered in Boston, Mas sachusetts. The

image text in transcribed

14-24. Clooney and Bullock Manufacturing (Data Modeling with REA) Clooney and Bullock is large manufacturer of trophies that is headquartered in Boston, Mas sachusetts. The Entity-Relationship diagram in Figure 14-18 shows a simplified version of the company's process for purchasing and paying for equipment and supplies Requirements 1. Insert appropriate cardinalities for the relationships in the Entity-Relationship model developed with the REA data modeling approach. 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, VendorD. Include at least three fields in each table. Following is an example for the Vendor table and the Order Goods table. Vendor (lendort Name, Street Address 1, Street Address 2, City, State, Zip Code, Phone, email, Fax, Contact, Comments) Order Goods (Order*, Date, IVendor"I. lEmployee"l Shipping Instructions, Comments)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Management Accounting

Authors: Pauline Weetman

2nd Edition

0273718452, 978-0273718451

More Books

Students also viewed these Accounting questions

Question

Describe the major barriers to the use of positive reinforcement.

Answered: 1 week ago