Entity-Relationship (ER) modeling is a popular method for representing data requirements, and for conceptual database design. This volume is for anyone designing or studying databases. Detailed real-life case studies are used to illustrate techniques for managing the complexity of database design. The ER model is used, emphasizing simplicity and readability throughout the design process. Presents a comprehensive set of semantic definitions and notations for ER models, and includes both logical and physical database design. Offers insights into database modeling, and eases the transition from the ER model to the relational model, including the building of standard SQL data definitions.