In an ERD, what is the purpose of an associative entity?
- To eliminate redundancy in data
- To enforce referential integrity
- To establish a many-to-many relationship between two entities
- To simplify the database structure
The purpose of an associative entity in an ERD is to establish a many-to-many relationship between two entities. It acts as a bridge table, resolving complex relationships by breaking them into simpler one-to-many relationships, which enhances the overall database design.
Loading...
Related Quiz
- In NoSQL databases, what is the significance of the CAP theorem regarding data consistency?
- The _______ constraint ensures that a value in a column matches one of a set of predefined values.
- Which of the following techniques can be employed for database performance tuning?
- One of the key features of column-family stores is their ability to handle _______ workloads efficiently.
- What role does version control play in collaborative data modeling?