Access over 20 million homework & study documents

search

POS 410 Week 2 DQ 1

Type

Study Guide

Rating

Showing Page:
1/1
Week #1 DQ 2 - What is “normalization” and why do we normalize DBs?
In the field of relational database design, normalization is a systematic way of ensuring
that a database structure is suitable for general purpose querying and free of certain undesirable
characteristics; insertion, update, and deletion anomalies that could lead to a loss of data
integrity. Informally, a relational database table is often described as "normalized" if it is in the
Third Normal Form. Most 3NF tables are free of insertion, update, and deletion anomalies, i.e. in
most cases 3NF tables adhere to BCNF, 4NF, and 5NF. A standard piece of database design
guidance is that the designer should create a fully normalized design; selective demoralization
can subsequently be performed for performance reasons. However, some modeling disciplines,
such as the dimensional modeling approach to data warehouse design, explicitly recommend
non-normalized designs, i.e. designs that in large part do not adhere to 3NF.

Sign up to view the full document!

lock_open Sign Up
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Anonymous
Excellent resource! Really helped me get the gist of things.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4