Scenario: A hospital manages doctors, patients, and appointments. Each patient can have multiple appointments, each doctor can have multiple appointments, and each appointment is associated with one patient and one doctor. How would you represent this scenario in an ERD?
- Many-to-Many
- Many-to-One
- One-to-Many
- One-to-One
For this scenario, a One-to-One relationship is appropriate. Each appointment is associated with one patient and one doctor. It ensures that each appointment is uniquely linked to a specific patient and doctor, avoiding data redundancy.
Loading...
Related Quiz
- Which type of consistency model ensures that all reads reflect the most recent write for a given data item in a distributed system?
- Database design tools aid in maintaining _______ throughout the database development process.
- How does partition pruning contribute to query optimization in a partitioned database?
- Scenario: A data analyst needs to query a database to extract specific information for a report. Would they likely use SQL or UML for this task, and why?
- Which phase of database design typically involves conceptual schema design?