In this article lets discuss NCERT solutions Information Technology Chapter 8 Introduction to Database Management System. In Unit 3 Database Management System there are 5 chapters.
It starts with Chapter 1 NCERT solutions Information Technology Chapter 8 Introduction to Database Management System. Let’s discuss now!
NCERT solutions Information Technology Chapter 8 Introduction to Database Management System
NCERT exercises starts with MCQs, followed by Fill in the blanks, True-False and short/long answer questions. Lets begin!
A. Multiple choice questions
[1] Which of the following can be considered as an example of a database?
(a) Dictionary
(b) Telephone directory
(c) Marks Register
(d) Newspaper
Ans. (b) Telephone Directory
Dictionary, Marks Register and Newspaper are not a database.
[2] Which of the following is NOT a DBMS?
(a) MS Access
(b) Open Office Base
(c) MS Excel
(d) MySQL
Ans. (c) MS Excel
MS Access, Open Office Base and MySQL are DBMS softwares.
[3] DBMS stands for __________.
(a) Data and Books Management System
(b) Database Management System
(c) Duplicate Books Management System
(d) Data Management Multi System
Ans. (b) Database Management System
[4] Which of the following data models sets a relation between the two or more tables?
(a) Relational Data Model
(b) Network Data Model
(c) Hierarchical Data Model
(d) Connection Data Model
Ans. (a) Relational Data Model
(b) Network Data Model – has logical association between the segments
(c) Hierarchical Data Model – data are organized like Tree-Structure
(d) Connection Data Model – used to connect related information between entities
[5] The details associated with an entity are called ________________.
(a) Table
(b) Attributes
(c) Records
(d) Primary key
Ans. (b) Attributes
(a) Table – Intersection of row and column
(c) Records – Set of fields represents one entity
(d) Primary Key – identifies rows uniquely
[6] A ______________ is represented as rows in a table.
(a) field
(b) attribute
(c) record
(d) candidate key
Ans. (c) Record
(a) field and (b) attribute- is represented as column in table
(d) Candidate key – The field which can be a candidate for primary key
[7] In which of the following forms can a data value be represented?
(a) Numeric
(b) Character
(c) Alphanumeric
(d) All of the above
Ans. (d) All of the above
[8] Which of the following uniquely identifies a row in a table?
(a) Primary key
(b) Alternate key
(c) Foreign key
(d) Candidate key
Ans. (d) All of the above
[9] A ___________is a feature of a database using which we can enter data in a table in an easy and user friendly manner.
(a) query
(b) report
(c) form
(d) field
Ans. (c) Form
(a) Query – To fetch records from table
(b) report – Represent data from tables in summarized manner
(d) field – Represents a column of a table
[10] A __________________ is a question asked from a database.
(a) query
(b) report
(c) form
(d) field
Ans. (a) Query
B. State whether the following statements are True or False
[1] A database cannot be organized.
Ans.: False
A database can be organized in efficient manner.
[2] Data is the collection of raw facts.
Ans.: True
[3] A table can be created without a primary key.
Ans.: True
[4] Two tables can be related in a network data model.
Ans.: False
Two tables can be related in a relational data model.
[5] MS Access is an example of a database.
Ans.: False
MS Access is an example of DBMS.
C. Fill in the blanks
[1] The raw facts constitutes _____________.
Ans.: data
[2] An ________________ is a real world object about which information is to be stored in a database.
Ans.: entity
[3] The output of a query may be displayed in the form of ______________.
Ans.: report
[4] The data values for all the fields related to a person or object is called a _____________.
Ans.: report
[5] All the field values that are eligible to be the primary key are the __________ keys for that table
Ans.: candidate
D. Answer the following questions
[1] Define the terms
(a) Database
(b) Data redundancy
(c) Report
Ans.:
1. Database: A database is a collection of logically related data items stored in an organised manner. The information being stored in a database can be added, modified, deleted or displayed according to the requirements of the user.
2. Data Redundancy: The same data field repeated in different table is known as data redundancy.
3. Report: The output of query stored formal and proper layout is called report. A report represents the query output in printed form or summarized manner.
[2] Give one point of difference between
(a) Data and Information,
(b) Form and Query
(c) Network and hierarchical data model
Ans.:
| Data | Information |
| Raw facts are known as data | Process data or meaningful data is known as information |
| Only roll numbers, marks, names are data | Report cards along with appropriate data are information |
| 1, ‘Madhav’, 98.5 | Rollno – 1, Name – ‘Madhav’, Percentage – 98.5 |
| Form | Query |
| A form is a way to supply data in an easy and user friendly manner. | Query is used to retrieve information from database table |
| A form is used to display and input | A query is a question asked from database |
| Form creates an interface for user | Query returns a particular dataset |
| Network Model | Hierarchical Model |
| Multiple records are linked to same master file | Data is organized into tree like structure |
| It is also considered as invert tree | Data is stored in form of records |
| Master is present at the bottom of the tree and branches contains information linked to master | It forms a hierarchy and all the records are linked each other at various levels |
[3] Give any four advantages of a DBMS.
Ans.:
Organized Storage – The data in the database is stored in an organised manner, so that retrieval of the required data is fast and accurate.
Data Analysis – A database helps in analysis of data based on certain criteria. It is easy to find out maximum or minimum value, average or mean using a database.
Data Sharing – If the same data set is required for different applications then the database can be shared with other applications. Hence using a database means making once and using it repeatedly for multiple applications.
Minimal Data Redundancy – In the event of requiring the same data field in several tables the data field might get repeated in number of tables. This is called as data redundancy. This can be reduced by using DBMS tools.
Data Consistency – By minimizing data redundancy, chances of inconsistent data being stored is reduced. For example, it should not happen that the name of the student is changed in one table and not in another. Such inconsistency is reduced by using a DBMS.
[3] 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 Diwan | 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.:
(a) Field are : Book_ID, Book_Name, Author_Name, Price, Publisher
(b) Primary key: Book_ID as it contains unique records
(c) As far as this table data Book_Name, and Author can be an alternate key
(d) Primary key identifies unique records from relation. The value entered in the filed of primary cannot be repeated. A foreign key is a value taken from primary key of another table. It can be repeated in the column.
That’s all from NCERT solutions Information Technology Chapter 8 Introduction to Database Management System. I hope it is helpful for you. If you have any specific concerns, feel free to share your valuable feedback for this article.
Related
