 |
|
| DATABASE MODELING AND DESIGN
| |
| | |
|
|
 Logical Design, Fourth Edition
To order this title, and for more information, click here
Fourth Edition
By
Toby Teorey, University of Michigan, Ann Arbor, USA
Sam Lightstone, IBM, Toronto, Canada
Tom Nadeau, Ubiquiti Inc., Ann Arbor, MI
Description
Database systems and database design technology have undergone significant evolution in recent years. The relational data model and relational
database systems dominate business applications; in turn, they are extended by other technologies like data warehousing, OLAP, and data
mining. How do you model and design your database application in consideration of new technology or new business needs?
In the extensively
revised fourth edition, you?ll get clear explanations, lots of terrific examples and an illustrative case, and the really practical advice
you have come to count on--with design rules that are applicable to any SQL-based system. But you?ll also get plenty to help you
grow from a new database designer to an experienced designer developing industrial-sized systems.
Audience
Professional data modelers and database design professionals, including database application designers, database admininstrators (DBAs),
and new/novice data management professionals, including those working on object oriented database design; students in second courses
in database focusing on design.
Contents
Chapter 1 Introduction
1.1 Data and Database Management
1.2 The Database Life Cycle
1.2 Conceptual Data Modeling
1.4 Summary
Literature
Summary
Chapter 2 The Entity-Relationship Model
2.1 Fundamental ER Constructs
2.1.1 Basic Objects: Entities, Relationships, Attributes
2.1.2 Degree of a Relationship
2.1.3 Connectivity of a Relationship
2.1.4 Attributes of a Relationship
2.1.5 Existence of an Entity in
a Relationship
2.1.6 Alternative Conceptual Data Modeling 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 Exclusion constraint
2.2.6 Referential Integrity
2.3 Summary
Literature Summary
Chapter 3 Unified Modeling Language
3.1 Class Diagrams
3.1.1 Class Diagram Notation Description
3.1.2
Class Diagrams for Software Design
3.1.3 Class Diagrams for Database Design
3.2 Activity Diagrams
3.2.1 Activity Diagram Notation Description
3.2.2 Activity Diagrams for Software Design
3.2.3 Activity Diagrams for Workflow
3.3 Rules of Thumb for UML Usage
3.4 Summary
Literature
Summary
Chapter 4 Requirements Analysis and Conceptual Data Modeling
4.1 Introduction
4.2 Requirements Analysis
4.3 Conceptual Data
Modeling
4.3.1 Classify Entities and Attributes
4.3.2 Identify the Generalization Hierarchies
4.3.3 Define Relationships
4.3.4 Example
of Data Modeling: Company Project Database
4.4 View Integration
4.4.1 Pre-integration Analysis
4.4.2 Comparison of Schemas
4.4.3 Conformation
of Schemas
4.4.4 Merging and Restructuring of Schemas
4.4.5 Example of View Integration
4.5 Entity Clustering for ER Models
4.5.1 Clustering
Concepts
4.5.2 Grouping Operations
4.5.3 Clustering Technique
4.6 Summary
Literature Summary
Chapter 5 Transforming the Conceptual
Data Model to SQL
5.1 Transformation Rules and SQL Constructs
5.1.1 Binary Relationships
5.1.2 Binary Recursive Relationships
5.1.3 Ternary
and n-ary Relationships
5.1.4 Generalization and Aggregation
5.1.5 Multiple Relationships
5.1.6 Weak Entities
5.2 Transformation Steps
5.2.1 Entity Transformation
5.2.2 Many-to-Many Binary Relationship Transformation
5.2.3 Ternary Relationship Transformation
5.2.4 Example
of ER-to-SQL Transformation
5.3 Summary
Literature Summary
Chapter 6 Normalization
6.1 Fundamentals of Normalization
6.1.1 First Normal
Form
6.1.2 Superkeys, Candidate Keys, and Primary Keys
6.1.3 Second Normal Form
6.1.4 Third Normal Form
6.1.5 Boyce-Codd Normal Form
6.2 The Design of Normalized Tables: Simple Example
6.3 Normalization of Candidate Tables Derived from ER Diagrams
6.4 Determining the
Minimum Set of 3NF Tables
6.4.1 Elimination of Extraneous Attributes
6.4.2 Search for a Nonredundant Cover
6.4.3 Partitioning of the
Nonredundant Cover
6.4.4 Merge of Equivalent Keys
6.4.5 Definition of Tables
6.5 Fourth and Fifth Normal Forms
6.5.1 Multivalued Dependencies
6.5.2 Fourth Normal Form
6.5.3 Decomposing Tables to 4NF
6.5.4 Fifth Normal Form
6.6 Summary
Literature Summary
Chapter 7 An Example
of Logical Database Design
7.1 Requirements Specification
7.2 Logical Design
7.3 Summary
Chapter 8 Business Intelligence
8.1 Data Warehousing
8.1.1 Overview of Data Warehousing
8.1.2 Logical Design
8.2 On-Line Analytical Processing (OLAP)
8.2.1 The Exponential Explosion
of Views
8.2.2 Overview of OLAP
8.2.3 View Size Estimation
8.2.4 Selection of Material Views
8.2.5 View Maintenance
8.2.6 Query
Optimization
8.3 Data Mining
8.3.1 Forecasting
8.3.2 Text Mining
8.4 Summary
Literature Summary
Chapter 9 CASE Tools for Logical
Database Design
9.1 Introduction to Software Tools
9.2 The Key Capabilities to Watch For
9.3 The Basics
9.4 Generating a Database From
a Design
9.5 Database Support
9.6 Collaborative Support
9.7 Distributed Development
9.8 Application Lifecycle Tooling Integration
9.9
Design Compliance Checking
9.10 Reporting
9.11 Semi-Structured Data, XML
9.12 Summary
Literature Summary
Appendix The Basics 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
References
Exercises for Logical Design
Solutions to Selected Exercises
Glossary
Bibliographic & ordering Information
Paperback, 296 pages, publication date: SEP-2005
ISBN-13: 978-0-12-685352-0
ISBN-10: 0-12-685352-5
Imprint: MORGAN KAUFFMAN
Price: Order form
EUR 48.95
GBP 33.99
USD 57.95
Books and book related electronic products are priced in US dollars (USD), euro (EUR), and Great Britain Pounds (GBP). USD prices apply to the Americas and Asia Pacific. EUR prices apply in Europe and the Middle East. GBP prices apply to the UK and all other countries.
See also information about conditions of sale & ordering procedures, and links to our regional sales offices.
077/762
Last update: 25 Aug 2008
|
|
| |
| | |
|
|
| |
