Question 2
Below is a form which holds information about a sports club member, their activities and the equipment used for those activities.
a) Using the technique you are familiar with:
i) Normalise the above form to Third Normal Form (3NF). Show each of the stages of normalisation.
ii) List the resulting entities.
b) With the use of an example explain the approach you would take to deal with multi-valued dependencies during the process of normalisation.
Students succeed in their courses by connecting and communicating with an expert until they receive help on their questions
Consult our trusted tutors.
Login | Sign Up
