MoviesUnlimitedSolution-CF2 - Extra Practice 1 Solution...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Extra Practice 1 Solution Sales Order Sale Customer Employee Inventory Cash Cash Receipts 1 4 5 3 10 11 9 6 7 8 ZipCode 13 Shipper 12 2 15 ItemNum SalesOrderNum CustomerID ZipCode EmpID ShipperID InvoiceNum Receipt# AcctNum
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Table Name Primary Key Attributes Foreign Key tblEmployee EmpID EmployeeName, EmployeeAddress, EmployeePhone, JobTitle Zipcode tblCustomer CustomerID CustomerName, CustomerAddress, CustomerPhone, Cutomer_email, CustomerFax Zipcode tblInventory Item# InvType, ItemTitle,RetailUnitPrice, tblCash AcctNum Bankname, DateOpened tblSalesOrder SalesOrderNum SalesOrderDate, SalesOrderTime SalesOrderTotal EmpID, CustomerID
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 2

MoviesUnlimitedSolution-CF2 - Extra Practice 1 Solution...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online