For each of the following two relations, do the following: step 1: identify all

ID: 3780215 • Letter: F

Question

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)

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.