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.