Class 10 IT Chapter 8 Introduction to Database Management System Questions Answers

Class 10 IT Chapter 8 Introduction to Database Management System Questions Answers

Dear students, Go through all the exercise as well as the additional questions answers of class 10 IT chapter 8 Introduction to Database Management System which are available in this page.

D. answer the following questions :

1. Define the terms

(a) Database

(b) Data redundancy

(c) Report

Ans: (a) Database : A Database is a collection of logically related data items stored in an organized manner.  The information stored in a database can be modified, retrieved, displayed and deleted according to the requirement of the user.

Ans: (b) Data redundancy : Data redundancy is a term which means that the same data field appears in multiple tables in a database. It means data duplicacy.

Ans: (c) Report : Report is one of the objects of a relational Database Management System (RDBMS). The output of a query can be displayed in the form of report in a database.

2. Give one point of difference between

(a) Data and Information

(b) Form and Query

(c) Network and hierarchical data model

Ans: (a) Data and Information : Data means raw facts. It may or may not have any meaning Whereas Information is the processed or organized form of data.

Ans: (b) Form and Query : A Form is one of the objects of a database which is used to enter data in a table in an easy and user friendly manner whereas a Query is one of the objects of a database which is used to retrieve the required information from the database. 

Ans: (c) Network and hierarchical data model : In  Network data model multiple records are linked to same master file. It is considered as an inverted tree whereas in hierarchical data model the data is organized into a tree like structure. The data is stored in the form of records.

3. Give any four advantages of a DBMS.

Ans: Four advantages of DBMS are –

i. Security : A database provides security. It prevents unauthorized access by assigning passwords to the users.  

ii. Organized storage : The data in a database is stored in an organized manner.

iii. Data Analysis : A database helps in analysis of data based on certain criteria.

iv. Data Sharing : A database allows data sharing. If the same data is required for multiple applications, the database can be shared with those applications.

4. Consider the table given below and answer the questions that follow-

Table : Library

Book_ID	Book_Name	Author_Name	Price	Publisher
F001	Pride and Prejudice	Jane Austen	550	ABC
S004	Amazing Astronomy	E. Shane	1050	ABC
C005	IT and Mankind	MHA Diwaan	2500	HYM

(a) Name the fields in the given table.

(b) Which field should be made the Primary key ?

(c) Is there any alternate key in the table ?

(d) How is primary key different from foreign key ? Explain with example.

Ans: (i) Book_ID, Book_Name, Author_Name, Price, Publisher

Ans: (ii) Book_ID should be made the primary key.

Ans: (iii) yes. Book_Name is an alternate key in the table.

Ans: (iv) A Primary is a field or an attribute which uniquely identifies each tuple or record in a table whereas a foreign key is a field or an attribute which refers to the value of an attribute acts as a primary key in another table.