SEBA class 10 IT Chapter 10 Answer 2025 Assamese Medium (SCERT Assam board) | Working With Multiple Tables|

 Lesson 10

Working With Multiple Tables

👉Text Books PDF
👉MCQ Online Exam
👉MCQ Answer
👉Paid Answer (For Membership User)

1. What is the purpose of working with multiple tables in LibreOffice Base? (LibreOffice Base-ত একাধিক Table-ৰ সৈতে কাম কৰাৰ উদ্দেশ্য কি?)
Answer:

• It allows organizing data efficiently by storing different types of information in separate tables.
• It reduces data redundancy and improves data consistency.
  (একাধিক Table ব্যৱহাৰে ডাটা সুসংগঠিত কৰে, ডাটা পুনৰাবৃত্তি হ্ৰাস কৰে আৰু শুদ্ধতা বৃদ্ধি কৰে।)

2. What is a relationship between tables in LibreOffice Base? (LibreOffice Base-ত Table-সমূহৰ মাজত সম্পৰ্ক কি?)
Answer: A relationship is a connection between two or more tables based on a common field.
(Table-সমূহৰ মাজত সাধাৰণ Field-ৰ মাধ্যমেৰে সম্পৰ্ক স্থাপন কৰা হয়, যাৰ ফলত Table-সমূহ একেলগে কাম কৰে।)

3. What are the types of relationships in LibreOffice Base? (LibreOffice Base-ত Table Relationship-ৰ প্ৰকাৰসমূহ কি?)
Answer:

• One-to-One
• One-to-Many
• Many-to-Many
  (One-to-One, One-to-Many, আৰু Many-to-Many এই তিনিধৰণৰ Relationship থাকে।)

4. What is the benefit of One-to-Many relationship? (One-to-Many Relationship-ৰ লাভ কি?)
Answer:

• It allows connecting multiple records from one table to a single record in another table.
• It is commonly used in database management.
  (One-to-Many Relationship-এ এটা Table-ৰ একাধিক Recordক আন এটা Table-ৰ এটা Record-ৰ সৈতে সংযোগ কৰে।)

5. What is the role of Primary Key in multiple tables? (LibreOffice Base-ত একাধিক Table-ত Primary Key-ৰ ভূমিকা কি?)
Answer:

• It uniquely identifies each record in a table.
• It ensures that there are no duplicate records.
  (Primary Key-এ প্ৰতিটো Record চিনাক্ত কৰে আৰু একে ডাটা পুনৰাবৃত্তি হোৱাত বাধা দিয়ে।)

6. What is a Foreign Key in LibreOffice Base? (LibreOffice Base-ত Foreign Key কি?)
Answer:

• A Foreign Key is a field in one table that links to the Primary Key of another table.
• It creates relationships between tables.
  (Foreign Key হল এটা Table-ৰ Field, যিয়ে আন Table-ৰ Primary Key-ৰ সৈতে সংযোগ কৰে।)

7. How can you create relationships between tables in LibreOffice Base? (LibreOffice Base-ত Table-ৰ মাজত সম্পৰ্ক কেনেকৈ সৃষ্টি কৰিব?)
Answer:

• Open LibreOffice Base → Go to Tools → Click on Relationships → Add tables → Drag and drop fields to create relationships.
  (LibreOffice Base খুলক → Tools-ত ক্লিক কৰক → Relationships-ত ক্লিক কৰক → Table যোগ কৰক → Field টানি সংযোগ কৰক।)

8. What is Referential Integrity in LibreOffice Base? (LibreOffice Base-ত Referential Integrity কি?)
Answer: Referential Integrity ensures data consistency by preventing invalid data entry in related tables.
(Referential Integrity-এ সম্পৰ্কিত Table-সমূহত ডাটা শুদ্ধতা বজাই ৰাখে আৰু অবৈধ ডাটা প্ৰৱিষ্ট হ'ব নোৱাৰে।)

9. What is a join in LibreOffice Base? (LibreOffice Base-ত Join কি?)
Answer:

• A join is used to combine data from two or more tables based on a related column.
• It displays related information from multiple tables.
  (Join হল সম্পৰ্ক থকা Table-সমূহৰ ডাটা একেলগে মিলাই দেখুৱোৱা প্ৰক্ৰিয়া।)

10. What are the types of joins in LibreOffice Base? (LibreOffice Base-ত Join-ৰ প্ৰকাৰসমূহ কি?)
Answer:

• Inner Join
• Left Join
• Right Join
  (Inner Join, Left Join, আৰু Right Join প্ৰধান Join-ৰ প্ৰকাৰ।)

11. What is the difference between Inner Join and Outer Join? (Inner Join আৰু Outer Join-ৰ মাজত পাৰ্থক্য কি?)
Answer:

• Inner Join: Displays only matching records from both tables.
• Outer Join: Displays all records from one table and matching records from the other table.
  (Inner Join-এ কেৱল মিল থকা ডাটা দেখুৱায়, আৰু Outer Join-এ সকলো ডাটা দেখুৱায় আৰু মিল থকা ডাটা মিলাই দেখুৱায়।)

12. What is a multi-table query in LibreOffice Base? (LibreOffice Base-ত Multi-Table Query কি?)
Answer: A multi-table query retrieves data from two or more related tables.
(Multi-Table Query-এ একাধিক সম্পৰ্ক থকা Table-ৰ পৰা ডাটা উলিয়াই আনে।)

13. What is the advantage of using multiple tables? (LibreOffice Base-ত একাধিক Table ব্যৱহাৰৰ সুবিধা কি?)
Answer:

• It reduces data redundancy.
• It organizes data efficiently.
• It makes data retrieval easier.
  (একাধিক Table ব্যৱহাৰে ডাটা পুনৰাবৃত্তি হ্ৰাস কৰে, ডাটা সুসংগঠিত কৰে আৰু সহজে উলিয়াই আনে।)

14. What is the purpose of normalization in LibreOffice Base? (LibreOffice Base-ত Normalization-ৰ উদ্দেশ্য কি?)
Answer:

• It reduces data redundancy.
• It ensures data consistency.
  (Normalization-এ ডাটা পুনৰাবৃত্তি হ্ৰাস কৰে আৰু শুদ্ধতা বজাই ৰাখে।)

15. What is the use of Relationships Window in LibreOffice Base? (LibreOffice Base-ত Relationships Window-ৰ ব্যৱহাৰ কি?)
Answer:

• It allows users to create, view, and manage relationships between tables.
• It displays the links between multiple tables.
  (Relationships Window-এ Table-সমূহৰ মাজত সম্পৰ্ক সৃষ্টি, পৰিদৰ্শন, আৰু পৰিচালনা কৰিব পাৰে।)

EDIT BY : KRISHNA SAIKIA