Logical Database Design
The requirements analysis phase of the design process reveals the real world objects and their attributes that the database must represent as well as the relationships among them.
The logical database design phase formalizes the objects, or entities, and their relationships. Another primary task of logical design is to ensure that the modeled entities are modified by attributes that uniquely pertain to them. No attribute should appear in an entity unless it describes the uniqueness identifier for the entity, its primary key.
See Chapter 4: “Semantic Data Modeling,” for more information about logical database design.