nerdexam
CompTIA

DA0-001 · Question #432

Which of the following relationships is necessary to define a third table called a "joining table" in relational databases?

The correct answer is D. Many-to-many. A joining table is used to resolve a many-to-many relationship in relational databases. Since many-to-many relationships cannot be directly implemented in relational database tables, a joining table acts as a bridge between the two related tables, containing foreign keys that…

Data Concepts and Environments

Question

Which of the following relationships is necessary to define a third table called a "joining table" in relational databases?

Options

  • AOne-to-many
  • BOne-to-one
  • CNon-relational
  • DMany-to-many

How the community answered

(61 responses)
  • A
    5% (3)
  • B
    3% (2)
  • C
    2% (1)
  • D
    90% (55)

Explanation

A joining table is used to resolve a many-to-many relationship in relational databases. Since many-to-many relationships cannot be directly implemented in relational database tables, a joining table acts as a bridge between the two related tables, containing foreign keys that modeled and queried.

Topics

#Relational databases#Many-to-many relationships#Joining tables#Database design

Community Discussion

No community discussion yet for this question.

Full DA0-001 Practice