FC0-U71 Data and Database Fundamentals Practice Question
A sales database has a Customers table with CustomerID as the primary key and an Orders table that includes CustomerID. Which type of relationship is typically established between Customers and Orders?
⚠ Common exam trap
The trap is overthinking the relationship — candidates sometimes pick many-to-many because a customer can have many orders and an order can have many items, but the question is strictly about Customers and Orders.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
One-to-many
A single customer can place many orders, but each order belongs to exactly one customer, which is the definition of a one-to-many relationship. The CustomerID foreign key in the Orders table references the primary key in Customers, enforcing that each order is tied to one customer while allowing a customer to have multiple orders.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
One-to-one
Why it's wrong here
One-to-one links a single row in each table, so it cannot represent one customer having many orders. It is tempting because it is used for splitting a table's columns, such as isolating sensitive data, where each record maps to exactly one counterpart. Here, CustomerID repeats across Orders, making the relationship one-to-many.
- ✗
Many-to-many
Why it's wrong here
A many-to-many relationship requires a junction table to resolve it, since neither Customers nor Orders can hold multiple foreign keys pointing at each other directly. Here, Orders carries a single CustomerID foreign key, making it one-to-many. Many-to-many fits scenarios such as students enrolling in multiple courses, where an enrolment link table is needed.
- ✗
Unrelated
Why it's wrong here
Customers and Orders link through the shared CustomerID column, so each customer can have many orders: a one-to-many relationship. Unrelated would mean no common column joins the tables, which contradicts the stated foreign key. The presence of CustomerID in Orders establishes the relationship.
- ✓
One-to-many
Why this is correct
One customer can place many orders, while each order belongs to exactly one customer, so CustomerID in Orders acts as a foreign key referencing the Customers primary key. This cardinality defines a one-to-many relationship, not one-to-one or many-to-many.
About these practice questions
One of 988 original FC0-U71 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official CompTIA exam blueprint
This FC0-U71 practice question is part of Courseiva's free CompTIA certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the FC0-U71 exam.