Question: Problem 2: Design of Database Tables Based on a REA Diagram 50 points REQUIRED: You will see an REA Model on the next page. Note

 Problem 2: Design of Database Tables Based on a REA Diagram
50 points REQUIRED: You will see an REA Model on the next

Problem 2: Design of Database Tables Based on a REA Diagram 50 points REQUIRED: You will see an REA Model on the next page. Note the event labeled Sales Shipment is linked to several other Shipment. Fine Jewelry is sold to the public. Sales agents, resources, and events in this diagram. In designing the database, how is Sales Shipment linked to these other relations? Design complete database tables that show the relationships between Sales Shipment and these other objects. One table should be designed for the event Sales Shipment and one for each relation (R, E or A) that is linked to this event. A complete database table includes a primary key, foreign keys (if indicated by the cardinalities), and 4 attributes per table. A key is not an attribute. A relationship table will not require 4 attributes Include any tables that are needed to implement the relationships. Include ONLY THE LINKS BETWEEN Sales Shipment AND THESE relations-do not design all the tables indicated by this diagram. You may design tables horizontally or vertically-as if you are looking at the relationship grid in Access. Do not forget to label primary and foreign keys

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!