Building a Logical Model

Summary

In this chapter, you saw the iterative nature of the process by which you’ve drawn up this model. You poured over each entity and its attributes to ensure that the definitions and relationships you have are accurate and make sense. The key steps in the creation of a Logical model are as follows:

• 1. Reinforce the scope of your analysis often.

• 2. Determine the logical entities from your conceptual entities.

• 3. Define attributes for your entities.

• 4. Discover primary keys.

• 5. Verify the relationships between entities.

• 6. Double-check all you’ve done in light of your business rules and normal forms.

• 7. Validate your work against as many sources as possible, such as instance tables, SMEs, and model reviews.