Database Modeling and Design: The Fundamental Principles / Edition 1

Database Modeling and Design: The Fundamental Principles / Edition 1

by Toby J. Teorey
     
 

Database Modeling & Design is a comprehensive guide to DB design for commercial database products and their applications. Throughout, Toby Teorey offers practical and immediately usable techniques for transforming the ER model into SQL data structures. New to this Edition: A simple introduction to the terms and concepts of relational databases for those new to DB… See more details below

Overview

Database Modeling & Design is a comprehensive guide to DB design for commercial database products and their applications. Throughout, Toby Teorey offers practical and immediately usable techniques for transforming the ER model into SQL data structures. New to this Edition: A simple introduction to the terms and concepts of relational databases for those new to DB application programming; a complete description of SQL with 20 sample queries; object data modeling and its relationship to ER modeling for easy conversion when needed; figures and examples utilize standard Chen notation; new coverage of DB tuning; and a new case study: an intuitive employee database example that allows the reader to concentrate on concepts rather than on the specifics of the database. Also includes solutions to selected exercises for those who want a taste of practical experience in DB design.

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

Preface
Ch. 1Introduction1
Ch. 2The ER Model: Basic Concepts13
Ch. 3ER Modeling in Logical Database Design45
Ch. 4Transformation of the ER Model to SQL79
Ch. 5Normalization97
Ch. 6Access Methods141
Ch. 7An Example of Relational Database Design177
Ch. 8Distributed Data Allocation187
Ch. 9Data Warehousing, OLAP, And Data Mining211
Ch. 10Advanced Database Technologies251
App. AReview of SQL281
App. BDatabase Performance Tuning301
App. CDependability Estimation305
App. DData Warehousing Technology Vendors315
App. EConnecting Databases to the World Wide Web319
References323
Solutions to Selected Exercises347
Index355
About the Author366

Read More

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >