Normalization handout for Team Project Ch 6

Normalization handout for Team Project Ch 6 - Normalizing...

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

View Full Document Right Arrow Icon
Normalizing Relations Transforming ER Diagrams into Relations MIS 2403: Intro to Data Base MIS 3413: Advanced Database Concepts Dr. Segall Spring 2001
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 Data Normalization First normal form: Any multivalued attributes (repeating groups) have been removed, so there is a single value (or null value) at the intersection of each row and column of the table. No multi-valued attributes. Every attribute value is atomic . Second normal form: Partial functional dependencies removed. 1NF and every non-key attribute is fully functionally dependent on the primary key. Every non-key attribute must be defined by the entire key, not by only part of the key. No partial functional dependencies. Third normal form: T ransitive dependencies removed. 2NF and no transitive dependencies (functional dependency between non-key attributes.)
Background image of page 2
3 Data Normalization First normal form: Any multivalued attributes (repeating groups) have been removed, so there is a single value (or null value) at the intersection of each row and column of the table. No multi-valued attributes. Every attribute value is atomic . EmpID Emp_Name Dept_Name Salary Course Date 100 Margaret Simpson Marketing 48,000 SPSS 6/19/1999 Surveys 10/7/1999 140 Alan Beeton Accounting 52,000 Tax Acc 12/8/1999 EmpID Emp_Name Dept_Name Salary Course Date 100 Margaret Simpson Marketing 48,000 SPSS 6/19/1999 100 Margaret Simpson Marketing 48,000 Surveys 10/7/1999 140 Alan Beeton Accounting 52,000 Tax Acc 12/8/1999
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 Data Normalization Second normal form: Partial functional dependencies removed.
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.

This note was uploaded on 06/09/2008 for the course ICS 311 taught by Professor Luoma,milt during the Spring '08 term at Metro State.

Page1 / 16

Normalization handout for Team Project Ch 6 - Normalizing...

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