Abstract
No matter what database system is being designed, normalization is a vital process. Normalization ensures that the database contained within the system is both accurate and doesn’t contain duplicated information. Normalization can be summed up in a single sentence: “Every entity in a database needs to have a single theme” (see http://www.gslis.utexas.edu/~1384k11w/normstep.html). By theme, what is being said is that one entity models one “thing” and is used for just one purpose.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2004 Louis Davidson
About this chapter
Cite this chapter
Davidson, L. (2004). Normalization Techniques. In: Pro SQL Server 2000 Database Design: Building Quality OLTP Databases. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-0708-5_6
Download citation
DOI: https://doi.org/10.1007/978-1-4302-0708-5_6
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-59059-302-8
Online ISBN: 978-1-4302-0708-5
eBook Packages: Springer Book Archive