by Sikha Saha Bagui, Richard Walsh Earp
Essential to database design,
entity-relationship (ER) diagrams are known for their usefulness in
data modeling and mapping out clear database designs. They are also
well-known for being difficult to master. With Database Design Using
Entity-Relationship Diagrams, Third Edition, database designers,
developers, and students preparing to enter the field can quickly learn
the ins and outs of data modeling through ER diagramming.
Building
on the success of the bestselling first and second editions, this
accessible text includes a new chapter on the relational model and
functional dependencies. It also includes expanded chapters on Enhanced
Entity-Relationship (EER) diagrams and reverse mapping. It uses
cutting-edge case studies and examples to help readers master database
development basics and defines ER and EER diagramming in terms of
requirements (end user requests) and specifications (designer feedback
to those requests), facilitating agile database development. This book
- Describes a step-by-step approach for producing an ER diagram and developing a relational database from it
- Contains exercises, examples, case studies, bibliographies, and summaries in each chapter
- Details the rules for mapping ER diagrams to relational databases
- Explains how to reverse engineer a relational database back to an entity-relationship model
- Includes grammar for the ER diagrams that can be presented back to the user, facilitating agile database development
The
updated exercises and chapter summaries provide the real-world
understanding needed to develop ER and EER diagrams, map them to
relational databases, and test the resulting relational database.
Complete with a wealth of additional exercises and examples throughout,
this edition should be a basic component of any database course. Its
comprehensive nature and easy-to-navigate structure make it a resource
that students and professionals will turn to throughout their careers.
