Hour 4. The Normalization Process

Team-Fly    

 
Sams Teach Yourself SQL in 24 Hours, Third Edition
By Ronald R. Plew, Ryan K. Stephens
Table of Contents
Part II.  Building Your Database


Hour 4. The Normalization Process

In this hour, you learn the process of taking a raw database and breaking it into logical units called tables. This process is referred to as normalization . The normalization process is used by database developers to design datsabases in which it is easy to organize and manage data while ensuring the accuracy of data throughout the database.

The advantages and disadvantages of both normalization and denormalization of a database are discussed, as well as data integrity versus performance issues that pertain to normalization.

The highlights of this hour include

  • What normalization is

  • Benefits of normalization

  • Advantages of denormalization

  • Normalization techniques

  • Guidelines of normalization

  • The three normal forms

  • Database design


Team-Fly    
Top
 


Sams Teach Yourself SQL in 24 Hours
Sams Teach Yourself SQL in 24 Hours (5th Edition) (Sams Teach Yourself -- Hours)
ISBN: 0672335417
EAN: 2147483647
Year: 2002
Pages: 275

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net