For each of the following two relations do the following ste

For each of the following two relations, do the following:

step 1: identify all the functional dependency you can recognize

step 2: show an example where redundancy may arise in the table

step 3: explain the highest normal form the relation satisfies.

step 4: If it is not BCNF, decompose it into BCNF.

A. Enroll (StudentID, CourseID, CourseName, Semester, Grade)

Note: StudentID and CourseID are underlined

B. FacultyInDepartment (ProfID, DepartmentID, DepartmentChair)

Note: ProfID is underlined (Chegg won\'t allow me to underline it)

A. Enroll(StudentID,CourseID,CourseName,Semester,Grade)

Step 1:.Functional dependencies

CourseID ----> CourseName

StudentID ------> Grade

StudentID --------> Semester

Step 2:. BCNF

Course(CourseID,CourseName)

Student(StudentID,Semester,Grade)

B. FacultyInDepartment(ProfID,DepartmentID,DepartmentChair)

Step 1: DepartmentID ----> DepartmentChair

ProfID -----> DepartmentID

Step 2: Professor(ProfID,DepartmentID)

Department(DepartmentID,DepartmentChair)