Murach's SQL Server 2005 for Developers
How to design a database

This chapter introduces you to database design. Although you may never design a database on your own, this material will help you understand the underlying design of the databases you're working with so that you can create more efficient and effective queries.
Chapter 9 How to design a database
How to design a data structure 270
The basic steps for designing a data structure 270
How to identify the data elements 272
How to subdivide the data elements 274
How to identify the tables and assign columns 276
How to identify the primary and foreign keys 278
How to enforce the relationships between tables 280
How normalization works 282
How to identify the columns to be indexed 284
How to normalize a data structure 286
The seven normal forms 286
How to apply the first normal form 288
How to apply the second normal form 290
How to apply the third normal form 292
When and how to denormalize a data structure 294
Perspective 296
t


© Copyright 1998-2008 Mike Murach & Associates, Inc.  All rights reserved.

Murach's SQL Server 2005

Learn more about this book

View the table of contents

Add this book to your cart



Our Ironclad Guarantee

First, try our books for 90 days. Then, if you aren't completely convinced that our books are the best ones you've ever used, you can return them for a full refund...no questions asked.