The Designer's View is where the handoff between business knowledge and IT knowledge takes place. Let's review the process that XYZ used to identify the entities, attributes, and relationships for Valencia.
Develop a list of the characteristics (attributes) we want to collect and store about each of the project data subjects; identify and eliminate duplicates.
Assign each attribute to the data subject it describes; these are candidate entities.
Identify the KEY for each candidate entity.
Apply entity rules to determine whether all the related attributes can be stored in one entity or whether we need to define more than one.
Identify entity relationships.
Define entities, attributes, and relationships. ...