Page 309 - IT 402 v2.0 class 10
P. 309

2.  The director of a company uses a database to store data about job title. This is a part of the database given
                 below:

                                                         Employee Salary
                                                                    Payroll
                      Last Name    First Name        Dept                       Salary (`)      Job Title
                                                                    Number
                     Shan         James        Finance            A621         19500       Payroll Clerk
                     Gupta        Shruthi      Finance            M5           35000       Accountant
                      edi          eeta         uman  esources    M            18500       Secretary
                     Walker       Tia          Sales              W815         24000       Sales  epresentative
                     Shafia       Ahmed        Factory            H219         39000       Factory Manager
                    Mittal        Chavi        Purchasing         M            20000       Purchasing Clerk
                 i.   ow many records are there in this part of the database

                 ii.  ow many fields are there in this part of the database
                 iii.  hat is the  ob title of the employee with  ayroll Number M
                 iv.  hich department has maximum employees and what are their  ayroll Numbers
             Ans.  i.  6

                 ii. 6
                 iii. Secretary
                 iv. Finance department and their  ayroll Numbers are      and M5  .
                 .  Shweta is a database administrator. She wants to add records and manage the data in computer and make it
                 available as per the re uirement.  hich record keeping system can help Shweta to do so
              ns.    MS   atabase Management System .  xample: Ms-    SS  Open o ce  org   S .

                 .  San eev designed a database for an organisation. It contains a set of tables.  e can
                 fetch records from an individual table but he is unable to retrieve information from   L if e   S k il l s   &   V al ue s
                 another table.  hat is the drawback in his database
              ns.   elationship is not established among the two tables.


            Unsolved Exercise



                                                          Section A
                                                 (Objective Type Questions)

            A.  Multiple choice questions:
               1.  A database is an organised collection of ............................. .
                 i.  data                                          ii.  Attributes
                   iii.  ecord                                     iv. None of these
                .   hich of the following is not the advantage of database
                   i.  Sharing of  ata                             ii.   educe  ata  edundancy
                   iii. Increase  ata Inconsistency                iv.  ata Security
               3.  A ............................. is a uni ue value that identifies a row in a table.
                 i.  Primary Key                                   ii.  Field
                   ii.  Foreign key                                iv.  ueries



                                                                                  Database Management          307
   304   305   306   307   308   309   310   311   312   313   314