Chapter 10 Working with Multiple Tables Question Answer Class 10 IT LibreOffice Base CBSE Python

Chapter 10 Working with Multiple Tables Question Answer Class 10 IT

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

Answer:(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)

Answer:(c) Both (a) and (b)

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) 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

Answer:(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

Answer:(b) One-to-many

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) One-to-many

7. Which of the following menus contains the Relationship option?
(a) Edit
(b) File
(c) Tools
(d) View

Answer:(c) Tools

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) 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

Answer:(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

Answer:(d) Set Value

B. State whether the following statements are True or False

1. Redundancy is preferred in a database. [False]

2. In a table, a record for a particular entity should not be repeated. [True]

3. A single field should always have only one data value. [False]

4. If a table is edited, the records already entered in it are deleted. [False]

5. The record in master table should be entered before the corresponding record is entered in the transaction table. [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. [True]

7. The Relationship option is present in the Widows menu. [False]

8. In a database, the referential integrity is maintained by the user. [False]

9. A relationship is always set between the tables based on a common field. [True]

10. If the master record is deleted, the transaction records will always be deleted. [False]

C. Fill in the blanks

1. A table to be edited is displayed in ___________ view.

Design

2. The most important prerequisite for setting a relationship between the two tables is that there must be a ____________ between them.

common field

3. In ________________relationship, one specific record of a master table has one and only one corresponding record in the transaction table.

one-to-one

4. _________is one of the most common types of relationship between the tables in a database.

one-to-many

5. A record being entered in a _________ table must always exist in a ________ table.

transaction, master

6. The principle of _______________helps prevent missing data by keeping deleted data from getting out of synch.

referential integrity

7. Creating ____________ between tables restricts the user from entering invalid data in the referenced fields.

relationship

8. Data integrity is maintained by ___________.

DBMS

9. A relationship between customers and products is an example of ______________ relationship.

Many-to-many

10. The _______window is used to set relationships between the tables.

D. Answer the following questions

1. Give any two advantages of relating a table in a database.

Data Integrity: By establishing relationships between tables, you can ensure that data is consistent and accurate. For example, if a customer record is deleted, all related orders for that customer can also be automatically removed.
Efficient Data Storage: Related data can be stored in separate tables, reducing redundancy and improving storage efficiency. This also makes it easier to update and maintain data.

2. How is redundancy or inconsistency controlled in a database? Explain with an example.

Redundancy and inconsistency are controlled in a database through normalization. This process involves breaking down a large table into smaller, more focused tables and establishing relationships between them.

Example:

Consider a database for a library. Without normalization, a table might store information about books, authors, and borrowers in a single table:

Book_ID	Book_Title	Author_Name	Borrower_Name	Borrow_Date
1	The Lord of the Rings	J.R.R. Tolkien	John Doe	2023-11-20
2	Harry Potter and the Sorcerer’s Stone	J.K. Rowling	Jane Smith	2023-12-01

This leads to redundancy (e.g., author names repeated for multiple books) and potential inconsistencies (e.g., if an author’s name is misspelled in one record).

A normalized database would have separate tables for books, authors, and borrowers, with relationships between them:

Books table: Book_ID, Book_Title, Author_ID
Authors table: Author_ID, Author_Name
Borrowers table: Borrower_ID, Borrower_Name
Borrowings table: Borrow_ID, Book_ID, Borrower_ID, Borrow_Date

3. Define referential integrity. Who maintains referential integrity in a database?

Referential integrity ensures that relationships between tables are maintained correctly. It prevents actions that would violate these relationships, such as deleting a record that is referenced by other records.

The database management system (DBMS) is responsible for maintaining referential integrity. It enforces rules to ensure that data is consistent and accurate.

4. Differentiate between one to one relationship and one to many relationship. Give suitable examples to explain your answer.

One-to-One Relationship:

A single record in one table is associated with exactly one record in another table.
Example: A person can have only one passport.

One-to-Many Relationship:

A single record in one table is associated with multiple records in another table.
Example: An author can write many books.

5. Explain many to many relationship with an example.

A many-to-many relationship occurs when multiple records in one table can be associated with multiple records in another table.

Example:

A student can enroll in many courses, and a course can have many students. To represent this relationship in a database, we introduce a junction table:

Students table: Student_ID, Student_Name
Courses table: Course_ID, Course_Name
Enrollments table: Enrollment_ID, Student_ID, Course_ID

The Enrollments table acts as a bridge between the Students and Courses tables, allowing us to store information about which students are enrolled in which courses.

You May also Check:

Class 10 IT 402 Chapter wise Important Questions

Chapter 11: Queries in Base

Chapter 12: Forms and Reports

Unit 4: Maintain Healthy, Safe and Secure Working Environment

Chapter 13: Health, Safety and Security at Workplace

Chapter 14: Workplace Quality Measures

Chapter 15: Prevent Accidents and Emergencies

Chapter 10 Working with Multiple Tables Question Answer Class 10 IT LibreOffice Base