Relationship established with
Answer: C) Foreign key
In Microsoft Access, a relationship between two tables is generally established using a Primary Key in one table and a matching Foreign Key in another table.
A Foreign Key is a field that refers to the Primary Key of another table. It helps connect related records between tables and maintain referential integrity.
Example:
Suppose we have two tables:
- Student Table: StudentID (Primary Key), StudentName
- Result Table: ResultID (Primary Key), StudentID (Foreign Key), Marks
Here, StudentID connects the Student Table with the Result Table.
Why the other options are incorrect:
- A. Two identical tables: Tables do not need to be identical to establish a relationship.
- B. One numeric and other text field: Related fields generally need compatible data types, not necessarily one numeric and one text field.
- C. Foreign Key: This is the expected answer because a Foreign Key links related tables.
- D. All of the above: Incorrect because A and B are not general requirements.
Microsoft Access मा दुईवटा Table बीच Relationship बनाउन सामान्यतया एउटा Table को Primary Key र अर्को Table को मिल्दो Foreign Key प्रयोग गरिन्छ।
Foreign Key भनेको अर्को Table को Primary Key लाई Reference गर्ने Field हो। यसले दुईवटा Table बीच सम्बन्ध स्थापित गर्न मद्दत गर्छ।
उदाहरण:
दुईवटा Table मानौँ:
- Student Table: StudentID (Primary Key), StudentName
- Result Table: ResultID (Primary Key), StudentID (Foreign Key), Marks
यहाँ Result Table को StudentID ले Student Table को StudentID सँग सम्बन्ध स्थापित गर्छ।
त्यसैले सही उत्तर C. Foreign Key हो।
Exam Tip:
- Primary Key: Table को प्रत्येक Record लाई छुट्टाछुट्टै पहिचान गर्छ।
- Foreign Key: अर्को Table को Primary Key लाई Reference गर्छ।
- Relationship: दुई वा बढी Table बीच सम्बन्ध स्थापित गर्छ।
सम्बन्धित Field हरूको Data Type मिल्दो वा Compatible हुनुपर्छ।