Clooney and Bullock is large manufacturer of trophies that is headquartered in Boston, Massachusetts. The Entity-Relationship diagram in Figure 7-20 shows a simplified version of the company’s process for purchasing and paying for equipment and supplies.
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., [Vendor#]). Include at least three fields in each table. Below is an example for the Vendor table and the Order Goods table. Vendor (Vendor#, Name, Street Address 1, Street Address 2, City, State, Zip Code, Phone, email, Fax, Contact, Comments)
Order Goods (Order#, Date, [Vendor#], [Employee#], Shipping Instructions, Comments)