Search for question
Question

Consider the following relation: Student-Dept = (Student-ID, Course, SportActivity, Dept-Name, Building)%3D Having following multivalued dependencies: F ={ Student-ID →→ Course Student-ID →→ SportsActivity Dept-Name →→ Building } Explain in your

own words why the Student-Dept relation is not in 4NF. Then, convert the Student-Dept relation in 4NF. Also, provide the justification for each step you perform during normalization (4NF). Note: The SportActivity here means any sport a student is participating in. For example, a student with ID = 123 can participate in soccer and badminton.

Fig: 1

Fig: 2

Fig: 3

Fig: 4

Fig: 5

Fig: 6

Fig: 7

Fig: 8