6.3k views
4 votes
Which of the following statements is false?

A. The second step in implementing an REA diagram in a relational database is assigning attributes to appropriate tables.
B. The primary key ¿Customer Number¿ in the Customers table is a foreign key in the Sales table.
C. Tables should never be created before completely finishing an REA diagram.
D. In a relational database designed according to the REA data model, event entities store information about transactions.
E. All of the above are true.

User Rizzes
by
7.8k points

1 Answer

4 votes

Final answer:

The false statement is option C: Tables should never be created before completely finishing an REA diagram.

Therefore, option C is incorrect, and the correct answer is option C.

Step-by-step explanation:

The false statement is option C: Tables should never be created before completely finishing an REA diagram.

In reality, tables can be created before completely finishing an REA diagram. The process of implementing an REA diagram in a relational database involves four steps: (1) identifying the relevant resources, events, and agents; (2) assigning attributes to appropriate tables; (3) establishing relationships between tables using foreign keys; and (4) creating tables in the database.

Therefore, option C is incorrect, and the correct answer is option C.

The false statement is C, which asserts that tables should never be created before completely finishing an REA diagram. This is incorrect because tables can be developed iteratively while constructing an REA diagram.

The question pertains to the REA (Resource-Event-Agent) model and its implementation in a relational database. The statement that is false is C: Tables should never be created before completely finishing an REA diagram. It is entirely plausible and sometimes necessary to iteratively develop tables while constructing an REA diagram; a rigid sequence isn't a requirement. Therefore, although it's helpful to have a complete REA diagram for clarity and organization, creating tables can happen at various stages during the process. The remaining statements are generally true in the context of database design using an REA model, with A referring to the process of implementation, B describing the typical relationship between primary and foreign keys, and D explaining the function of event entities in capturing transactional information.

User Amadeus Sanchez
by
8.2k points