Scenario: A company has employees and projects. An employee can work on multiple projects, and a project can have multiple employees working on it. Which type of relationship would you use to represent this scenario in an ERD?
- Many-to-Many
- Many-to-One
- One-to-Many
- One-to-One
In this scenario, a Many-to-Many relationship is appropriate. This allows each employee to work on multiple projects, and each project to have multiple employees associated with it. It involves a junction table to manage the relationship.
Loading...
Related Quiz
- Database design tools aid in maintaining _______ throughout the database development process.
- What type of data does a graph database model emphasize?
- How does collaborative data modeling differ from individual data modeling?
- How do ER diagram tools facilitate team collaboration and project management in large-scale database projects?
- Which NoSQL database type is most suitable for graph-based data modeling?