In relationship (Teacher teaches section). Where do you place foreign key when mapping ER Diagram to schema Select one: O a. In table section O b. In table Teacher O c. In a separate table O d. On relationship

Oracle 12c: SQL
3rd Edition
ISBN:9781305251038
Author:Joan Casteel
Publisher:Joan Casteel
Chapter6: Additional Database Objects
Section: Chapter Questions
Problem 1MC
icon
Related questions
Question

Database

Database

Database

In relationship (Teacher teaches section). Where do you place foreign key when
mapping ER Diagram to schema
Select one:
O a. In table section
O b. In table Teacher
O c. In a separate table
O d. On relationship
Transcribed Image Text:In relationship (Teacher teaches section). Where do you place foreign key when mapping ER Diagram to schema Select one: O a. In table section O b. In table Teacher O c. In a separate table O d. On relationship
Candidate keys are
Select one:
O a. set of foreign keys such that any of these keys can work as a primary key for a table
O b. set of keys such that some of these keys can work as a primary key for a table
O c. Keys that connect tables
O d. set of keys such that any of these keys can work as a primary key for a table
Transcribed Image Text:Candidate keys are Select one: O a. set of foreign keys such that any of these keys can work as a primary key for a table O b. set of keys such that some of these keys can work as a primary key for a table O c. Keys that connect tables O d. set of keys such that any of these keys can work as a primary key for a table
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Table
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning