Fourth Normal Form (4NF) - Example

• Course-Id Instructor TextbookMGS404 Clay HansenMGS404 Clay KroenkeMGS404 Drake HansenMGS404 Drake Kroenke

• By placing the multi-valued attributes in tables by themselves, we can convert the above to 4NF

• Change to:COURSE-INST (Course-Id, Instructor)COURSE-TEXT (Course-Id, Textbook)

Previous slide

Next slide

Back to first slide

View graphic version