Question 1
Which of the following is
true with regards to REA diagrams and relational databases?
◦ A well-designed relational database is the starting point for creating an REA diagram.
◦ A well-designed REA diagram minimizes update, insert or delete anomaly problem when the diagram is implemented into a relational database.
◦ REA diagrams and database design are generic across organizations.
◦ The design of a relational database is specific to the organization being modeled.
Question 2
Which of the following is
false with regards to creating database tables from an REA diagram?
◦ A properly designed relational database has a table for each distinct entity in an REA diagram.
◦ A properly designed relational database has a table for each many-to-many relationship in an REA diagram.
◦ To reduce confusion, table names should not duplicate REA diagram entities' names.
◦ Many-to-many relationships will be shown in tables with hyphenated concatenations of the entities' names.