Scribd
Upload
54 views19 pages

Database Normalization Explained

The document discusses database normalization and describes the first 5 normal forms. It defines key concepts like 1st normal form which removes redundant data, 2nd normal form which minimizes null values, and 3rd normal form which reduces data repetition. It also mentions that 4th normal form deals with multivalued dependencies while 5th normal form ensures join dependencies don't lose information. The document ends with an exercise to draw an ER diagram for a company with persons, jobs, departments, projects and their relationships.

Uploaded by

madhusudhan reddy
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
54 views19 pages

Database Normalization Explained

The document discusses database normalization and describes the first 5 normal forms. It defines key concepts like 1st normal form which removes redundant data, 2nd normal form which minimizes null values, and 3rd normal form which reduces data repetition. It also mentions that 4th normal form deals with multivalued dependencies while 5th normal form ensures join dependencies don't lose information. The document ends with an exercise to draw an ER diagram for a company with persons, jobs, departments, projects and their relationships.

Uploaded by

madhusudhan reddy
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd

Database

Normalizatio
n
-Srini

1st Normal Form Modelling in OLTP

The process of removal of redundant, duplicate data within a table or da


Minimal use of NULL values
Reduce repeatition of data items in a row unnecessarily
Each record is considered as Tuple.
Each attribute is considered as column
Degree = no. of columns/attributes
Cardinality = number of columns

The levels of normalization


1st Normal Form
2nd Normal Form
3rd Normal Form
Boyce-Codd Normal Form (BCNF)
4th Normal Form
5th Normal Form

Remove repeating groups

Fourth NF
Multivalued dependency

AB

Fifth Normal Form


JOIN DEPENDENCY when joining, then the resultant table
Should not loose information.

Exercise:
Draw E/R Diagram for the given case study.
Many Persons work for a company. Every person is given a
Job title and persons are categorized as workers and managers
A manager manages a department
A company has many departments
A worker works for many projects
Manager s are responsible for many projects
Each department works on many projects to completion.

You might also like