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 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
Get step-by-step solutions from verified subject matter experts
