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!
Topics Covered
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
[2] Which of the following is NOT a DBMS?
(a) MS Access
(b) LibreOffice Base
(c) MS Excel
(d) MySQL
[3] DBMS stands for __________.
(a) Data and Books Management System
(b) Database Management System
(c) Duplicate Books Management System
(d) Data Management Multi 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
[5] The details associated with an entity are called ________________.
(a) Table
(b) Attributes
(c) Records
(d) Primary key
[6] A ______________ is represented as rows in a table.
(a) field
(b) attribute
(c) record
(d) candidate 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
[8] Which of the following uniquely identifies a row in a table?
(a) Primary key
(b) Alternate key
(c) Foreign key
(d) Candidate key
[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
[10] A __________________ is a question asked from a database.
(a) query
(b) report
(c) form
(d) field
B. State whether the following statements are True or False
[1] A database cannot be organized.
[2] Data is the collection of raw facts.
[3] A table can be created without a primary key.
[4] Two tables can be related in a network data model.
[5] MS Access is an example of a database.
C. Fill in the blanks
[1] The raw facts constitutes _____________.
[2] An ________________ is a real world object about which information is to be stored in a database.
[3] The output of a query may be displayed in the form of ______________.
[4] The data values for all the fields related to a person or object is called a _____________.
[5] All the field values that are eligible to be the primary key are the __________ keys for that table
D. Answer the following questions
[1] Define the terms
(a) Database
(b) Data redundancy
(c) Report
[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.
[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.