Working with Multiple Tables class 10 questions answers

Dear students, In this page, you will get questions answers of Working with Multiple Tables of class 10. These Answers have been prepared taking the reference of Class 10 IT book Domestic Data Entry Operatorpublished by NCERT.

Working with Multiple Tables class 10 questions answers

D. Answer the following questions 

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

Ans : The two advantages of relating a table in a database are –

i. A Relationship between tables help prevent data redundancy

ii. Creating relationships between tables restricts the user from entering invalid data in the
referenced fields.

2. How is redundancy or inconsistency controlled in a database ?

Ans : Redundancy or inconsistency is controlled by setting relationships between tables in a
database. It helps to check whether the record for a particular entity is repeated or there exists
different data values for a single entity in the database.

 

 

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

Ans: Referential Integrity in a database is a concept used to ensure accuracy and consistency
of data of tables in a database.

 

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

Ans : In one to one relationship one specific record of a master table has one and only one
corresponding record in the transaction table .
For example: One student can have only one ID card.
whereas in one to many relationship one specific record of the master table has more than one
corresponding records in the related transaction table.
For example : one teacher teaches multiple students or takes multiple classes.

 

5. Explain many to many relationships with an example.

Ans : In many to many relationship multiple records of a master table has multiple
corresponding records in the transaction table.
For example: multiple customers order multiple products.

Class 10 IT chapter 10 questions answers

Related Posts

1. Chapter 1 Introduction to Styles Online Quizzes / MCQ Tests
2. 40+ important MCQs of Chapter 1 Introduction to Styles
3. Chapter 2 Working with Images questions answers
4. Chapter 3 Advanced Features of writer Questions Answers
5. Chapter 4 Analyse Data Using Scenarios and Goal Seek
6. Chapter 5 Using Macros in Spreadsheet questions answers
7. Chapter 6 Linking Spreadsheet data questions answers
8. Chapter 7 Share and Review Spreadsheet questions answers
9. Chapter 8 Introduction to Database Management System questions answers
10. Chapter 9 Starting with LibreOffice Base questions answers
11. Chapter 10 Working with Multiple Tables questions answers
12. Chapter 11 Queries in Base questions answers
13. Class 10 Unit 1 Communications Skills important Questions Answers.
14. Class 10 Employability Skills Unit 1 Communication Skills Exercise Solutions
15. Class 10 IT 402 free PDF download book, syllabus and previous year question paper.