D.4. Designer's View: Entities and Relationships

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.

  1. Develop a list of the characteristics (attributes) we want to collect and store about each of the project data subjects; identify and eliminate duplicates.

  2. Assign each attribute to the data subject it describes; these are candidate entities.

  3. Identify the KEY for each candidate entity.

  4. 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.

  5. Identify entity relationships.

  6. Define entities, attributes, and relationships. ...

Get Customer Relationship Management: Getting It Right! now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.