Detailing the ins and outs of entity-relationship (E-R) diagramming, this comprehensive guide is an indispensable text for learning the basics of database development. This second edition features more examples throughout the text, more focused exercises, as well as more coverage of ternary and higher-order ER diagrams, generalizations, and specializations. In addition, the authors provide a new in-depth chapter on reverse engineering along with a new, detailed look at functional dependencies and normal forms.