Examine Figure and Table. Why do the Inventory, Customers, and Suppliers tables all have an attribute that contains data about the balance at the beginning of the current fiscalperiod?

Transcribed Image Text:

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