Sample HW5 Solution

Signature date

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

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: ce or a website without indicating what has been quoted and providing an appropriate citation; • I have not submitted this assignment to satisfy the requirements of any other course. Signature__________________________ Date ____________________ Problem 1 (20pts) Consider relation R with attributes ABCDE, with AB as its key, and with the following functional dependencies: B è༎ D, C è༎D, C è༎E. (a) (5pts) Explain why this relation is not in 3NF. Solution: This relation is not in 3NF because none of the functional dependencies are of the kind that 3NF admits. In particular, for B è༎ D, B is not a candidate key or a superkey, this FD is not trivial (D is not a subset of B),...
View Full Document

This note was uploaded on 01/21/2014 for the course INFO 210 taught by Professor Stoy during the Winter '13 term at Drexel.

Ask a homework question - tutors are online