Let’s begin NCERT Solutions Chapter 10 Working with multiple tables. In this article you will get questions and answers of Class 10 textbook exercises for Chapter 10 Working with multiple tables. Here we begin!
Topics Covered
NCERT Solutions Chapter 10 Working with multiple tables
Lets starts with Part A Multiple choice questions as usual.
A. Multiple choice questions
[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
Ans.: (d) All of the above
[2] Which of the following is checked by a DBMS?
(a) Redundancy
(b) Inconsistency
(c) Both (a) and (b)
(d) Neither (a) nor (b)
Ans.: (c) Both (a) and (b)
Redundancy and Inconsistency are two main advantages of DBMS.
[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.
Ans.: (b) Both the tables must have a common field
[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
Ans.: (b) The corresponding record in transaction table can only be entered once.
[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
Ans.: (b) One-to-many
A rol number can be used to established a relationship.
[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
| Item_Code |
| Item_Name |
| Price |
| Qty |
| Category_Code |
Table 2: Item_Category
| Category_Code |
| Cat_Name |
| Item_Code |
| Cat_Disc |
Ans.: (b) One-to-many
More than one can be used to establish a relationship. Category code and Item code are the fields.
[7] Which of the following menus contains the Relationship option?
(a) Edit
(b) File
(c) Tools
(d) View
Ans.: (c) Tools
Edit, File and View options does not contain the relationship option.
[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)
Ans.: (a) Add Tables
[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
Ans.: (c) Drag and Drop
[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
Ans.: (d) Set Value
Set default and set null can be used as constraints.
B. State whether the following statements are True or False
[1] Redundancy is preferred in a database.
Ans.:False
No redundancy can be avoided in database.
[2] In a table, a record for a particular entity should not be repeated.
Ans.: True
[3] A single field should always have only one data value.
Ans.: False
A single filed should always have more than one values.
[4] If a table is edited, the records already entered in it are deleted.
Ans.: False
No when table is edited, the records remains as it was.
[5] The record in master table should be entered before the corresponding record is entered in the transaction table.
Ans.: True
[6] In one-to-many relationship, one specific record of the master table has more than one corresponding records in the related transaction table.
Ans.: True
[7] The Relationship option is present in the Widows menu.
Ans.: False
The Relationship option is present in the Tools menu.
[8] In a database, the referential integrity is maintained by the user.
Ans.: False
The Relationship option is present in the Tools menu.
[19] A relationship is always set between the tables based on a common field.
Ans.: True
[20] If the master record is deleted, the transaction records will always be deleted.
Ans.: False
No if master record is deleted then it is not necessary that transaction records also deleted.
C. Fill in the blanks
[1]A table to be edited is displayed in _____________ view.
Ans.: Design
[2] The most important prerequisite for setting a relationship between the two tables is that there must be a ________________between them.
Ans.: common field
[3] In ________________relationship, one specific record of a master table has one and only one corresponding record in the transaction table.
Ans.: one-to-one
[4] ___________________is one of the most common types of relationship between the tables in a database.
Ans.: one-to-many
[5] A record being entered in a ________________ table must always exist in a table.
Ans.: transaction or master or parent or base
[6] The principle of _______________helps prevent missing data by keeping deleted data from getting out of synch.
Ans.: referential integrity
[7] Creating ________________ between tables restricts the user from entering invalid data in the referenced fields.
Ans.: relationship
[8] Data integrity is maintained by ______________.
Ans.: DBMS
[9] A relationship between customers and products is an example of ______ relationship.
Ans.: many to many
[10] The ______ window is used to set relationships between the tables.
Ans.: Relation Design
D. Answer the following questions
[1] Give any two advantages of relating a table in a database.
Ans.:
1. Data Redundancy
2. Data Inconsistency
[2] How is redundancy or inconsistency controlled in a database? Explain with an example.
Ans.:
Redundancy: Data redundancy refers to reducing the repeated data field in several tables. It can be controlled by using primary key or unique key constraints.
Inconsistency: When data redundancy is applied into table it should not happen that the same data changed in one table should not in another.
[3] Define referential integrity. Who maintains referential integrity in a database?
Ans.:
Referential Integrity refers to establish a relationship between two tables which can help in data redundancy and prevent missing data by keeping deleted data from getting out of synch. The referential integrity is maintained by Primary key and Foreign Key.
[4] Differentiate between one to one relationship and one to many relationship. Give suitable examples to explain your answer.
Answer:
| One to one | One to many |
| In one to one relationship, one record of master table has one and only one corresponding record in the related transaction table. | In One-to-Many type of relationship, one specific record of the master table has more than one corresponding records in the related transaction table |
| For example – A table dept has three fields Deptno, Dname and loc is with with emp table h having fields like Empno, ename, job, sal, comm, hiredate, deptno. | For example – A table salesman has fields like salesman_id, salesman_name, city, commission is related with table customer having customer_id, cname, bill_amt and salesman_id as well as related with commission table having fields as com_id, commission_amt, salesman_id. |
[5] Explain many to many relationship with an example.
Ans.:
Many to many relationship the multiple records are related with a master table that correspond to multiple records in the transaction table.
For example – A company store has tables such as Supplier, Product and Customer where all tables are related with product id and different ids of supplier as well as customer.
For more details read this: Click here.