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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started