Implementation Example - The Logical Model This is what your logical model should look like. Table Name, Primary Key, Foreign Keys, Non-key Attributes tblInventory: Item#, Description, Standard Cost, List Price, QOH, Beg QOH Date tblCash: Acct#, Bank, Acct #, Acct Type, Beg Cash Bal, Beg Cash Bal Date tblCustomer: CustomerID, First Name, Last Name, Street Address, City, State, Zip, Cell#, Credit limit, Email tblSalesperson: SalesClerk#, First Name, Last Name, Street Address, City, State, Zip, Cellphone#, Birth date, Marital status, start date, salary, SS# tblSales: Sale#, [CustomerID], [SalesClerk#], Date tblRecCash: CR#, [CustomerID], [SalesClerk#], [Sale#], [Acct#], Date, Amt Rec'd tblSales/Inventory: [Sale#] [Item#], Qty Sold,St. Francis Olive Oil Company Request Items Inv Manager Purchase Clerk Inventory Order Items Vendor Receive Items It Warehouse Worker Cashier Cash Pay Vendors Return Items