4nf1 - Higher Normalization Presentation by: P.Mirunalini...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

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

Unformatted text preview: Higher Normalization Presentation by: P.Mirunalini Asst. Professor SSNCE B.E. IV Sem – Database Management Systems Overview • Multi-valued Dependencies • Fourth Normal Form – 4NF First Normal Form – 1NF Normalizng nested relations into • PROJS is a nested relation – each tuple have a relation within it • Each tuple represents an employee and a relation PROJS(PNUMBER, HOURS) • PNUMBER is a partial primary key • Decompose EMP_PROJ into EMP_PROJ1 and EMP_PROJ2 by propogating the primary key First Normal Form – 1NF Multi-valued Dependencies • Multivalued dependencies are consequence of first normal form (1NF) – disallowed set of values for an attribute in a tuple. • MVD is a consequence of two or more multivalued independent attributes in the same relation. • Informally whenever two independent 1:N relationships A:B and A:C are mixed in the same relation, an MVD may arise. Multi-valued Dependencies Multi-valued Dependencies...
View Full Document

This note was uploaded on 04/01/2012 for the course CSE,IT 101 taught by Professor Mirunaalini during the Spring '12 term at Indian Institute of Technology, Chennai.

Page1 / 16

4nf1 - Higher Normalization Presentation by: P.Mirunalini...

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

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