Advertisement

Pro SQL Server 2000 Database Design: Building Quality OLTP Databases

  • Authors
  • LouisĀ Davidson

Table of contents

  1. Front Matter
    Pages i-xxiv
  2. Louis Davidson
    Pages 1-11
  3. Louis Davidson
    Pages 27-53
  4. Louis Davidson
    Pages 91-128
  5. Louis Davidson
    Pages 129-163
  6. Louis Davidson
    Pages 165-190
  7. Louis Davidson
    Pages 191-217
  8. Louis Davidson
    Pages 219-243
  9. Louis Davidson
    Pages 245-313
  10. Louis Davidson
    Pages 315-339
  11. Louis Davidson
    Pages 341-365
  12. Louis Davidson
    Pages 367-457
  13. Louis Davidson
    Pages 459-509
  14. Louis Davidson
    Pages 511-542
  15. Back Matter
    Pages 543-568

About this book

Introduction

Database design is one of the most contentious issues in computer science. There is always a delicate balance to be struck between the strict academic rules that govern the design of relational databases and the real-world techniques that programmers apply to get the job done in a certain time frame. This book's goal is to coverfrom a "real-world" point of viewall of the essential elements in designing, modeling, and building efficient relational databases, while avoiding a dry, theoretical approach.

Author Louis Davidson explains the process of implementing a databaseā€”from generating tables and allowing access to these tables using Microsoft SQL Server 2000. This includes tackling data modeling (focusing on the IDEF1X notation), requirements gathering, normalization (beyond the Third Normal Form), and implementing tables, constraints, triggers, procedures, user-defined functions, and so on. Davidson provides a full and realistic case study that clearly illustrates the entire process, from the initial discussions of a client's needs, through development of a logical model, to a complete implementation of the system.

Keywords

Hardware SQL computer computer science database database design databases design development modeling

Bibliographic information