Database Design Multiple Choice Let us apply class material. We have the followi

Question

Database Design Multiple Choice

Let us apply class material. We have the following logical schema. Let us assume that it is correct. Which of the following statement is true? (a) The primary key of DRIVER is either StateCode or LicenseNo. (b) StateCode in DRIVER is a foreign key that references StateCode in STATE. (c) StateCode in STATE is a foreign key that references StateCode in DRIVER. (d) The arrow in this logical schema denotes the fact that DRIVER is a subclass entity of STATE. (e) None of (a) through (d) is true.

Explanation / Answer

B option is correct because foreign key is a column which match a primary key in different table. Here StateCode of Driver table matches with StatcCode primary key of State table.

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.