Foundations of database
www.dbeBooks.com design
- An Ebook series
Library
Foundations of database design series
Database Design Using Entity-Relationship Diagrams
by Sikha Bagui and Richard Earp ISBN:0849315484
Auerbach Publications © 2003 (242 pages)
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.
Table of Contents Back Cover Comments
Table of Contents
Database Design Using Entity-Relationship Diagrams
Preface
Introduction
Chapter 1 - The Software Engineering Process and Relational Databases
Chapter 2 - The Basic ER Diagram—A Data Modeling Schema
Chapter 3 - Beyond the First Entity Diagram
Chapter 4 - Extending Relationships/Structural Constraints
Chapter 5 - The Weak Entity
Chapter 6 - Further Extensions for ER Diagrams with Binary Relationships
Chapter 7 - Ternary and Higher-Order ER Diagrams
Chapter 8 - Generalizations and Specializations
Chapter 9 - Relational Mapping and Reverse-Engineering ER Diagrams
Chapter 10 - A Brief Overview of the Barker/Oracle-Like Model
Glossary
Index
List of Figures
List of Examples
,Database Design Using Entity-
Relationship Diagrams
Sikha Bagui
Richard Earp
AUERBACH PUBLICATIONS
A CRC Press Company
Library of Congress Cataloging-in-Publication Data
Bagui, Sikha, 1964-
Database design using entity-relationship diagrams / Sikha Bagui, Richard
Earp.
p. cm. – (Foundation of database design ; 1)
Includes bibliographical references and index.
0849315484
(alk. paper)
1. Database design. 2. Relational databases. I. Earp, Richard, 1940-II. Title.
III. Series.
QA76.9.D26B35 2003
005.74–dc21 2003041804
This book contains information obtained from authentic and highly regarded
sources. Reprinted material is quoted with permission, and sources are
indicated. A wide variety of references are listed. Reasonable efforts have
been made to publish reliable data and information, but the author and the
publisher cannot assume responsibility for the validity of all materials or for
the consequences of their use.
Neither this book nor any part may be reproduced or transmitted in any form
or by any means, electronic or mechanical, including photocopying,
microfilming, and recording, or by any information storage or retrieval
system, without prior permission in writing from the publisher.
The consent of CRC Press LLC does not extend to copying for general
distribution, for promotion, for creating new works, or for resale. Specific
permission must be obtained in writing from CRC Press LLC for such
copying.
Direct all inquiries to CRC Press LLC, 2000 N.W. Corporate Blvd., Boca
Raton, Florida 33431.
Trademark Notice: Product or corporate names may be trademarks or
registered trademarks, and are used only for identification and explanation,
without intent to infringe.
Visit the Auerbach Web site at http://www.auerbach-publications.com
Copyright © 2003 CRC Press LLC
Auerbach is an imprint of CRC Press LLC
No claim to original U.S. Government works
International Standard Book Number 0-8493-1548-4
Library of Congress Card Number 2003041804
1234567890
Dedication
,Dedicated to my father, Santosh Saha, and mother, Ranu Saha
and
my husband, Subhash Bagui
and
my sons, Sumon and Sudip
and
Pradeep and Priyashi Saha
S.B.
To my wife, Brenda,
and
my children: Beryl, Rich, Gen, and Mary Jo
R.E.
, Preface
Data modeling and database design have undergone significant evolution in
recent years. Today, the relational data model and the relational database
system dominate business applications. The relational model has allowed
the database designer to focus on the logical and physical characteristics of
a database separately. This book concentrates on techniques for database
design, with a very strong bias for relational database systems, using the ER
(Entity Relationships) approach for conceptual modeling (solely a logical
implementation).
Intended Audience
This book is intended to be used by database practitioners and students for
data modeling. It is also intended to be used as a supplemental text in
database courses, systems analysis and design courses, and other courses
that design and implement databases. Many present-day database and
systems analysis and design books limit their coverage of data modeling.
This book not only increases the exposure to data modeling concepts, but
also presents a detailed, step-by-step approach to designing an ER diagram
and developing the relational database from it.
www.dbeBooks.com design
- An Ebook series
Library
Foundations of database design series
Database Design Using Entity-Relationship Diagrams
by Sikha Bagui and Richard Earp ISBN:0849315484
Auerbach Publications © 2003 (242 pages)
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.
Table of Contents Back Cover Comments
Table of Contents
Database Design Using Entity-Relationship Diagrams
Preface
Introduction
Chapter 1 - The Software Engineering Process and Relational Databases
Chapter 2 - The Basic ER Diagram—A Data Modeling Schema
Chapter 3 - Beyond the First Entity Diagram
Chapter 4 - Extending Relationships/Structural Constraints
Chapter 5 - The Weak Entity
Chapter 6 - Further Extensions for ER Diagrams with Binary Relationships
Chapter 7 - Ternary and Higher-Order ER Diagrams
Chapter 8 - Generalizations and Specializations
Chapter 9 - Relational Mapping and Reverse-Engineering ER Diagrams
Chapter 10 - A Brief Overview of the Barker/Oracle-Like Model
Glossary
Index
List of Figures
List of Examples
,Database Design Using Entity-
Relationship Diagrams
Sikha Bagui
Richard Earp
AUERBACH PUBLICATIONS
A CRC Press Company
Library of Congress Cataloging-in-Publication Data
Bagui, Sikha, 1964-
Database design using entity-relationship diagrams / Sikha Bagui, Richard
Earp.
p. cm. – (Foundation of database design ; 1)
Includes bibliographical references and index.
0849315484
(alk. paper)
1. Database design. 2. Relational databases. I. Earp, Richard, 1940-II. Title.
III. Series.
QA76.9.D26B35 2003
005.74–dc21 2003041804
This book contains information obtained from authentic and highly regarded
sources. Reprinted material is quoted with permission, and sources are
indicated. A wide variety of references are listed. Reasonable efforts have
been made to publish reliable data and information, but the author and the
publisher cannot assume responsibility for the validity of all materials or for
the consequences of their use.
Neither this book nor any part may be reproduced or transmitted in any form
or by any means, electronic or mechanical, including photocopying,
microfilming, and recording, or by any information storage or retrieval
system, without prior permission in writing from the publisher.
The consent of CRC Press LLC does not extend to copying for general
distribution, for promotion, for creating new works, or for resale. Specific
permission must be obtained in writing from CRC Press LLC for such
copying.
Direct all inquiries to CRC Press LLC, 2000 N.W. Corporate Blvd., Boca
Raton, Florida 33431.
Trademark Notice: Product or corporate names may be trademarks or
registered trademarks, and are used only for identification and explanation,
without intent to infringe.
Visit the Auerbach Web site at http://www.auerbach-publications.com
Copyright © 2003 CRC Press LLC
Auerbach is an imprint of CRC Press LLC
No claim to original U.S. Government works
International Standard Book Number 0-8493-1548-4
Library of Congress Card Number 2003041804
1234567890
Dedication
,Dedicated to my father, Santosh Saha, and mother, Ranu Saha
and
my husband, Subhash Bagui
and
my sons, Sumon and Sudip
and
Pradeep and Priyashi Saha
S.B.
To my wife, Brenda,
and
my children: Beryl, Rich, Gen, and Mary Jo
R.E.
, Preface
Data modeling and database design have undergone significant evolution in
recent years. Today, the relational data model and the relational database
system dominate business applications. The relational model has allowed
the database designer to focus on the logical and physical characteristics of
a database separately. This book concentrates on techniques for database
design, with a very strong bias for relational database systems, using the ER
(Entity Relationships) approach for conceptual modeling (solely a logical
implementation).
Intended Audience
This book is intended to be used by database practitioners and students for
data modeling. It is also intended to be used as a supplemental text in
database courses, systems analysis and design courses, and other courses
that design and implement databases. Many present-day database and
systems analysis and design books limit their coverage of data modeling.
This book not only increases the exposure to data modeling concepts, but
also presents a detailed, step-by-step approach to designing an ER diagram
and developing the relational database from it.
