O'Reilly logo

Customer Relationship Management: Getting It Right! by Judith W. Kincaid

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required