INFO210_HW4_solution

# Furthermore iy y is a trivial fd so it does not

This preview shows page 1. Sign up to view the full content.

This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: at the following FDs hold: INA - > R, IR - > S. Is Professor in BCNF? Explain you answer. If your answer is no, clearly identify all FDs that violate BCNF. Solution: Yes, Professor is in BCNF in this case. The FDs INA - > R and IR - > S each contain a superkey on the left- hand side, and so do not violate BCNF. (c) Suppose that the following FDs hold: IY - > Y, IR - > S. Is Professor in BCNF? Explain you answer. If your answer is no, clearly identify all FDs that violate BCNF. Solution: Yes, Professor is in BCNF in this case. The FDs IY - > Y and IR - > S each contain a superkey on the left- hand side, and so do not violate BCNF. Furthermore IY - > Y is a trivial FD, so it does not viola...
View Full Document

Ask a homework question - tutors are online