DATA MODEL Take Customer H Employee Order Customer Inventory Sales H Employee Receive H Customer Cash Cash house Employee Order (Purchasing Inventory Inventory Clerk) emsipsid A3 Supplier Receive Employee Inventory (Receiving Clerk) H Supplier Cash Disburse Employee Cash H (Cashier)TABLE 18-1 Table Names and Attribute Placement for Figure 18-4 ATTRIBUTES TABLES PRIMARY KEY FOREIGN KEYS OTHER ATTRIBUTES Order Inventory Purchase order number Supplier number, employee Date, time, reason number Receive Inventory Receiving report number Supplier number, employee Date, time, remarks, vendor invoice number, purchase order number number, check number Disburse Cash Check number Supplier number, employee Amount, description, date number (payee), employee number (signer), account number Take Customer Order Sales order number Customer number, employee Date, time, special remarks number Sales Invoice number Customer number, employee Date, time, invoice sent (Y/N) number, sales order number Receive Cash Remittance number Customer number, employee Date, time, method of payment number, account number Time Worked Timecard number Employee number, supervisor Date, time in, time out number, paycheck number Inventory Product number Description, list price, standard cost, beginning quantity-on-hand, beginning quantity-available, reorder quantity, reorder point Cash Account number Beginning-balance, type of account Employees Employee number Name, date hired, date of birth, pay rate, job title Customers Customer number Name, address,a beginning account balance, credit limit Suppliers Supplier number Name, address, a beginning account balance, performance rating Order Inventory- Purchase order number, Quantity ordered, actual unit cost Inventory product number Receive Inventory- Receiving report number, Quantity received, condition Inventory product number Take Customer Sales order number, Quantity ordered Order-Inventory product number Sales-Inventory Invoice number, product Quantity sold, actual sale price number Sales-Receive Cash Invoice number, remit- Amount applied to invoice tance number