Consider the two relations below. The primary keys are underlined. Identify all possible foreign key(s) from the options based only on the two Q relations. EMP (eid, ename, did) DEPT (did, dname)
Pick an option to check yourself, or open the answer below.
Show answer & explanation
Correct answer: B. did
Explanation
EMP.did refers to DEPT's primary key did, so did is the foreign key.
More Database Management Systems questions
- Which of the following is consistent with this instance of R(X, Y, Z): (1, 1, a), (1, 1, a), (2, 1, b), (3, 2, b)?
- R1(Name, Class) = {(a1, 9), (b1, 5), (c1, 6), (d1, 11)} and R2(Name, Class) = {(b1, 5), (f1, 8)}. Which operation produces the output {(b1,…
- Match List I and List II
- Which relational algebra query computes the names of sailors who have reserved all boats?
- Which relational algebra query computes the names of sailors who have reserved a red and a green boat?
- Let R(ABCDEFGH) be a relation schema and F = {A → B, ABCD → E, EF → G, EF → H, ACDF → EG}. The minimal cover of this set of dependencies is