Which scenario best represents a one-to-many relationship?

Question

BlackTom AI · Accepted Answer

A one-to-many relationship means a single instance of entity A is associated with zero, one, or many instances of entity B, while each instance of B is associated with at most one instance of A. This concept is common in entity-relationship modeling and relational databases (for example: one customer → many orders).

Step-by-step evaluation of each option:

a) A customer places multiple orders.
- Entities: Customer and Order.
- Multiplicity: One customer can place many orders; each order is normally placed by exactly one customer.
- This matches the one-to-many pattern (Customer:1 → Order:many).

b) Students enrol in multiple courses.
- Entities: Student and Course.
- Multiplicity: A student can enrol in many courses, and each course can have many students.
- That is many-to-many, not one-to-many, unless an intermediate entity (enrolment) is introduced to normalize it.

c) An order contains multiple products.
- On the surface this reads like one-to-many (Order → Product), but in realistic modeling a product can appear on many different orders. That makes the relationship many-to-many (Order ↔ Product), typically implemented with an OrderLine or OrderItem junction table that captures quantity and price.

d) A passport is issued to one person.
- Entities: Passport and Person.
- Multiplicity: Usually each passport maps to exactly one person, and typically a person has at most one passport (or at least one). This is a one-to-one (or one-to-zero/one) relationship, not one-to-many.

Why (a) is correct: it clearly describes a single customer associated with multiple distinct orders, while each order links back to only one customer, which is the textbook one-to-many scenario.

Final confirmation: The correct answer is a. A customer places multiple orders.

Which scenario best represents a one-to-many relationship?单项选择题

类似问题

What shorthand can we use to represent a many-to-many relationship?

Consider the following business rule: 'A professor may advise many students, but each student is assigned to only one advisor.' Which relationship type does this rule establish between the Professor and Student entities?"

Question at position 21 Relational databases establish the relationships between entities by means of common fields included in a file called a(n):relation.entity.relationship.association.

Which of the following is a type of relationship?

The relationship between a Customer and Orders is generally a

What is an example of a one-to-many (1:N) relationship?

The relationship type that is most supported by any relational databases is:

What command allowed you to add tables in the relationship window?

更多留学生实用工具

智能学习助手

风格化写作助手

论文查重助手

文献引用助手

课堂转译助手

课堂笔记助手

Quiz搜索助手

学校历年真题

智能刷题助手

智能匹配练习

希望你的学习变得更简单