employee number, rental number Rent Equipment Rental number Date, time, vendor number, employee number Disburse Cash number Date, amount, GL Account number, Employee number, Vendor number Employee Employee number Name, date hired, pay rate Vendor Vendor number Name, address, beginning balance Rented Equipment Rent Equipment number, rental quantity – Equipment number Rented Equipment Return Equipment number, return quantity – Rented Items number SUGGESTED ANSWERS TO THE CASES Case 19.1 This case involves creating a database from an integrated REA diagram and then using the REA diagram to guide the writing of queries to prepare financial statements. Required a. Create the tables necessary to implement Figure 19-9 in a relational database. Be sure to include primary keys and other relevant attributes in each table. Other Attributes (foreign keys in Table Name Primary Key(s) others in normal font) italics, Customer Customer number Name, address, phone, beginning account balance, credit limit Employee Employee number Name, date hired, wage rate, date of birth, position Take Customer Order Sales Order Number Customer number, employee number, date, amount Sales Invoice Number Customer number, employee number, date sales order number, Receive Cash Remittance Number Customer number, employee number, date, amount GLAccount number, Finished Goods Item Number Name, Description, beginning quantity Inventory on hand, standard cost, list price
employee number, rental number Rent Equipment Rental number Date, time, vendor number, employee number Disburse Cash number Date, amount, GL Account number, Employee number, Vendor number Employee Employee number Name, date hired, pay rate Vendor Vendor number Name, address, beginning balance Rented Equipment – Rent Equipment Equipment number, rental number quantity Rented Equipment – Return Rented Items Equipment number, return number quantity SUGGESTED ANSWERS TO THE CASES Case 19.1 This case involves creating a database from an integrated REA diagram and then using the REA diagram to guide the writing of queries to prepare financial statements. Required a. Create the tables necessary to implement Figure 19-9 in a relational database. Be sure to include primary keys and other relevant attributes in each table. Table Name Primary Key(s) Other Attributes (foreign keys in italics, others in normal font) Customer Customer number Name, address, phone, beginning account balance, credit limit Employee Employee number Name, date hired, wage rate, date of birth, position Take Customer Order Sales Order Number Customer number, employee number, date, amount Sales Invoice Number Customer number, employee number, sales order number, date Receive Cash Remittance Number Customer number, employee number, GLAccount number, date, amount Finished Goods Inventory Item Number Name, Description, beginning quantity on hand, standard cost, list price
rais12_SM_CH19.docx