This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.
View Full Document
Unformatted text preview: Normalization approach Given attributes A 1 , A 2 , …, A n form a relation R R(A 1 ,A 2 ,…A n ) and constraints in the form of a set of functional dependencies F. NJ = NATURAL JOIN Find a set of smaller relations R 1 , R 2 , …, R m (m >=1 ) such that { R = R 1 NJ R 2 NJ … NJ R m where each R 1 , R 2 , …, R m is in some normal form } Figure 2 – Normal form diagram CSC 4402 10/28/2009 Page 2 of 2 Refer to PDf on functional dependencies....
View
Full
Document
This note was uploaded on 01/25/2010 for the course CSC 4402 taught by Professor Staff during the Fall '08 term at LSU.
 Fall '08
 Staff
 Databases, Relational Database

Click to edit the document details