Which of the following multivalued dependency is satisfied by the relation insta
ID: 3821371 • Letter: W
Question
Which of the following multivalued dependency is satisfied by the relation instance in Table 1?
A
B
C
D
11
21
31
41
11
21
32
42
11
22
31
41
11
23
32
42
12
22
31
41
1. Check if the MVD is satisfied:
(a) A->>B YES NO
(b) A->>D YES NO
(c) B->>A YES NO
(d) B->>D YES NO
(e) D->>A YES NO
(f) D->>B YES NO
2.What functional dependencies would be satisfied by inserting the tuples(11,21,32,41) and (11,21,31,42) in the table:
A. A->>B
B. A->>D
C. B->>A
D. B->>D
E. none of the above
3. What functional dependencies would be satisfied by inserting the tuple(12,21,31,41) in the table:
A. B->>A
B. A->>D
C. D->>B
D. D->>A
E. none of the above
4.What functional dependencies would be satisfied by inserting the tuples(11,22,32,42) and (11,23,31,41) in the table:
A. A->>B
B. A->>D
C. B->>D
D. D->>A
E. none of the above
5. What functional dependencies would be satisfied by inserting the tuples(11,21,31,42), (11,22,31,42), (11,21,32,41) and (11,23,32,41) in the table:
A. A->>B
B. A->>D
C. D->>B
D. B->>A
E. none of the above
A
B
C
D
11
21
31
41
11
21
32
42
11
22
31
41
11
23
32
42
12
22
31
41
Explanation / Answer
1. (c) B->>A YES NO
2. A. A->>B
3. E. none of the above
4. C. B->>D
5. D. B->>A
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.