Professional SQL Server Database Design

SQL Server 2000 is the latest and most powerful version of Microsoft's data warehousing and relational database management system. However, unless a database is designed correctly the powerful features of SQL Server 2000 are redundant.

Database design is an essential skill that is often not adequately mastered by those who design databases as part of their jobs. This book presents the most widely used methodology (IDEF1X) in an easily accessible form and provides exhaustive information and examples on the process of designing and implementing a database application from the backend database programmer's standpoint. It takes the reader through the process of designing a database from conception to documentation.

Contents

Introduction

Section I - Logical Design

• Chapter 1 Introduction to Database Methodologies
• Chapter 2 Gathering Information for a Database Project
• Chapter 3 Fundamental Database Concepts
• Chapter 4 Data Modelling
• Chapter 5 Discovery of Objects, attributes, relationships, and business rules
• Chapter 6 Basic Normalisation Techniques
• Chapter 7 Advance Normalisation Techniques
• Chapter 8 Considering data usage
• Chapter 9 Making Your Database Documentation Available to Others

• Chapter 10 What is Physical Design
• Chapter 11 Business Rules
• Chapter 12 Implementing the OLTP Schemas
• Chapter 13 Implementing the Recording Schemas
• Chapter 14 Accessing Your Data

• Appendix A Relational Design Tools