Chap4-Normalization of Database Tables

Chap4-Normalization of Database Tables - Normalization of...

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

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

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

View Full DocumentRight Arrow Icon
2 Objectives After completing this lesson you should be able to understand the following: What normalization is and what role it plays in database design? About the normal forms 1NF, 2NF, 3NF, BCNF, and 4NF
Background image of page 2
3 Continued… How normal forms can be transformed from lower normal forms to higher normal forms? That normalization and E-R modeling are used concurrently to produce a good database design That some situations require denormalization to generate information efficiently
Background image of page 3

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

View Full DocumentRight Arrow Icon
4 Database Tables and Normalization Table is basic building block in database design Normalization is process for assigning attributes to entities Reduces data redundancies Helps eliminate data anomalies Produces controlled redundancies to link tables
Background image of page 4
5 Continued. . Normalization stages 1NF - First normal form 2NF - Second normal form 3NF - Third normal form 4NF - Fourth normal form
Background image of page 5

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

View Full DocumentRight Arrow Icon
6 Need for Normalization
Background image of page 6
7 Observations on the Figure
Background image of page 7

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

View Full DocumentRight Arrow Icon
Image of page 8
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 24

Chap4-Normalization of Database Tables - Normalization of...

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

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