×

Uh-oh, it looks like your Internet Explorer is out of date.

For a better shopping experience, please upgrade now.

Database Modeling and Design: The Fundamental Principles / Edition 1
     

Database Modeling and Design: The Fundamental Principles / Edition 1

by Toby J. Teorey
 

ISBN-10: 1558602941

ISBN-13: 9781558602946

Pub. Date: 04/28/1994

Publisher: Elsevier Science & Technology Books

Database Modeling and Design is a comprehensive guide to database design for commercial database products and their applications. Throughout, Toby Teorey offers practical and immediately usable techniques for transforming the entity-relationship model into SQL data structures.

The proliferation of SQL-compliant databases on LAN servers and PCs has

Overview

Database Modeling and Design is a comprehensive guide to database design for commercial database products and their applications. Throughout, Toby Teorey offers practical and immediately usable techniques for transforming the entity-relationship model into SQL data structures.

The proliferation of SQL-compliant databases on LAN servers and PCs has spurred the demand for applications written for these relational and object-oriented databases. Professionals from many backgrounds can learn to design database applications effectively, using this book. The topic organization follows the design process and issues are introduced as needed, with the development of the design. The presentation is accessible enough to allow for immediate application, yet rigorous enough for the reader to get solid results. Database Modeling and Design is ideal for the database practitioner and applications programmer, and for those with computer experience but no previous database training.

Product Details

ISBN-13:
9781558602946
Publisher:
Elsevier Science & Technology Books
Publication date:
04/28/1994
Edition description:
Older Edition
Pages:
277
Product dimensions:
6.10(w) x 8.95(h) x 1.28(d)

Table of Contents

Database Modeling & Design: The Fundamental Principles, Second Edition
by Toby J. Teorey
    Chapter 1 Introduction
      1.1 Data and Database Management
      1.2 Data Modeling and the Entity-Relationship Approach
      1.3 The Database Life Cycle
      1.4 Summary
      Literature Summary

    Chapter 2 The ER Model: Basic Concepts
      2.1 Fundamental ER Constructs
        2.1.1 Basic Objects: Entities, Relationships, Attributes
        2.1.2 Degree of a Relationship
        2.1.3 Connectivity and Cardinality of a Relationship
        2.1.4 Attributes of a Relationship
        2.1.5 Existence of an Entity in a Relationship
        2.1.6 Alternative ER Notations
      2.2 Advanced ER Constructs
        2.2.1 Generalization: Supertypes and Subtypes
        2.2.2 Aggregation
        2.2.3 Ternary Relationships
        2.2.4 General n-ary Relationships
        2.2.5 ER Constraints: Extensions from the NIAM Model
        2.2.6 Entity Integrity, Referential Integrity, and ID Dependency
      2.3 Object-Oriented Data Modeling
        2.3.1 Object-Oriented Concepts
        2.3.2 Object Modeling Versus ER Modeling
      2.4 Summary
      Literature Summary
      Exercises

    Chapter 3 ER Modeling in Logical Database Design
      3.1 Introduction
      3.2 Requirements Analysis and ER Modeling
        3.2.1 Classify Entities and Attributes
        3.2.2 Identify the Generalization Hierarchies
        3.2.3 Define Relationships
        3.2.4 Example of ER Modeling: Company Personnel and Project Database
      3.3 View Integration
        3.3.1 Preintegration Analysis
        3.3.2 Comparison of Schemas
        3.3.3 Conformation of Schemas
        3.3.4 Merging and Restructuring of Schemas
        3.3.5 Example of View Integration
      3.4 Entity Clustering
        3.4.1 Clustering Concepts
        3.4.2 Grouping Operations
        3.4.3 Clustering Technique
      3.5 Summary
      Literature Summary
      Exercises

    Chapter 4 Transformation of the ER Model to SQL
      4.1 Transformation Rules and SQL Constructs
        4.1.1 Binary Relationships
        4.1.2 Binary Recursive Relationships
        4.1.3 Ternary and n-ary Relationships
        4.1.4 Generalization and Aggregation
        4.1.5 Multiple Relationships
        4.1.6 Weak Entities
      4.2 Transformation Steps
        4.2.1 Entity Transformation
        4.2.2 Many-to-Many Binary Relationship Transformation
        4.2.3 Ternary Relationship Transformation
        4.2.4 Example of ER-to-SQL Transformation
      4.3 Summary
      Literature Summary
      Exercises

    Chapter 5 Normalization
      5.1 Fundamentals of Normalization
        5.1.1 First Normal Form
        5.1.2 Superkeys, Candidate Keys, and Primary Keys
        5.1.3 Second Normal Form
        5.1.4 Third Normal Form
        5.1.5 Boyce-Codd Normal Form
      5.2 The Design of Normalized Tables: A Simple Example
      5.3 Normalization of Candidate Tables Derived from ER Diagrams
      5.4 Determining the Minimum Set of 3NF Tables
        5.4.1 Elimination of Extraneous Attributes
        5.4.2 Search for a Nonredundant Cover
        5.4.3 Partitioning of the Nonredundant Cover
        5.4.4 Merge of Equivalent Keys
        5.4.5 Nonredundant Cover Again and Definition of Tables
      5.5 Fourth and Fifth Normal Forms
        5.5.1 Multivalued Dependencies
        5.5.2 Fourth Normal from
        5.5.3 Decomposing Tables to 4NF
        5.5.4 Fifth Normal Form
      5.6 Summary
      Literature Summary
      Exercises

    Chapter 6 Access Methods
      6.1 Sequential Files
        6.1.1 Sequential Processing for an Entire File
        6.1.2 Sequential Processing for a Single Record
        6.1.3 Batch Processing of k Records
      6.2 Random Files
        6.2.1 Hashing
        6.2.2 B-Trees and B+-trees
      6.3 Secondary Indices
      6.4 Usage Refinement or Denormalization of Logical Databases
      6.5 Table Usage Refinement Algorithm
      6.6 Join Strategies
      6.7 Summary
      Literature Summary
      Exercises

    Chapter 7 An Example of Relational Database Design
      7.1 Requirement Specification
      7.2 Logical Design
      7.3 Physical Design
        7.3.1 Schema Refinement Based on Usage
        7.3.2 Index Selection Problem
      7.4 Summary

    Chapter 8 Data Allocation Strategies
      8.1 Introduction
      8.2 Distributed and Multidatabase Design
        8.2.1 Fragmentation
        8.2.2 Data Allocation
      8.3 The General Data Allocation Problem
      8.4 Data Allocation Strategies
      8.5 Summary
      Literature Summary
      Exercises

    Chapter 9 Optimal Distributed Data Allocation
      9.1 A distributed Database Design Problem
        9.1.1 Database Description
        9.1.2 Database Transactions
        9.1.3 Network and Local Site Specifications
      9.2 Global Schema and Fragmentation Design
        9.2.1 Analysis of the Transactions
        9.2.2 Global Schema Design Decisions
        9.2.3 Normalization of the Global Schema
        9.2.4 Fragmentation and Nonredundant Allocation
      9.3 Redundant Data Allocation Methods
        9.3.1 Cost/Benefit Analysis: Basic Performance Statistics
        9.3.2 Exhaustive Enumeration Method
        9.3.3 All Beneficial Sites Method
        9.3.4 Variations of All Beneficial Sites
      9.4 Summary
      Literature Summary
      Exercises

    Chapter 10 Database Dependability
      10.1 Introduction
      10.2 Availability
      10.3 Reliability
        10.3.1 Example 1: Query Reliability for a Simple Distributed Database
        10.3.2 Example 2: Trade-offs Between Performance and Reliability
      10.4 Mean Transaction completion Time
      10.5 Summary
      Literature Summary
      Exercises

    Appendix A Review of SQL
      A.1 SQL Names and Operators
      A.2 Data Definition Language (DDL)
      A.3 Data Manipulation Language (DML)
        A.3.1 SQL Select Command
        A.3.2 SQL Update Commands
        A.3.3 Referential Integrity
        A.3.4 SQL Views
      Literature Summary
      Exercises

    Appendix B Database Performance Tuning
      B.1 User-Defined Parameters
      B.2 Database Administrator and System Defined Parameters
      Literature Summary
    References
    Solutions to Selected Exercises
    Index

Customer Reviews

Average Review:

Post to your social network

     

Most Helpful Customer Reviews

See all customer reviews