CompTIA Data+ (DA0-001) — Question 337

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

Answer options

• A. One-to-many
• B. One-to-one
• C. Non-relational
• D. Many-to-many

Correct answer: D

Explanation

A many-to-many relationship is necessary to create a joining table, as it allows for the linking of records from two different tables. One-to-one and one-to-many relationships do not require a separate joining table, and non-relational is not applicable in the context of relational databases.