Logical Database using Entity Relationship Diagram (ERD)

How to use Entity–Relationship (ER) modeling in database design.
Basic concepts associated with ER model.
Diagrammatic technique for displaying ER model using Unified Modeling Language (UML).
How to identify and resolve problems with ER models called connection traps.
How to build an ER model from a requirements specification.