Draw  Relational Schema based on the following Entity Relationship Diagram (conceptual data model) on the second page. 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.

 

Users PK UserID Name Password Email CashReceipts PK CR_ID Date Sales Terms PK TermID CustCheckNo Amount Sales CashReceipt Term Comments Sales PK SalesID SalesDate ShipDate ShipMethods PK MethodID Vendors PK Vendor D CheckNo Date Amount CashDisbursements PK CD ID OrderHeaders Name Address Phone Contact PK Order D ShipMethod Date CustomerPO CD_IR Supplies Comments VdrSelling Price VdrStockNo IsApproved PK PO ID Date POheaders Orderitems ExpectedShipDate PK Quantity Selling Price IRheaders IR ID Date VdrinvoiceNo Inventories PK ItemID Name Color Length UnitOfMeasure QtyOnhand AvgUnitCost UnitPrice POitems Quantity VdrSelling Price VdrStockNo IRitems Quantity VdrSelling Price VdrStockNo