Database-Management-System

Question 221

A relation r(A, B) in a relational database has 1200 tuples. The attribute A has integer values ranging from 6 to 20, and the attribute B has integer values ranging from 1 to 20. Assume that the attributes A and B are independently distributed.

820

Database-Management-SystemRelational-databasesGATE 2021 CS-Set-1Video-Explanation

Question 221 Explanation:

Explanation :

Probability of 1st condition being satisfied(say P(A)) = 10/15 = 2/3

Probability of 2nd condition being satisfied(say P(B)) = 1/20

Probability of both conditions being satisfied(say P(A intersection B)) = 2/3*1/20 = 1/30

Probability of any one condition being satisfied = P(A union B) = P(A)+P(B)-P(A intersection B) = 2/3 + 1/20 – 1/30 = 41/60

therefore, expected number of tuples = (41/60)*1200 = 820

Correct Answer: A

Question 221 Explanation:

Explanation :

Probability of 1st condition being satisfied(say P(A)) = 10/15 = 2/3

Probability of 2nd condition being satisfied(say P(B)) = 1/20

Probability of both conditions being satisfied(say P(A intersection B)) = 2/3*1/20 = 1/30

Probability of any one condition being satisfied = P(A union B) = P(A)+P(B)-P(A intersection B) = 2/3 + 1/20 – 1/30 = 41/60

therefore, expected number of tuples = (41/60)*1200 = 820

harikesh chauhan

0 0 votes

Article Rating

0 Comments

Inline Feedbacks

View all comments