easyMultiple ChoiceObjective-mapped
FC0-U71 Practice Question: Store customer orders, where each order can…
A company needs to store customer orders, where each order can contain multiple items. Which database design is most appropriate?
⚠ Common exam trap
Many candidates choose Option D (single table with repeated columns) because it seems simpler, but they overlook the violation of first normal form and the practical limitations of fixed-width schemas for variable-length data.
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
✓
Two tables: Orders and OrderItems, linked by an OrderID foreign key.
It uses a normalized relational design with two tables: Orders (holding order-level data) and OrderItems (holding individual item details per order). The OrderID foreign key in OrderItems creates a one-to-many relationship, allowing each order to contain multiple items without data redundancy or update anomalies. This design ensures referential integrity and efficient querying, which is the standard approach for transactional order systems.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Three tables: Orders, Customers, and Items, with no direct link.
Why it's wrong here
Item details are not needed; the core relationship is order-to-items.
- ✓
Two tables: Orders and OrderItems, linked by an OrderID foreign key.
Why this is correct
This normalized design efficiently handles one-to-many relationships.
- ✗
A single table storing all data in a JSON column.
Why it's wrong here
While possible, relational database design typically uses separate tables for normalization.
- ✗
A single table with columns for order details and repeated item information.
Why it's wrong here
This leads to data redundancy and update anomalies.
Go deeper
Related to this question
About these practice questions
This FC0-U71 question is part of Courseiva's 988-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
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.