Scenario: A library system manages books and borrowers. Each book can be borrowed by multiple borrowers, and each borrower can borrow multiple books. What type of relationship does this scenario represent, and what are its cardinality and modality?
- Many-to-Many, Mandatory
- Many-to-Many, Optional
- One-to-Many, Mandatory
- One-to-One, Optional
This scenario represents a Many-to-Many relationship with optional modality. Each book can be borrowed by multiple borrowers (Many), and each borrower can borrow multiple books (Many). The modality is optional because borrowers may not necessarily borrow books, and books may not necessarily be borrowed by borrowers.
Loading...
Related Quiz
- A social media platform wants to implement a recommendation system based on user interactions. What clustering technique could be employed in the relational schema design to group similar user data for efficient recommendation algorithms?
- What are some potential drawbacks of denormalization?
- In Dimensional Modeling, a _______ key is a surrogate key generated to uniquely identify each record in a dimension table.
- The process of defining common attributes and behaviors for a group of entities is called _______.
- The primary query language used in document-based databases is _______.