Database Design Using Entity-Relationship Diagrams / Edition 1

Hardcover (Print)
Buy New
Buy New from
Used and New from Other Sellers
Used and New from Other Sellers
from $8.35
Usually ships in 1-2 business days
(Save 90%)
Other sellers (Hardcover)
  • All (2) from $8.35   
  • Used (2) from $8.35   


Entity-relationship (E-R) diagrams are time-tested models for database development well-known for their usefulness in mapping out clear database designs. Also commonly known is how difficult it is to master them. With this comprehensive guide, database designers and developers can quickly learn all the ins and outs of E-R diagramming to become expert database designers. Because E-R diagrams are so fundamental to database design, this book is also an indispensable text for teaching computer science students the basics of database development.

Database Design Using Entity-Relationship Diagrams clarifies E-R diagramming by defining it in terms of requirements (end user requests) and specifications (designer feedback to those requests). The book explains how open communication between designers and end users is critical to developing usable, easy-to-understand E-R diagrams that model both requirements and specifications.

The authors explain, in an intuitive, informal manner, how to develop an E-R diagram, how to map it to a database, and how the resulting database can be tested. This definitive guide is a basic component for any database course, and is also an invaluable reference that database professionals can use throughout their careers.

Read More Show Less

Product Details

  • ISBN-13: 9780849315480
  • Publisher: CRC Press
  • Publication date: 5/28/2003
  • Series: Foundations of Database Design Series , #2
  • Edition description: New Edition
  • Edition number: 1
  • Pages: 242
  • Product dimensions: 7.10 (w) x 10.20 (h) x 0.76 (d)

Table of Contents

The Software Engineering Process and Relational Databases
What is data and what is a database?
What is the software engineering process?
ER Diagrams and the Software Engineering Life Cycle Data Models The Hierarchical Model The Network Model The Relational Model Functional Dependencies - this section will be expanded significantly Summary of Chapter Exercises for Chapter 1

Normal Forms
First Normal Form Second Normal Form Third Normal Form Examples of lNF, 2NF and 3NF Example of Non lNF to lNF Example of Non 2NF to 2NF Example of Non 3NF to 3NF Summary of Chapter Exercises for Chapter 1

The Basic ER Diagram - A Data Modeling Schema
What is a data modeling schema?
Defining the database - some definitions: entity, relationship, attribute A Beginning Methodology ER Design Methodology A First "Entity only" ER Diagram More about Attributes The Simple or Atomic Attribute The Composite Attribute The Multi-valued Attribute The Derived attribute The Keys English Description of the Entity The Method Mapping the Entity Diagram to a Relational Database Summary of Chapter Exercises for Chapter 3
References Case Study

Beyond the First Entity Diagram
Examining an Entity - Changing An Attribute to be an entity Defining a relationship for our new entity A Preliminary Grammar for the ER diagrams Defining a Second Entity Does a Relationship Exist?
Attribute or relationship?
Summary of Chapter Exercises for Chapter 4
References Case Study

Extending Relationships/Structural Constraints
The Cardinality Ratio of a Relationship Participation - Full/Partial English Descriptions Tighter English Some examples of other relationships One Final Example Mapping Relationships to a Relational Database Summary of Chapter Exercises for Chapter 5
References Case Study

The Weak Entity
Strong and Weak Entities Weak Entities and Structural Constraints Weak Entities and the Identifying Owner Another example or a Weak entity and the identifying owner Weak Entities connected to other Weak Entities Revisiting the Methodology Weak Entity Grammar Mapping Weak Entities to a relational database Summary of Chapter Exercises for Chapter 6
Reference Case Study

Further Extensions for ER Diagrams with Binary Relationships
Attributes of Relationships Relationships developing into Entities: The M:N Relationship Revisited More Entities and Relationships More Evolution of the Database Attributes That Evolve into Entities Recursive Relationships Multiple Relations The Derived or Redundant Relation An alternative ER Notation for specifying Structural Constraints on Relationships Review of the Methodology Mapping rules for Recursive Relationships Summary of Chapter Exercises for Chapter 7
References Case Study

Ternary and Higher Order ER Diagrams
Binary or Ternary Relationship?
Ternary Relationships and Structural Constraints n-ary Relations do not preclude binary relations Methodology and Grammar for the n-ary Relationship Ternary Relationships from relationship-relationship situations n-ary Relationships May be Resolved into Binary Relationships Mapping to ternary diagrams to a relational database Summary of Chapter Exercises for Chapter 8

Generalizations and Specializations
What is a Generalization or Specialization?
A Problem with Variants Example of a Generalization/Specialization Methodology and Grammar in Generalization/Specialization relationships Mapping rules for EER Diagrams Summary of Chapter Exercises for Chapter 9
References Case Study

Relational Mapping and Reverse Engineering ER Diagrams
Steps used to map an ER diagram to a Relational Database Reverse Engineering Examples of Reverse Engineering Summary of Chapter References Exercises for Chapter 10

A Brief Overview of the Barker/Oracle-like Model
A First "Entity only" ER Diagram - An Entity with Attributes Attributes in the Barker/Oracle-like model Relationships in the Barker/Oracle-like model Structural constraints in the Barker/Oracle-like model Dealing with the concept of the weak entity in the Barker/Oracle-like model Dealing with the concept of multivalued attributes in the Barker/Oracle-like model Treatment of Foreign keys Recursive relationships in the Barker/Oracle-like model Mapping M:N relations Summary of Chapter Exercises for Chapter 11
References Glossary


Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Terms of Use.
  • - Barnes & reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)