Q1: Normalize the following Schema with the given functional dependencies into BCNF. EnrollStud StudID ClassID Grade ProfID StudName Functional

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.

Looking for a Similar Assignment? Our Writers can help. Use the coupon code SAVE15 to get your first order at 15% off!