Question: Draw a Relational Schema based on the following Entity Relationship Diagram below. Your relations should be normalized to the third Normal form (3NF). Be sure

Draw a Relational Schema based on the following

Draw a Relational Schema based on the following Entity Relationship Diagram below. Your relations should be normalized to the third Normal form (3NF). Be sure to use arrows from the foreign keys to their corresponding primary keys to show the referential integrity constraints

OrderHeaders Orderitems PK Orderin Date Customerpo Quantity Selling Price Inventories Sales Terms ShipMethods PK MethodID PK ItemID PK Termin Users PK UserID Term Ship Method Name Password Email Name Color Length UnitOfMeasure QtyOnhand AvgUnitCost Unit Price Sales PK Salesia Supplies SalesDate ShipDate VdrSelling Price Vdr StockNo IsApproved SalesCashReceipt Comments Vendors PK Vendor POitems Name POheaders Address Phone PK POID CashReceipts PK CR ID Contact Date Expected ShipDate Quantity VarSelling Price VdrStockNo Date CustCheckNo Amount CashDisbursements IRitems PK CD ID CD_IR IRheaders PK IRID CheckNo Date Amount Date VdrinvoiceNo Quantity VdrSelling Price Var StockNo Comments

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!