Question: Question 3 (17 points total): You are asked to consult on a database design for a company's order fulfillment process. You receive the below REA

Question 3 (17 points total): You are asked to

Question 3 (17 points total): You are asked to consult on a database design for a company's order fulfillment process. You receive the below REA model and list of data tables. Note that in the table, each column header is a separate table and the bolded items are the primary keys. You realize that none of the tables are currently related. Finish filling out the attributes that must be in each table so that it matches the REA model. You will need to add the following attributes somewhere in your database design: Sales Order Quantity: Denotes quantity of inventory item that is in a particular Sales Order Invoice Quantity: Amount of an inventory item that is in a particular Shipment (Hint: You will also need to make two additional tables. Make sure to denote the primary key(s) for your additional tables). Enter Salesperson 1 M Place Sales Orders Include M N 1 M Fulfill Inventory M N 1 N N Customers Receive Shipment Include Sales Orders Sales Order No. Sales Order Date Salesperson Salesperson No. Last Name First Name Inventory Item No. Description Customers Customer No Customer Name Street Address City State Zip Shipment Invoice No. Invoice Date Question 3 (17 points total): You are asked to consult on a database design for a company's order fulfillment process. You receive the below REA model and list of data tables. Note that in the table, each column header is a separate table and the bolded items are the primary keys. You realize that none of the tables are currently related. Finish filling out the attributes that must be in each table so that it matches the REA model. You will need to add the following attributes somewhere in your database design: Sales Order Quantity: Denotes quantity of inventory item that is in a particular Sales Order Invoice Quantity: Amount of an inventory item that is in a particular Shipment (Hint: You will also need to make two additional tables. Make sure to denote the primary key(s) for your additional tables). Enter Salesperson 1 M Place Sales Orders Include M N 1 M Fulfill Inventory M N 1 N N Customers Receive Shipment Include Sales Orders Sales Order No. Sales Order Date Salesperson Salesperson No. Last Name First Name Inventory Item No. Description Customers Customer No Customer Name Street Address City State Zip Shipment Invoice No. Invoice Date

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 General Management Questions!