Scenario: A company has employees and departments. Each employee must be assigned to one department, but a department can have multiple employees. What cardinality and modality does this scenario represent?
- Many-to-Many, Optional
- Many-to-One, Mandatory
- One-to-Many, Mandatory
- One-to-One, Optional
This scenario represents a One-to-Many relationship with mandatory modality. Each department can have multiple employees (Many), while each employee must be assigned to one department (One). The modality is mandatory because every employee must be assigned to a department.
Loading...
Related Quiz
- Scenario: A social media platform tracks users and their posts. Each user can have multiple posts, and each post can have multiple comments. How would you model this relationship in an ERD?
- Which type of consistency model ensures that all reads reflect the most recent write for a given data item in a distributed system?
- Scenario: A team of developers is tasked with designing a database for a large e-commerce platform. They need a tool that can handle complex data models and allow for seamless collaboration. Which database design tool would you recommend, and why?
- Scenario: An online store has various types of products, including electronics and clothing. Each product has common attributes like name and price, but they also have specific attributes. How would you design the database schema for this scenario?
- Clustering reduces the need for _______ by organizing similar data together.