Page 381 - TP_IT_V1.0_C10_flipbpookl
P. 381

10.  The              data model has multiple records linked to same master file.
                       a. Network                                        b. Hierarchical
                       c. Relational                                     d. Database
                 B.  Fill in the blanks.
                    1.  To create a form you need to select       option available under Database section.
                    2.  A foreign key is a reference of the      key in another table.
                    3.  A              is helps to collect specific information from the pool of data in the database.   [CBSE Handbook]
                    4.  The candidate key, which is not used as the primary key is called    key.

                    5.  The data values for all the fields related to a person or object is called a   .
                    6.  All the field values that are eligible to be the primary key are the    keys for that table.
                    7.  A              refers to the type of data that will be stored in that particular field.
                    8.  The data can be entered in a table only in     view.
                    9.  The              data type is used to store digitised images.
                   10.               means rearrangement of the data either in the ascending order or in the descending order.

                 C.  State whether these statements are true or false.
                    1.  LibreOffice base is an open source RDBMS.
                    2.  In a table, a record for a particular entity should not be repeated.
                    3.  In one-to-many relationship, one specific record of the master table has more than one corresponding
                       records in the related transaction table.
                    4.  The records once entered can be edited anytime in a table.
                    5.  The properties of a field change according to the data type selected.
                    6.  It helps prevent missing data by keeping deleted data from getting out of sync.
                    7.  Connect to an existing database helps you open an existing file.
                    8.  A table is a collection of logically related records.
                    9.  In Hierarchical Data Model, the data is organised into a file like structure.
                   10.  A form is a feature of a database using which we can enter data in a table in an easy and user friendly manner.
                 D.  Match the following:
                    1.  Integer                               a.  True/False
                    2.  AutoValue                             b. No data entry
                    3.  Boolean                               c.  RDBMS
                    4.  Constraint                            d. Data Type
                    5.  MY SQL                                e. Primary Key

                                                  SECTION B (Subjective Type Questions)
                 A.  Short answer type questions.
                    1.  How Entry Required and Default Value properties of a table field in a database are different from
                       each other?                                                                  [CBSE Sample Paper 2022]
                    2.  Explain the term Data Redundancy.
                    3.  What is Referential Integrity? Explain its two (any) purposes.              [CBSE Sample Paper 2022]
                    4.  What are Reports in a database?
                    5.  What is a data model?
                    6.  Explain Memo data type in database.
                    7.  What is the purpose of using Queries?
                    8.  How many ways are there to create a table in a database?


                                                                        Database Management System using LibreOffice Base  379
   376   377   378   379   380   381   382   383   384   385   386