morgan@unix.SRI.COM (Morgan Kaufmann) (10/22/90)
DATABASE MODELING AND DESIGN:THE ENTITY-RELATIONSHIP APPROACH
By Toby J. Teorey (University of Michigan)
1990, 259 pages, Paper ISBN 1-55860-134-1; $25.95 ISSN 1046-1698
Entity-Relationship (ER) modeling emphasizes simplicity and
readability throughout the design process. It is a useful method
for representing data requirements, and for conceptual database
design. Database Modeling and Design: The Entity-Relationship
Approach is appropriate for anyone designing or studying databases.
With detailed real-life case studies for examples, the author shows
techniques for managing the complexity of database design.
This book presents a comprehensive set of semantic definitions and
notations for ER models with computer screen illustrations of
large, complex databases. It includes both logical and physical
database design with an emphasis on the former. The author
discusses the database lifecycle, use of ER concepts in the
database design process, transformation to the relational model,
SQL syntax, database normalization, ER clustering, and distributed
databases. It is intended as a guide to applying the ER model in
databases for office automation, CASE, CAD/CAM, and related
business or engineering database environments.
This book offers new insights into database modeling and eases the
transition from the ER model to the relational model, including the
building of standard SQL data definitions. The design rules are
applicable to DB2, SQL/DS, Oracle, Ingres, Sybase, non-stop SQL,
and other SQL-based systems.
For bibliographic purposes, the contents are listed below.
Requests for further information on the book, examination copies
for potential course use, and orders may be directed to the
publisher through the contact information which follows.
Chapter 1 Introduction
1.1 The Database Lifecycle
1.2 Case Study: Mathematical Reviews Publishing Application
1.3 Summary
Chapter 2 The ER Model: Basic Concepts
2.1 Fundamental ER Constructs
2.2 Advanced ER Constructs
2.3 Summary
Chapter 3 ER Modeling in Logical Database Design
3.1 Introduction
3.2 Requirements Analysis and ER Modeling
3.3 View Integration
3.4 Summary
Chapter 4 Transformation of the ER Model to SQL
4.1 Transformation Rules and SQL Constructs
4.2 Summary of Transformation Steps
4.3 Summary
Chapter 5 Normalization
5.1 Fundamentals of Normalization
5.2 The Design of Normalized Relationships
5.3 Determining the Minimum Set of 3NF Relations
5.4 Normalization of Candidate Relations
5.5 Higher Normal Forms and Equivalent ER Constructs
5.6 Summary
Chapter 6 Physical Design Fundamentals
6.1 Access Methods and Performance Measures
6.2 Usage Refinement of Logical Databases
6.3 Summary
Chapter 7 An Example of Relational Database Design
7.1 Requirement Specification
7.2 Logical Design
7.3 Physical Design
7.4 Summary
Chapter 8 Distributed Database Design Concepts
8.1 Introduction
8.2 Distributed Database Design
8.3 The General Data Allocation System
8.4 Data Allocation Strategies
8.5 Summary
Chapter 9 An Example of Distributed Database Design
9.1 A Distributed Database Design Problem
9.2 Global Schema and Fragmentation Design
9.3 Redundant Data Allocation Methods
9.4 Summary
Chapter 10 Entity Clustering
10.1 Introduction
10.2 Clustering Concepts
10.3 Grouping Operations
10.4 Clustering Technique
10.5 Summary
_________________________________________________________________
For information and orders:
DATABASE MODELING AND DESIGN:THE ENTITY-RELATIONSHIP APPROACH
By Toby J. Teorey (University of Michigan)
1990, 259 pages, Paper ISBN 1-55860-134-1; $25.95
In the Data Management Systems Series ISSN 1046-1698
Morgan Kaufmann Publishers
Department 57
2929 Campus Drive, Suite 260
San Mateo, CA 94403
USA
Phone: (415) 578-9928 or (800) 745-READ
Fax: (415) 578-0672
email: morgan@unix.sri.com
On orders, please add $3.50 for the first book and $2.50 for
each additional for surface shipping to the U.S. and Canada;
$6.50 for the first book and $3.50 for each additional for
shipping to all other areas. California residents: Please add
sales tax appropriate to your county.
Master Card, Visa and personal checks drawn on US banks
accepted.