This case involves creating a database from an integrated REA diagram and then using the R...

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 in a relational database. Be sure to include primary keys and other relevant attributes in each table.

---

b. Write the query, or set of queries, necessary to generate as many elements of financial statements as possible. For example, write the query or set of queries that would be used to calculate the amount of cash on hand, the total of accounts receivable, the total value of raw materials inventory on hand.

FIGURE Integrated, Enterprise-wide REA Diagram