The requirements analysis phase of the design process reveals the real world objects and their attributes that the database must represent and the relationships among them.
The logical database design phase formalizes the objects, or entities, and their relationships. Another primary task of logical design is normalization to make sure, for example, that the modeled entities are modified by attributes that uniquely pertain to them.