Scenario: An online store has customers and orders. Each customer can place multiple orders, but an order must belong to one customer. What cardinality and modality does this scenario illustrate?
- Many-to-Many, Optional
- Many-to-One, Optional
- One-to-Many, Mandatory
- One-to-One, Mandatory
This scenario illustrates a One-to-Many relationship with mandatory modality. Each customer can place multiple orders (Many), but each order must belong to one customer (One). The modality is mandatory because every order must be associated with a customer.
Loading...
Related Quiz
- Data partitioning can lead to _______ as data access may involve multiple partitions.
- ER diagram tools support _______ engineering to transition between conceptual and logical database designs.
- What advantage does Microsoft Visio offer over other database design tools?
- What is a common challenge faced when using Key-Value Stores for complex data structures?
- The process of defining common attributes and behaviors for a group of entities is called _______.