Question: 1 . If a relation R is decomposed into { R 1 , R 2 , . . . , Rn } and the decomposition
If a relation R is decomposed into R R Rn and the decomposition is lossless then
a The natural join of R R Rn can have more tuples than the original relation for R
b The relations R RRn are each in rd Normal Form
c The natural join of R R Rn will have the same number of tuples as the original relation R
d None of the above
The functional dependency AB for relation schema RABCD implies that
a No two tuples in R can have the same value for attribute B
b Any two tuples in R that have the same value for B must have the same value for A
c No two tuples in R can have the same value for attribute A
d Any two tuples in R that have the same value for A must have the same value for B
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
