the following functional dependencies hold good for

Report

Report an issue

Name

Email

Message

Submit

Cancel

PGCET CSE Exam (Karnataka) 2011 click here to view all questions

A100

B200

C300

D20000

Nithin K ? Dec 7 '2016 at 22:3

Answer: 100

Explanation:

From the given set of functional dependencies, it can be observed that B is a candidate key of R.

So all 200 values of B must be unique in R. There is no functional dependency given for S. To get the maximum number of tuples in output, there can be two possibilities for S.
1) All 100 values of B in S are same and there is an entry in R that matches with this value. In this case, we get 100 tuples in output.
2) All 100 values of B in S are different and these values are present in R also. In this case also, we get 100 tuples.

All DiscussionsClick here to write answer

Answer: 100 Explanation: From the given set of functional dependencies, it can be observed that B is a candidate key of R. So all 200 values of B must be unique in R. There is no functional dependency given for S. To get the maximum number of tuples in output, there can be two possibilities for S. 1) All 100 values of B in S are same and there is an entry in R that matches with this value. In this case, we get 100 tuples in output. 2) All 100 values of B in S are different and these values are present in R also. In this case also, we get 100 tuples. Nithin K ? answered Dec 7 '2016 at 22:3 All Comments

Post your answers here:

Post

Post your comments here:

Message

Post

Cancel