Describe relationships between entities and their cardinalities Identify entity primary, candidate, and surrogate keys Draw a Conceptual Model Entity-Relationship diagram t 2. Logical Model Describe data attributes and their types for each entity Identify foreign keys for each entity if there are any one-to-one relationships then describe them Redesign the Conceptual model removing many-to-many relationships Draw a Logical Model diagram