Consider the relation r1 with the functional dependencies that hold on it:…
Consider the relation r1 with the functional dependencies that hold on it:
r1(p, q, r, s, t)
p → q, r, s, t
s → t
The relation r1 is decomposed into two relations r1_a, r1_b:
r1_a(p, q, r, s)
r1_b(s, t)
Identify the correct statement/s based on this information:
- A.
Relation r1 is in BCNF and r1_a, r1_b are in 3NF
- B.
Relation r1 in in 3NF and r1_a, r1_b are in BCNF
- C.
Relation r1 is in 2NF and r1_a, r1_b are in BCNF
- D.
All the relations r1, r1_a and r1_b are in 3NF
Attempted by 220 students.
Sign up free to check your answer
Sign up freeLoading lesson…

