Scenario: A retail store maintains a database of products and categories. Each product can belong to multiple categories, and each category can have multiple products. What type of relationship would you establish between products and categories?
- Many-to-Many
- Many-to-One
- One-to-Many
- One-to-One
The relationship between products and categories in this scenario is Many-to-Many. Each product can belong to multiple categories, and each category can have multiple products. This type of relationship is common in scenarios where entities are interconnected in a non-exclusive manner.
Loading...
Related Quiz
- Which feature in database design tools allows users to visually create Entity-Relationship Diagrams (ERDs)?
- What measures can be taken at the application level to ensure data integrity in a distributed system?
- What does SQL stand for in the context of data modeling languages?
- How does collaboration improve the quality of data models?
- What strategies can be employed for handling changing dimensions in Dimensional Modeling?