database homework

Q1:  

Normalize the following Schema with the given functional dependencies into BCNF. 

EnrollStud (StudID, ClassID, Grade, ProfID, StudName) 

Functional Dependencies:

FD1: StudID, ClassID -> Grade, ProfID, StudName

FD2: StudID ->StudName

FD3: ClassID->ProfID 

Q2:

  

Consider the following relation: 

Student-Dept = (Student-ID, Course, SportActivity, Dept-Name, Building)

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.