Universal Containers (UC) stores information about its containers in the standard
Salesforce Product object. UC deals with data integrity issues, such as the Container Color
field fails to update on all containers when the color is updated on a Container Product
Line. The project owner mentioned that a previous consultant recommended that UC move
to a more normalized data model to represent its containers.
What should the business analyst review to learn more about the previous consultant's
recommendation?
A. Entity Relationship Diagram (ERD)
B. System requirements specification
C. Change request logs
A. Entity Relationship Diagram (ERD)
Explanation:
The reference that the business analyst should consult to learn more about
the previous consultant’s recommendation is an Entity Relationship Diagram (ERD). An
ERD is a diagram that shows the logical structure and relationships of data entities in a
database or system. An ERD helps to model and document how data entities are
organized, connected, and interact with each other. An ERD also helps to normalize data
entities by reducing redundancy and inconsistency in data storage and retrieval. The
previous consultant recommended that Universal Containers move to a more normalized
data model to represent its containers, which means that they wanted to avoid storing
duplicate or unnecessary data in multiple tables or fields. The business analyst should
consult an ERD to learn more about how the previous consultant proposed to design and
implement a more normalized data model for Universal Containers.