Scenario: You are designing an ERD for an online shopping platform. Each product can belong to multiple categories, and each category can have multiple products. What type of relationship would you represent between the "Product" and "Category" entities?
- Many-to-Many
- Many-to-One
- One-to-Many
- One-to-One
The relationship between "Product" and "Category" entities in this scenario is Many-to-Many, as each product can belong to multiple categories, and each category can have multiple products, forming a many-to-many relationship.
Loading...
Related Quiz
- ________ is a data transformation technique used to identify and eliminate duplicate records from a dataset.
- How does Apache Airflow handle retries and error handling in workflows?
- In a physical data model, denormalization is sometimes applied to improve ________.
- Which of the following best describes the primary purpose of database normalization?
- ________ is a framework that provides guidelines for organizations to manage and protect sensitive data and maintain compliance with relevant regulations.