Access over 20 million homework & study documents

POS 410 Week 1 DQ 2

Content type
User Generated
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
Unformatted Attachment Preview
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 de ...
Purchase document to see full attachment
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
I was struggling with this subject, and this helped me a ton!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4