Database Design Using Entity-Relationship Diagrams, Second Edition

Sikha Bagui, Richard Earp

Hardback
$67.16

eBook
from $38.00

September 7, 2011 by Auerbach Publications
Textbook - 371 Pages - 130 B/W Illustrations
ISBN 9781439861769 - CAT# K12857
Series: Foundations of Database Design

FREE Standard Shipping!

was $83.95

$67.16

SAVE $16.79

Add to Cart
Add to Wish List

Features

  • Demonstrates testing of a newly-constructed database via the theory of normal forms and referential integrity constraints
  • Provides a data modeling schema that defines entities, relationships, attributes
  • Discusses structural constraints in relationships
  • Includes corresponding grammar and mapping rules
  • Explores generalizations and specializations
  • Illustrates a reverse mapping design for mapping a relational database backward to an ER diagram--performed when database is in use but no diagram exists

Summary

Essential to database design, entity-relationship (ER) diagrams are known for their usefulness in mapping out clear database designs. They are also well-known for being difficult to master. With Database Design Using Entity-Relationship Diagrams, Second Edition, database designers, developers, and students preparing to enter the field can quickly learn the ins and outs of ER diagramming.

Building on the success of the bestselling first edition, 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).

  • 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

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 makes it a resource that students and professionals will turn to throughout their careers.

Instructors

We provide complimentary e-inspection copies of primary textbooks to instructors considering our books for course adoption.

Request an 
e-inspection copy

Share this Title