INFO210_HW4_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: from a printed source 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 (15pts) Consider relation R with attributes ABCDE. Assume that R has two candidate keys, A and BC. (a) (5pts) List the functional dependencies (FDs) defined by the candidate keys of R. Solution: A - > BCDE BC - > ADE (b) (10pts) Consider now an instance of R listed below, and a set of additional FDs. For each FD, state whether it is satisfied in the instance of R. If your answer is no, give an example of a violation. A B C D E a...
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