How many relations can be formed with two tables?
Answer: C) Three
In Microsoft Access, two tables can have three main types of relationships:
1. One-to-One (1:1): One record in the first table is related to only one record in the second table, and vice versa.
2. One-to-Many (1:M): One record in the first table can be related to multiple records in the second table.
3. Many-to-Many (M:N): Multiple records in the first table can be related to multiple records in the second table. This relationship is usually implemented using a third table called a junction table.
Therefore, three main types of relationships can be formed between two tables.
Microsoft Access मा दुईवटा Table बीच मुख्य रूपमा तीन प्रकारका Relationships बनाउन सकिन्छ।
1. One-to-One (1:1): पहिलो Table को एउटा Record दोस्रो Table को एउटा Record सँग मात्र सम्बन्धित हुन्छ।
2. One-to-Many (1:M): पहिलो Table को एउटा Record दोस्रो Table का धेरै Records सँग सम्बन्धित हुन सक्छ।
3. Many-to-Many (M:N): पहिलो Table का धेरै Records दोस्रो Table का धेरै Records सँग सम्बन्धित हुन सक्छन्। यस्तो सम्बन्ध बनाउन सामान्यतया तेस्रो Table (Junction Table) प्रयोग गरिन्छ।
त्यसैले सही उत्तर C. Three हो।
Exam Tip:
One-to-One = 1:1
One-to-Many = 1:M
Many-to-Many = M:N
यी तीनवटा Database का मुख्य Relationship Types हुन्।
ध्यान दिनुहोस्: Many-to-Many Relationship लाई MS Access मा सिधै दुई Table बीच लागू गर्नुभन्दा Junction Table प्रयोग गरेर दुईवटा One-to-Many Relationships बनाइन्छ।