English

Find out databases with different relations and relationships.

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:

  1. One-to-One: One record in a table is related to only one record in another table.
  2. One-to-Many: One record in a table can be related to many records in another table.
  3. 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?
Chapter 5: Database Concepts using Libre Office Base - Intest Questions [Page 97]

APPEARS IN

Balbharati Information Technology (Commerce) [English] Standard 12 Maharashtra State Board
Chapter 5 Database Concepts using Libre Office Base
Intest Questions | Q 1. | Page 97
Share
Notifications

Englishहिंदीमराठी


      Forgot password?
Use app×