Consider the following statements S1 and S2 about the relational data model:
S1: A relation scheme can have at most one foreign key.
S2: A foreign key in a relation scheme R cannot be used to refer to tuples of R.
Which one of the following choices is correct?
Suppose the following functional dependencies hold on a relation U with attributes P, Q, R, S, and T :
P → QR
RS → T
Which of the following functional dependencies can be inferred from the above functional dependencies?
Let S be the following schedule of operations of three transactions T1, T2 and T3 in a relational database system:
R2(Y), R1(X), R3(Z), R1(Y), W1(X), R2(Z), W2(Y), R3(X), W3(Z)
Consider the statements P and Q below:
P: S is conflict-serializable.
Q: If T3 commits before T1 finishes, then S is recoverable.
Which one of the following choices is correct?
Which one of the following circuits implements the Boolean function given below?
f(x, y, z) = m0 + m1 + m3 + m4 + m5 + m6, where mi is the ith minterm.