Page 216 - IT_V1.0_Class10
P. 216

Recap Zone


                   A database is defined as an organised collection of data that can be visualised as a container of
                    information. It allows for the storage, modification, and retrieval of data efficiently.
                   A database provides an efficient system for managing data and records. It has many advantages like
                    Organised Storage, Data Analysis, Data Sharing, Minimal Data Redundancy etc.

                   A database management system is a software package that controls the creation, maintenance and
                    use of a database. It allows organisations to develop databases for various applications according to
                    their needs.
                   Database servers are dedicated computers designed to store and manage databases.
                   A  data  model  is  a  conceptual  representation  of  data  structures  and  relationships  that  helps  in
                    organising and understanding the data. Various types of Data-models that are used are: Hierarchical
                    Data Model, Network Data Model, Relational Data Model.

                   RDBMS is a relational DBMS in which tables are linked to each other based on the common field.
                    Some of the important terms of RDBMS are: Entity, Keys, Data Value, Relationships, Constraints,
                    Degree, Cardinality.
                   In the LibreOffice Base, data between tables can be related on the basis of a common field called key
                    field. Examples of keys are Primary Key, Candidate Key, Alternate Key, Composite Key and Foreign
                    Key.
                   There are different objects that help in executing the purpose of database package namely Tables,
                    Queries, Forms, Reports.




                                                          Exercise



                                                 Section A (Objective Type Questions)
              A.  Multiple choice questions.

                  1.  Database servers are referred to as ..............................       [CBSE Sample Paper, 2022]
                    i.  Front-ends         ii.  Back-ends            iii.  Clients                iv.  Model
                  2.  ............................. ensures that the data entered in a particular field is accurate and up-do-date across all related records.
                     i.   Referential Integrity                      ii.   Field level data validation
                     iii.  Data Consistency                          iv.  Data Insurance
                  3.  A database is an organised collection of ..............................
                    i.  Data               ii.  Attributes           iii.  Record                 iv.  Keys

                  4.  In a company, employees use different software to manage and analyse data, but one program is not designed
                    for database management. Which of the following is not a database program?
                    i.  MySQL              ii.  Oracle               iii.  Writer                 iv.  LibreOffice Base

                  5.  In RDBMS, data is organised in the form of ..............................
                    i.  Table              ii.  Record               iii.  Field                  iv.  Entity
                  6.  What is the term used to describe the number of columns in a table?
                    i.  Cardinality        ii.  Degree               iii.  Entity                 iv.  Key




                214     Information Technology Play (Ver 1.0)-X
   211   212   213   214   215   216   217   218   219   220   221