Question: Consider a relation R with five attributes ABCDE. 1. For each of the following instances of R, state whether it violates (a) the FD BC
1. For each of the following instances of R, state whether it violates (a) the FD BC → D and (b) the MVD BC →→ D:
(a) { } (i.e., empty relation)
(b) {(a,2,3,4,5), (2,a,3,5,5)}
(c) {(a,2,3,4,5), (2,a,3,5,5), (a,2,3,4,6)}
(d) {(a,2,3,4,5), (2,a,3,4,5), (a,2,3,6,5)}
(e) {(a,2,3,4,5), (2,a,3,7,5), (a,2,3,4,6)}
(f) {(a,2,3,4,5), (2,a,3,4,5), (a,2,3,6,5), (a,2,3,6,6)}
(g) {(a,2,3,4,5), (a,2,3,6,5), (a,2,3,6,6), (a,2,3,4,6)}
2. If each instance for R listed above is legal, what can you say about the FD A → B?
Step by Step Solution
3.30 Rating (165 Votes )
There are 3 Steps involved in it
1 The answer sometimes depends on the value of a Unless otherwise mentioned the answer applies to al... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
960-C-S-D (2500).docx
120 KBs Word File
