You are given the following relational schema ( keys bolded ): Faculty( SSN ,Nam

ID: 651238 • Letter: Y

Question

You are given the following relational schema (keys bolded):

Faculty(SSN,Name)

Student(PersonNo, Name)

Course(CourseNo, Title)

Offering(CourseNo, Semester, InstructorSSN, Credit)

Enrolls(CourseNo, Semester, PersonNo, Grade)

1. Represent the above schema as a single relation schema R with a set of functional dependencies F.

2. Is the resulting schema R in BCNF? Prove your answer using the appropriate definitions.

3. If R is not in BCNF, provide its lossless join decomposition into BCNF and determine whether it preserves the dependencies in F.

1. R( SSN, Name, Personno, PName, CourseNo, Title, semester,Credit, Grade)

Functional Dependencies:

2. Yes, resulting schema R is in BCNF because Every determinant(SSN, PersonNo, courseNo etc) in functional dependencies is a super key.

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