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 fiscal period?
FIGURE Integrated REA Diagram for Fred’s Train Shop
TABLE Table Names and Attribute Placement for Figure
ATTRIBUTES | |||
TABLES | PRIMARY KEY | FOREIGN KEYS | OTHER ATTRIBUTES |
Order Inventory | Purchase order number | Supplier number, employee number | Date, time, reason |
Receive Inventory | Receiving report | Supplier number, employee number, purchase order number, check number | Date, time, remarks, vendor invoice number |
Disburse Cash | Check number | Supplier number, employee umber (payee), employee number (signer), account number | Amount, description, date |
Take Customer | Sales order number | Customer number, employee number | Date, time, special remarks |
Sales | Invoice number | Customer number, employee number, sales order number | Date, time, invoice sent (Y/N) |
Receive Cash | Remittance number | Customer number, employee number, account number | Date, time, method of payment |
Time Worked | Timecard number | Employee number, supervisor number, paycheck number | Date, time in, time out |
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—Inventory | Purchase order number, product number | Quantity ordered, actual unit cost | |
Receive Inventory—Inventory | Receiving report number, product number | Quantity received, condition | |
Take Customer Order—Inventory | Sales order number, product number | Quantity ordered | |
Sales—Inventory | Invoice number, product number | Quantity sold, actual sale price | |
Sales—Receive Cash | Invoice number, remittance number | Amount applied to invoice |
a Actually, only the street address and Zip code would be stored in these tables. In both tables Zip code would be a foreign key. Zip code would also be the primary key of an “address table,” which would also include city and state as other attributes.
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.