ExamGecko
Question list
Search
Search

Question 50 - CITM-001 discussion

Report
Export

Which key is used to create a link and relationship between tables in a relational database?

A.

Primary Key

Answers
A.

Primary Key

B.

Secondary Key

Answers
B.

Secondary Key

C.

Foreign Key

Answers
C.

Foreign Key

Suggested answer: C

Explanation:

A foreign key is a column or a set of columns in one table that references the primary key of another table. It is used to create a link and relationship between tables in a relational database.A foreign key ensures that the values in the referencing table match the values in the referenced table, thus maintaining the referential integrity of the database12.A foreign key can also be used to implement constraints such as cascading updates or deletes3.Reference:1: CITM Study Guide, Chapter 3: Database Management Systems, Page 41.2:Types of Keys in Relational Model (Candidate, Super, Primary, Alternate and Foreign)3:Database Keys: The Complete Guide (Surrogate, Natural, Composite & More)

asked 18/11/2024
Johnny Tien
47 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first