Book Categories

Description of Professional SQL Server 2000 Database Design

The Publisher writes:

SQL Server 2000 is the latest and most powerful version of Microsoft's data warehousing and relational database management system.

Professional SQL Server 2000 Database Design provides an outline of the techniques that the designer can employ to make effective use of the full range of facilities that SQL Server 2000 offers. It attempts to move away from traditional texts on relational database design by considering design issues from a 'real world' point of view. To that end, it provides a full case study illustrating the scope of the designer's role - right from initial discussions regarding a client's needs, through development of a logical model, to full implementation of the system.

Table of Contents:

Introduction
Part I - Logical Design

Chapter 1 - Introduction to Database Methodologies
Chapter 2 - Gathering Information for a Database Project
Chapter 3 - Fundamental Database Concepts
Chapter 4 - Entities, Attributes, Relationships and Business Rules
Chapter 5 - Data Modeling
Chapter 6 - Normalization Techniques
Chapter 7 - Advanced Normalization Techniques
Chapter 8 - Ending the Logical Design Phase

Part II - Physical Design and Implementation
Chapter 9 - Planning the Physical Architecture
Chapter 10 - Planning and Implementing the Basic Physical Architecture
Chapter 11 - Ensuring Data Integrity
Chapter 12 - Advanced Data Access and Modification Techniques
Chapter 13 - Determining Hardware Requirements
Chapter 14 - Completing the Project
Appendix A
Codd's 12 Rules for an RDBMS

Title Information

ISBN:

9781861004765

Pages:

600 pages

Format:

Paperback

Product Code:

157168

Publisher:

Wrox Press

Published:

30/03/2001

Write a review of this book

Customer Reviews from Amazon