Smart Learning

Digital Learning

Monday, October 6, 2025

What is multiple tables? Class-10-Part:B-Unit:3-Ch:3:

by
on in


CBSE SOLUTIONS-2025-26
CLASS-10-PART-B
unit-3 database Management system using lobreoffice base

chapter- 3 working with multiple tables

A. Fill in the Blanks.
Question.1: ________ is a rule that maintains consistency between related tables ensuring that changes in the parent table are reflected in the child table.
Answer: Referential Integrity
Question.2: In a ________ relationship, a record in one table can have many matching records in another table, but each matching record has only one corresponding record in the first table.
Answer: One-to-Many
Question.3: A relationship is created between tables based on matching ________ in both tables.
Answer: Fields
Question.4: A ________ relationship occurs when a single record in one table is associated with only one record in another table.
Answer: One-to-One
Question.5: In LibreOffice Base, the ________ dialogue box is used to create and manage relationships between tables.
Answer: Relationships
Question.6: ________ option in relationships ensures that related records in the child table are automatically deleted when the parent record is deleted.
Answer: Cascade Delete

B. True or False.
Question.1: A primary key must always contain unique values.
Answer: True
Question.2: Referential integrity ensures that data across related tables remains consistent.
Answer: True
Question.3: It is possible to create a relationship between two tables without a foreign key.
Answer: False
Question.4: You can delete a record from the parent table without affecting the child table when referential integrity is enforced.
Answer: False
Question.5: In a one-to-many relationship, one record in the parent table can relate to multiple records in the child table.
Answer: True
Question.6: You can create relationships between tables in the Relationships dialogue box of LibreOffice Base.
Answer: True


C. Multiple Choice Questions.
Question.1: Which of the following is used to uniquely identify each record in a table?
a) Foreign Key  b) Primary Key  c) Composite Key  d) Field Key
Answer: (b) Primary Key
Question.2: Which option allows you to delete a record from a table?
a) Delete Key  b) Right Click → Delete Record  c) Cut  d) Format → Delete
Answer: (b) Right Click → Delete Record
Question.3: What type of relationship exists when one record in a table corresponds to many records in another table?
a) One-to-One  b) Many-to-Many  c) One-to-Many  d) None of these
Answer: (c) One-to-Many
Question.4: Which operation is used to arrange records in ascending or descending order?
a) Filter  b) Sort  c) Query  d) Report
Answer: (b) Sort
Question.5: What does referential integrity enforce in a database?
a) Accurate sorting of data  b) Relationship between fields  c) Consistency between related tables  d) Validation of data types
Answer: (c) Consistency between related tables
Question.6: Which of the following actions can you perform on a table?
a) Add records  b) Edit records  c) Delete records  d) All of the above
Answer: (d) All of the above

D. Very Short Answer Questions.
Question.1: What is referential integrity?
Answer: Referential integrity is a rule that ensures consistency and accuracy of data between related tables in a database.
Question.2: Define one-to-many relationship.
Answer: In a one-to-many relationship, one record in the parent table is related to multiple records in the child table.
Question.3: What does cascade delete do?
Answer: Cascade delete automatically removes all related child records when the parent record is deleted.
Question.4: Where can you create relationships between tables in LibreOffice Base?
Answer: Relationships can be created in the Relationships dialogue box under Tools menu.
Question.5: What happens when referential integrity is enforced?
Answer: When referential integrity is enforced, you cannot enter or delete records that would create orphan records in related tables.
Question.6: What does cascade update do?
Answer: Cascade update automatically updates related child records when the primary key in the parent table is changed.
Question.7: What is a relationship in a database?
Answer: A relationship is a link between two or more tables based on a common field.

E. Short Answer Questions.
Question.1: How can you enforce referential integrity between two tables?
Answer:
You can enforce referential integrity by creating a relationship between the primary key of one table and the foreign key of another table, and selecting the option Enforce Referential Integrity in the Relationships dialogue box.
Question.2: What are some operations you can perform on a table in LibreOffice Base?
Answer:
You can add, edit, delete, sort, and filter records in a table using datasheet view or queries.
Question.3: What is a foreign key and how does it relate to referential integrity?
Answer:
A foreign key is a field in one table that refers to the primary key in another table. It ensures data in related tables remains consistent through referential integrity.
Question.4: What happens if you try to delete a record that is referenced by a foreign key in another table with referential integrity enforced?
Answer:
The database will not allow the deletion to maintain data consistency and avoid orphaned records.
Question.5: What is the difference between a one-to-one and one-to-many relationship?
Answer:
In a one-to-one relationship, one record in a table relates to one record in another.
In a one-to-many, one record in the parent relates to multiple records in the child table.
Question.6: What is a many-to-many relationship and how can it be implemented in a database?
Answer:
A many-to-many relationship exists when multiple records in one table relate to multiple records in another.
It is implemented using a junction (linking) table containing foreign keys from both tables.
Question.7: How can you delete a relationship between two tables in LibreOffice Base?
Answer:
Open the Relationships dialogue box, select the relationship line, and press Delete or right-click and choose Delete.


F. Long Answer Questions.
Question.1: How do you add a new record to a table in LibreOffice Base?
Answer:
To add a new record:
  1. Open LibreOffice Base and select your database.
  2. Go to Tables, and double-click the desired table.
  3. Scroll to the last row marked with “*”.
  4. Enter data in each field.
  5. Press Enter to save the record.
  6. You can also add records using a Form.
  7. Adding records keeps the database updated with new information.
Question.2: Explain how sorting is done in a table and its importance in database management. Provide steps to perform sorting in LibreOffice Base.
Answer:
Sorting means arranging records in ascending or descending order.
Importance: Helps organize, search, and analyze data efficiently.
Steps:
  1. Open the table in Datasheet View.
  2. Click on the field name (column) to sort.
  3. Use the Ascending (A–Z) or Descending (Z–A) sort icons from the toolbar.
  4. Records will now appear in sorted order.
Question.3: What are relationships in a relational database? Explain the different types of relationships with examples and the process of creating relationships in LibreOffice Base.
Answer:
A relationship connects two or more tables using a common field.
Types:
One-to-One: One record relates to one record (e.g., Student–ID Card).
One-to-Many: One record in parent relates to many in child (e.g., Teacher–Students).
Many-to-Many: Many records in one table relate to many in another (e.g., Students–Courses).
Steps to Create Relationship:
  1. Open Tools → Relationships.
  2. Add the required tables.
  3. Drag the primary key to the foreign key.
  4. Check Enforce Referential Integrity.
  5. Click OK to save.
Question.4: What is referential integrity? Discuss its role in maintaining data accuracy and consistency. How is referential integrity enforced in LibreOffice Base?
Answer:
Referential Integrity ensures valid and consistent data between related tables.
Role: Prevents orphan data, maintains accuracy, and ensures valid links.
Enforcement Steps:
  1. Open Tools → Relationships.
  2. Drag Primary Key from one table to Foreign Key in another.
  3. Select Enforce Referential Integrity, Cascade Update, or Cascade Delete.
  4. Click OK — rule is now active.
Question.5: By deleting a relationship, can it be risky?
Answer:
Yes, deleting a relationship can be risky because:
  • Referential integrity between tables is lost.
  • It may cause orphan records or inconsistent data.
  • The logical connection between tables is removed.
  • Although data remains safe, removing a relationship can make data unreliable and disorganized.
  • So, deleting relationships without planning is risky.

You May Also Like:
By
at
Tags

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)