Database Concepts

Published by Pearson
ISBN 10: 0133544621
ISBN 13: 978-0-13354-462-6

Chapter 2 - The Relational Model - Exercises - Page 108: 2.40F

Answer

For 4NF the Relation must be normalized upto BCNF and there should there should be No multi valued dependency.When a Relation is normalized from 1st upto 4th normal form then there exist No determinant in the Relation that ist not the candidate key.In this way Relation is converted into Well formed Relation using 4th normal form.The application of 4th Normal Form ist shown in the picture in step by step section.

Work Step by Step

In the Student Relation there exist a multi valued dependency AS WE discussed in Part A.To remove this multi valued dependency WE would make a nee Relation Sibling AS shown in the picture and in the News Relation WE would use StudentNumber AS foreign Key to apply referential integrity.
Update this answer!

You can help us out by revising, improving and updating this answer.

Update this answer

After you claim an answer you’ll have 24 hours to send in a draft. An editor will review the submission and either publish your submission or provide feedback.