Murach's Oracle SQL and PL/SQL
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 284
The basic steps for designing a data structure 284
How to identify the data elements 286
How to subdivide the data elements 288
How to identify the tables and assign columns 290
How to identify the primary and foreign keys 292
How to enforce the relationships between tables 294
How normalization works 296
How to identify the columns to be indexed 298
How to normalize a data structure 300
The seven normal forms 300
How to apply the first normal form 302
How to apply the second normal form 304
How to apply the third normal form 306
When and how to denormalize a data structure 308


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

Murach's Oracle SQL and PL/SQL

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.