Which of the following is not a type of relationship that can be applied in Access database
Answer: D) All of above can be applied
Microsoft Access supports three common types of relationships between database tables:
1\. One-to-One: One record in Table A is related to only one record in Table B.\
Example: One person has one passport record.
2\. One-to-Many: One record in Table A can be related to multiple records in Table B.\
Example: One customer can place many orders.
3\. Many-to-Many: Multiple records in Table A can be related to multiple records in Table B.\
Example: Many students can enroll in many courses.
In Access, a many-to-many relationship is implemented using an intermediate (junction) table that connects the two tables through one-to-many relationships.
Therefore, all three relationship types can be applied in an Access database.
Microsoft Access Database मा मुख्यतया तीन प्रकारका Relationships प्रयोग गर्न सकिन्छ:
1\. One-to-One: एउटा Table को एउटा Record अर्को Table को एउटा Record सँग मात्र सम्बन्धित हुन्छ।\
उदाहरण: एउटा व्यक्तिको एउटा Passport Record।
2\. One-to-Many: एउटा Table को एउटा Record अर्को Table का धेरै Records सँग सम्बन्धित हुन सक्छ।\
उदाहरण: एउटा Customer ले धेरै Orders गर्न सक्छ।
3\. Many-to-Many: एउटा Table का धेरै Records अर्को Table का धेरै Records सँग सम्बन्धित हुन सक्छन्।\
उदाहरण: धेरै Students ले धेरै Courses पढ्न सक्छन्।
Access मा Many-to-Many Relationship बनाउन Junction Table प्रयोग गरिन्छ, जसले दुई Tables लाई One-to-Many Relationships मार्फत जोड्छ।
त्यसैले यी तीनवटै Relationship प्रकार प्रयोग गर्न सकिने भएकाले सही उत्तर D. All of the above can be applied हो।
Exam Tip: Access मा One-to-One, One-to-Many र Many-to-Many तीनवटै Relationship सम्भव छन्। Many-to-Many का लागि Junction Table आवश्यक हुन्छ।