Page 20 - ModularV1.1 _c8_flipbook
P. 20

B.  Write ‘T’ for true and ‘F’ for false.

                     1.  MS Access is an example of the flat-file database.                              ............................
                     2.  A set of values for the fields is called a Record.                              ............................

                     3.  DBMS stands for Database Management System.                                     ............................

                     4.   A database minimises the duplication of data by integrating and sharing
                        the data files.                                                                  ............................
                  C.  Fill in the blanks using the words given below.


                                                         fields, query, relational, primary


                     1.   A ............................ helps you to retrieve information from a table based on some criteria or
                        condition.

                     2.  The columns in a table represent ............................ .

                     3.  The ............................ key is defined in order to show the uniqueness of data.

                     4.  A ............................ database is a type of database that stores data in several tables.
                  D.  Short answer type questions.
                     1.  What is a database?
                       ......................................................................................................................................................................................................
                     2.  What do you mean by flat file database?

                       ......................................................................................................................................................................................................
                     3.  What is the use of a form in a database?
                       ......................................................................................................................................................................................................

                  E.  Long answer type questions.
                     1.  What is a relational database? Give an example of a relational database management system.
                     2.  Write any three advantages of a database system.


                                                    In the lab                                         Subject Enrichment


                     Look at the following table and answer the questions:

                           Reg No.        Name          Date of Submission      Marks Obtained         Grade
                          T/121/15    Anshu Verma             11/07/15                 18               A
                          T/137/15    Anjali Kumari           12/07/15                 20               A+
                          T/145/15    Deepak Kohli            14/07/15                 17               B+
                         •  How many fields are there in the table?
                         •  How many records are there in the table?







                  Discuss about different relational database management systems such as MS SQL Server and Oracle.

                  18      Modular (Ver. 1.1)-VIII
   15   16   17   18   19   20   21   22   23   24   25