Chapter 10 Working with Multiple Tables IT Code 402 Book Solution Class 10
Unit 3. Database Management System using LibreOffice Base
A. Multiple-choice questions.
Question 1:
Which of the following actions can be performed once the tables are created in a database?
(a) Add a field in a table
(b) Rename a table
(c) Delete a table
(d) All of the above
Answer: (d)
Question 2:
Which of the following is checked by a DBMS?
(a) Redundancy
(b) Inconsistency
(c) Both (a) and (b)
(d) Neither (a) nor (b)
Answer: (c)
Question 3:
Which of the following is required to set a relationship between the two tables?
(a) Both the tables must be in different databases
(b) Both the tables must have a common field
(c) Both the tables must have the same name
(d) Both tables must be stored in documents folder only.
Answer: (b)
Question 4:
If a record is added in a master table, which of the following is NOT true for transaction table.
(a) The record in the master table is called the master record
(b) The corresponding record in transaction table can only be entered once.
(c) The record in the transaction table is called the transaction record.
(d) It is possible to add a record in the master table
Answer: (b)
Question 5:
Which type of relationship exists between a student and the subjects studied by him/her?
(a) One-to-one
(b) One-to-many
(c) Many-to-many
(d) All of the above
Answer: (b)
Question 6:
Consider the following tables. Which type of relationship can be established between the two tables?
(a) One-to-one
(b) One-to-many
(c) Many-to-many
(d) None of the above
| Table 1: Item | Table 2: Item_Category |
|---|---|
| Item_Code | Category_Code |
| Item_Name | Cat_Name |
| Price | Item_Code |
| Qty | Cat_Disc |
| Category_Code |
Answer: (b)
Question 7:
Which of the following menus contains the Relationship option?
(a) Edit
(b) File
(c) Tools
(d) View
Answer: (c)
Question 8:
The list of tables to be added is displayed in the ________ dialog box in the Relationship Screen.
(a) Add Tables
(b) Add Databases
(c) Both (a) and (b)
(a) Neither (a) nor (b)
Answer: (a)
Question 9:
In the relationship design screen, the relationship between the two tables is done using _______ operation.
(a) Click
(b) Double Click
(c) Drag and Drop
(d) Right click
Answer: (c)
Question 10:
Which of the following is NOT an option that can be used to maintain referential integrity in a database?
(a) No Action
(b) Set NULL
(c) Set Default
(d) Set Value
Answer: (d)
B. State whether the following statements are True or False.
Question 1:
Redundancy is preferred in a database.
Answer: False
Question 2:
In a table, a record for a particular entity should not be repeated.
Answer: True
Question 3:
A single field should always have only one data value.
Answer: False
Question 4:
If a table is edited, the records already entered in it are deleted.
Answer: False
Question 5:
The record in the master table should be entered before the corresponding record is entered in the transaction table.
Answer: True
Question 6:
In one-to-many relationship, one specific record of the master table has more than one corresponding records in the related transaction table.
Answer: True
Question 7:
The Relationship option is present in the Widows menu.
Answer: False
Question 8:
In a database, the referential integrity is maintained by the user.
Answer: False
Question 9:
A relationship is always set between the tables based on a common field.
Answer: True
Question 10:
If the master record is deleted, the transaction records will always be deleted.
Answer: False
C. Fill in the blanks.
Question 1:
A table to be edited is displayed in ______ view.
Answer: Design
Question 2:
The most important prerequisite for setting a relationship between the two tables is that there must be a _______________ between them.
Answer: common field
Question 3:
In ________________relationship, one specific record of a master table has one and only one corresponding record in the transaction table.
Answer: one-to-one
Question 4:
___________________is one of the most common types of relationship between the tables in a database.
Answer: one-to-many
Question 5:
A record being entered in a _______ table must always exist in a ______ table.
Answer: transaction, master
Question 6:
The principle of _______________ helps prevent missing data by keeping deleted data from getting out of synch.
Answer: referential integrity
Question 7:
Creating _________ between tables restricts the user from entering invalid data in the referenced fields.
Answer: relationship
Question 8:
Data integrity is maintained by ________.
Answer: DBMS
Question 9:
A relationship between customers and products is an example of ______ relationship.
Answer: Many-to-many
Question 10:
The ___________ window is used to set relationships between the tables.
Answer: Relationship Design
D. Answer the given questions.
Question 1:
Give any two advantages of relating a table in a database.
Answer: There are various advantages of relating tables in a database. A few of them are given below.
- A relationship can help prevent data redundancy and data inconsitency.
- It helps prevent missing data by keeping deleted data from getting out of synch. This is called referential integrity.
- Creating relationships between tables restricts the user from entering invalid data in the referenced fields.
- Any updation in the master table is automatically reflected in the transaction tables.
Question 2:
How is redundancy or inconsistency controlled in a database? Explain with an example.
Answer: Once the relationship between the two tables has been set, the integrity of data will be managed by the DBMS. LibreOffice Base will allow only that corresponding record to be entered in the transaction table which already exists in the master table.
- Due to the primary key in the database, a user is not able to enter the duplicate records.
- Due to referential integrity, the database does not allow to enter different value for a particular column in different tables.
Question 3:
Define referential integrity. Who maintains referential integrity in a database?
Answer: Referential integrity is a set of rules that ensure the consistency of data between related tables in a database. It’s a vital concept in relational database management.
Question 4:
Differentiate between one-to-one relationship and one-to-many relationships. Give suitable examples to explain your answer.
Answer:
| One-to-One relationship | One-to-Many relationships |
|---|---|
| In this type of relationship, one specific record of a master table has one and only one corresponding record in the transaction table. For example, the record for Admission_No in the master table (Student_Detail) will have only one corresponding record of the same value as Admission No in the transaction table of Student_Result. This is because no two students will be given the same admission number. | * This is one of the most common types of relationship between the tables in a database. * As the name says, in this type of relationship, one specific record of the master table has more than one corresponding record in the related transaction table. For example, one teacher can teach multiple students or multiple classes, or one person can sell multiple products. So we can say that there is a one-to-many relationship between a teacher and class or teacher and student or seller and products |
Question 5:
Explain many-to-many relationships with an example.
Answer: In this type of relationship, there will be multiple records in the master table that correspond to multiple records in the transaction table as well.
Generally, this type of relationship is set when certain records have to be saved more than once in both the related tables.
For example,
- A teacher in a school may hold multiple responsibilities such as class teacher, an activity incharge or examination in charge. For each responsibility, the teacher might be attached with multiple students.
Published on : March 2, 2025 | Last Updated on : March 5, 2025 | By Anjeev Kr Singh
