Access over 20 million homework & study documents

search

POS 410 Week 1 DQ 2

Type

Homework

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

Anonymous
I was struggling with this subject, and this helped me a ton!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4