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

    Report:  It  displays  information  in  a  customised  format  as  per  the  user s  re uirement.   eports  can  be
                   printed. It can present information from single as well as multiple tables.

                 .   hat are the different types of relationship that may exist between tables
              ns.   he different types of relationships that may exist between tables are:
                     One to one
                     One to many

                     Many to many
                 .   hat do you mean by  ata  edundancy
              ns.   ata  edundancy means duplication or repetition of data. It means storage of the same data in multiple
                 places. It leads to increase in the size of the database as well as database inconsistencies.
                5.   hat is  ata Sharing

              ns.   ata sharing means that the data stored in one place can be shared by multiple users. It is cost-effective as
                 well as reduces memory usage. It saves time as the table or the data is created just once and shared among
                 its users.
                 .   here can an  O    ob ect be used in   ase

              ns.  O   ob ect is used to insert images  pictures  graphics  finger prints  or iris patterns in a database. If you are
                 thinking of storing any image or graphic in any field  you can assign the data type for that particular field as
                 O  .

                 .   hat do you understand by the term   efault value  of a field in   ase
              ns.   his field property is used to enter a default value in a field.  henever the users enter a new record in the
                 table  the default value gets automatically filled as the new record and the users saves the time that would be
                 spent on data entry in that particular field.
                 .   an there be multiple primary keys in a table   ustify your answer.
              ns.  No  there can be only one primary key in a table.  rimary key is that field of a table which contains uni ue values
                 and thus its values cannot be repeated. For example  in a S    N  table  there can be various fields such as
                 roll number  name  age  marks  etc. So here  roll number can be made the primary key because other fields may
                 contain duplicate values, i.e., two students of a particular class can have same name as well as marks.
                 .  Mention any two integer data types of a table field in database.        S  Sample  aper

              ns.   IN IN   SM    N   IN       N M  I    I IN
                  . Name the relationship in which one column of the primary key table is associated with all the columns of the
                 associated table and vice versa.                                           S  Sample  aper
             Ans.  One to Many  elationship or Many to One  elationship
                  .  efine  eports of a database.                                           S  Sample  aper

             Ans.  A report helps to display the data in a summarized manner. It is used to generate the overall work outcome
                 in a clear format.  ou can create reports in the database.
                  .  ow   ntry   e uired  and   efault   alue  properties  of  a  table  field  in  a  database  are  different  from  each
                 other                                                                      S  Sample  aper
             Ans.    Entry Required: if set to yes then it will be necessary for the user to insert the value in the field which
                   means that field cannot be left blank.
                   Default Value:   default value can be set for a field if user don t provide any value while entering the values
                   in the table.



                                                                                  Database Management          305
   302   303   304   305   306   307   308   309   310   311   312