Scenario: A university has departments and professors. Each department can have multiple professors, and a professor can belong to only one department. How would you represent this scenario in an Entity-Relationship Diagram (ERD)?
- Many-to-Many
- Many-to-One
- One-to-Many
- One-to-One
In this scenario, a One-to-Many relationship would be appropriate. Each department can have multiple professors (One-to-Many), but a professor can belong to only one department. This reflects the constraint that each professor is associated with a single department.
Loading...
Related Quiz
- How do document-based databases handle complex queries compared to relational databases?
- In Slowly Changing Dimensions (SCD), Type 4 utilizes an _______ table to store historical changes.
- Scenario: A large corporation is planning to implement a centralized repository for historical data analysis. Which approach, Data Warehouse or Data Mart, would be more suitable for their needs and why?
- In a fact table, each record represents a _______ at a specific level of detail.
- What are the main advantages of using clustering in a distributed database system?