Implementation of this REA diagram into a relational database would require how many tables?

A)12
B)13
C)8

Question

Implementation of this REA diagram into a relational database would require how many tables?

A)12 
B)13 
C)8

Quizplus · Accepted Answer

Looking at the REA diagram, we can identify 5 resource entities (Customer, Supplier, Employee, Inventory, and Cash), 3 event entities (Sales, Purchases, and Payments), and 3 agent entities (Salesperson, Purchasing Agent, and Accountant). This means that we would need at least 11 tables to implement this REA diagram in a relational database. However, we also need a table to represent the many-to-many relationships between Sales/Purchases and Products, which brings the total to 12 tables. Additionally, we might need another table to represent the relationship between employees and their supervisors, which would bring the total to 13. Therefore, the best choice is B)13 as it includes all the necessary tables for accurately representing the REA diagram.

Implementation of This REA Diagram into a Relational Database Would