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
   212   213   214   215   216   217   218   219   220   221   222