Scenario: In a company's database, each employee has a manager who is also an employee. What type of relationship would you represent between the "Employee" entity and itself in the ERD?
- Many-to-Many
- Many-to-One
- One-to-Many
- One-to-One
The relationship between an "Employee" and their "Manager" in this scenario is One-to-One, as each employee has only one manager, and each manager oversees only one employee, forming a one-to-one relationship.
Loading...
Related Quiz
- The ________ approach involves defining a maximum number of retry attempts to prevent infinite retries.
- ________ involves setting predefined thresholds for key metrics to trigger alerts in case of anomalies.
- Which data quality metric assesses the degree to which data conforms to predefined rules?
- Scenario: A company is planning to migrate its legacy systems to a modern data infrastructure. As part of this migration, they need to redesign their ETL processes to accommodate the new architecture. What steps would you take to ensure a smooth transition and minimize disruption to ongoing operations?
- What role do DAGs (Directed Acyclic Graphs) play in workflow orchestration tools?