Advertisements
Advertisements
Question
Find out databases with different relations and relationships.
Short Answer
Advertisements
Solution
| Database | Relations / Tables | Relationship |
|---|---|---|
| School Database | Student, Class | One-to-Many |
| Library Database | Member, Book | Many-to-Many |
| Bank Database | Customer, Account | One-to-Many |
| Hospital Database | Patient, Doctor | Many-to-Many |
| Employee Database | Employee, ID Card | One-to-One |
Types of relationships:
- One-to-One: One record in a table is related to only one record in another table.
- One-to-Many: One record in a table can be related to many records in another table.
- Many-to-Many: Many records in one table can be related to many records in another table.
shaalaa.com
Is there an error in this question or solution?
