hardMultiple ChoiceObjective-mapped
FC0-U71 Practice Question: A database analyst is designing a schema for a…
A database analyst is designing a schema for a library system. Each book can have multiple authors, and each author can write multiple books. Which relationship type should be used?
⚠ Common exam trap
Test-takers frequently confuse one-to-many with many-to-many when the problem statement mentions 'multiple' on one side only, but the key is that both entities can have multiple related records, which requires a junction table.
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
✓
Many-to-many
The correct relationship is many-to-many because a book can have multiple authors and an author can write multiple books. In database schema design, this requires a junction table (also known as a linking or associative table) to resolve the many-to-many relationship into two one-to-many relationships, ensuring referential integrity and avoiding data redundancy.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Many-to-one
Why it's wrong here
Many-to-one is the inverse of one-to-many and does not solve the requirement for multiple authors per book.
- ✗
One-to-many
Why it's wrong here
One-to-many would allow one author to have many books but not many authors per book.
- ✓
Many-to-many
Why this is correct
Many-to-many is correct because a book can have multiple authors and an author can write multiple books, requiring a junction table.
- ✗
One-to-one
Why it's wrong here
One-to-one would incorrectly restrict each book to one author and each author to one book.
Visual reference
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 →
Same concept, more angles
1 more way this is tested on FC0-U71
These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.
Variation 1. A database has a 'Students' table and an 'Enrollments' table. Which type of relationship exists if a student can enroll in multiple courses and each course can have multiple students?
hard- ✓ A.Many-to-many
- B.Many-to-one
- C.One-to-many
- D.One-to-one
Why A: A many-to-many relationship requires a junction table (like Enrollments) linking the two tables.
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.