Scribd
Upload
23 views2 pages

DWM Notes

The document outlines the stages of database normalization, which includes First Normal Form (1NF), Second Normal Form (2NF), and Third Normal Form (3NF). It emphasizes the importance of primary and foreign keys in establishing data relationships and ensuring data consistency and reliability. The document also highlights the transition from data modeling to design.

Uploaded by

Trina Venise Balajadia
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
23 views2 pages

DWM Notes

The document outlines the stages of database normalization, which includes First Normal Form (1NF), Second Normal Form (2NF), and Third Normal Form (3NF). It emphasizes the importance of primary and foreign keys in establishing data relationships and ensuring data consistency and reliability. The document also highlights the transition from data modeling to design.

Uploaded by

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

MODELING DATA IN THE ORGANIZATION

Database Normalization

U T diagrams
dat

CLEANS"consistency
Dat a
> search for data
< Quality/Reliability
STAGE 1: MRST NORMAL FORM
each column
-"One of each" in
> No umque identification

* Primary key
> class number, student number

STAGE 2: SECOND NORMAL FORM


Primary key
Entity Foreign key = The" side
basis> Primary Key basis
Fattributes
<

> On the many side

one class can have many students


one student can only be in one class

STAGE 3: THIRD NORMAL FORM

> only colum with direct dependency of the primary key


e
g address-zip
.
.

↓ Data Trus

~
Data Relations

- From modeling to design

You might also like