Day 5 Normalization - Normalization Normalization The...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
Normalization
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Normalization The process of removing interdependent and redundant data from a database model in order to improve data consistency, maintainability, storage efficiency and database scalability Normalization does not necessarily mean database simplification
Background image of page 2
Advantages of Normalization Duplicate data is minimized, thus reducing storage requirements and simplifying maintenance. Pre-calculated values are eliminated, thus reducing storage requirements and improving data quality.
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Advantages of Normalization Each table in a normalized database contains information about a single subject, so each table tends to have fewer indices. This makes insert, update and delete operations more efficient. A table can only have a single clustered index. Clustered indices tend to produce faster data retrievals. Normalized databases typically have more tables than non-normalized databases, so normalized databases typically have more clustered indices.
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 20

Day 5 Normalization - Normalization Normalization The...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online