3. Databases

Relational Model — Quiz

Test your understanding of relational model with 5 practice questions.

Practice Questions

Question 1

Given a relation R(A,B,C,D) with functional dependencies $A\to B$, $B\to C$, and $C\to D$, what is a minimal candidate key for R?

Question 2

Consider the decomposition of R(A,B,C,D) into R1(A,B,C) and R2(C,D). Under which condition is this decomposition lossless?

Question 3

Which of the following best describes the result of the relational division operation $R\div S$?

Question 4

In relational algebra, which property distinguishes a natural join from an equi-join?

Question 5

Which statement correctly describes the relationship between superkeys, candidate keys, and primary keys in the relational model?