Implementation of this REA diagram into a relational database would require how many tables?
A) 12
B) 13
C) 8
D) 9

Question

Implementation of this REA diagram into a relational database would require how many tables? 
A) 12 
B) 13 
C) 8 
D) 9

Quizplus · Accepted Answer

There are 6 entity types in the REA diagram: Customers, Orders, Products, Suppliers, Purchase Orders, and Accounts Payable. There are also 5 different relationships: 
- Customers place Orders
- Orders contain Products
- Suppliers receive Purchase Orders
- Purchase Orders contain Products
- Accounts Payable records Payments made to Suppliers

Each of these relationships must be represented by a table in a relational database, and each entity type must also be represented by a table. Therefore, the total number of tables required for implementation would be 13 (6 entity tables and 5 relationship tables).

Implementation of This REA Diagram into a Relational Database Would