Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started