Which of the following is not a relationship type?
Answer: B) Many to one
In database management systems, there are three main types of relationships between tables:
1. One-to-One (1:1): One record in the first table is related to only one record in the second table.
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.
Many-to-One (M:1) is not usually listed as a separate relationship type because it is simply the reverse perspective of a One-to-Many relationship.
For example, many students can belong to one class. This is Many-to-One from the students' perspective, but One-to-Many from the class's perspective.
Therefore, the expected answer is B. Many to One.
Database Management System मा 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 सँग सम्बन्धित हुन सक्छन्।
Many-to-One (M:1) लाई छुट्टै मुख्य Relationship Type मानिँदैन, किनकि यो One-to-Many Relationship को उल्टो दृष्टिकोण मात्र हो।
उदाहरणका लागि, एउटा कक्षामा धेरै विद्यार्थी हुन सक्छन्। विद्यार्थीको दृष्टिकोणबाट यो Many-to-One हो भने कक्षाको दृष्टिकोणबाट One-to-Many हो।
त्यसैले परीक्षामा अपेक्षित उत्तर B. Many to One हो।
Exam Tip:
मुख्य तीन Relationship Types याद गर्नुहोस्:
One-to-One (1:1)
One-to-Many (1:M)
Many-to-Many (M:N)
ध्यान दिनुहोस्: Many-to-One पनि सम्बन्धको वैध Cardinality हो; तर यसलाई सामान्यतया One-to-Many कै उल्टो रूपमा बुझिन्छ। त्यसैले प्रश्नले छुट्टै मुख्य Relationship Type सोधेको अवस्थामा B अपेक्षित उत्तर हो।