Beginning Database Design

E-book Info:

Title: Beginning Database Design
Author: Gavin Powell
Rating: 3 Stars; According to Amazon
ISBN: 9780764574900
Publisher: Wrox
Language: English

Description:

* The perfect reference for programmers, administrators, or
Web designers who are new to database development and are uncertain
as to how to design and structure a database efficiently
* Shows how to design and implement robust, scalable databases on any
of the major relational database management systems, including Access,
SQL Server, IBM DB2, MySQL, and Oracle
* Covers all the key database design steps including modeling,
normalization, SQL, denormalization, object-modeling, data warehousing,
and performance
* Provides plenty of real-world examples and a complete
beginning-to-end case study of creating a database that includes the
analysis and planning, tables and data structures, business rules,
and hardware requirements

Table of Contents:

Introduction.
Part I: Approaching Relational Database Modeling.

Chapter 1: Database Modeling Past and Present.

Chapter 2: Database Modeling in the Workplace.

Chapter 3: Database Modeling Building Blocks.

Part II: Designing Relational Database Models.

Chapter 4: Understanding Normalization.

Chapter 5: Reading and Writing Data with SQL.

Chapter 6: Advanced Relational Database Modeling.

Chapter 7: Understanding Data Warehouse Database Modeling.

Chapter 8: Building Fast-Performing Database Models.

Part III: A Case Study in Relational Database Modeling.

Chapter 9: Planning and Preparation Through Analysis.

Chapter 10: Creating and Refining Tables During the Design Phase.

Chapter 11: Filling in the Details with a Detailed Design.

Chapter 12: Business Rules and Field Settings.

Part IV: Advanced Topics.

Chapter 13: Advanced Database Structures and Hardware Resources.

Glossary.

Appendix A: Exercise Answers.

Appendix B: Sample Databases.

Index.