Consider the two relations below (primary keys: EMP.eid and DEPT.did). Identify all possible foreign key(s) based only on the two 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 the primary key of DEPT, so did is the only foreign key.More Database Management Systems questions
- Which of the following statements is correct according to the following instance of the relational schema R(X, Y, Z)?X Y Z 1 1 a 1 1 a 2 1…
- What are the drawbacks of using file systems to store data? 1. Data inconsistency 2. Difficulty in accessing data 3. Data isolation 4. Atom…
- In which of the following database models do we have a parent-child relationship? 1. Hierarchical databases 2. Network databases 3. Relatio…
- Identify the correct operation that produces the given output from the two relations R1 and R2.R1 Name Class a1 9 b1 5 c1 6 d1 11 R2 Name C…
- Match List I with List II. Choose the correct answer from the options given below:List I List II a. Apache Kafka I. Platform for constructi…
- Select the correct order of the DBSCAN algorithm. I. Recursively find all density-connected points and assign them to the same cluster as t…