Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

Tell the merits and demerits of Mendeleev's periodic table.

Answered: 1 week ago