Page 217 - IT_V1.0_Class10
P. 217
B. State whether the following statements are true or false:
1. A database can be visualised as a collection of unrelated data. ............................
2. A composite key consists of a combination of two or more fields to uniquely identify records. ............................
3. Information is a meaningless form obtained after processing data. ............................
4. An Entity in a database is a real-world object whose information is to be stored about. ............................
5. The data model in DBMS defines how data is organised and structured within the database. ............................
6. A foreign key in a table refers to a column in the same table. ............................
7. A database management system (DBMS) helps in creating, maintaining, and using a database. ............................
8. In a database, a primary key is used to uniquely identify each record and cannot be left blank. ............................
9. Keys in a database are not essential for maintaining data integrity. ............................
10. Database servers can only run the DBMS and its related software. ............................
21 st
C. Assertion and reasoning questions. Century #Critical Thinking
Skills
The following questions consist of two statements – Assertion (A) and Reason (R). Answer these questions
by selecting the appropriate option given below:
i. Both A and R are true and R is the correct explanation of A.
ii. Both A and R are true but R is not the correct explanation of A.
iii. A is true but R is false.
iv. A is false but R is true.
1. Assertion (A): Keys are essential for data integrity in a relational database management system (RDBMS).
Reason (R): Keys uniquely identify records in a table and establish relationships between tables.
2. Assertion (A): Information can be defined as a set of organised data.
Reason (R): Knowledge is based on learning through information.
Section B (Subjective Type Questions)
A. Answer the following questions:
1. What is a database?
2. What do you mean by RDBMS?
3. Define the following terms:
i. Table ii. Fields iii. Records
4. What do you understand by form in LibreOffice Base?
5. Explain different types of data models.
21 st
Century #Critical Thinking
B. Application-based question. Skills
Your friend owns a chemist shop, he needs to keep records of the medicines with their id’s, date of purchase, expiry
date, price, etc. in a database program. But he does not have any knowledge about the database. Explain to him the
following to get a better understanding of the DBMS concepts. [CBSE Sample Paper 2023]
i. What is DBMS? Explain in brief.
ii. Name any two database programs, which can be used to create a table and store the data as per the requirement.
iii. Which field can be set as a Primary Key?
iv. Is it possible to make more than one field as a primary key in your table? (Yes/No). Justify your answer.
Introduction to Database Management System 215

