Page 19 - ModularV1.1 _c8_flipbook
P. 19

The commonly used terms of the relational database are:
                    Table: It is  a group  of related  data  organised into columns  and rows in a database.  The

                    columns contain a number of headings such as Reg No., Name, Father's Name, Date of Birth,
                    Class, etc. These are known as Fields. A set of values for the fields is called a Record. Record
                    is one row of the table.
                    Primary Key: It is a unique field by which the records are uniquely identified in a table. A table
                    can have only one primary key. For example, in a student’s record, the ‘Reg No.’ can be called
                    a primary key.
                    Query: A query is the most powerful object of database. It helps you to retrieve information

                    from a table based on some criteria or condition. You can ask, find and retrieve data from the
                    database just by creating and running the query.
                    Report: The final result of the manipulated data that comes from tables or queries in DBMS is
                    known as a report. A report is a database object that is specially designed to display or print
                    the data in the formatted way.
                    Form: A form is a database object used to create a user interface to enter or update a record in a

                    table that is connected to it. It also allows us to view all the records in the table one by one.
                 Clickipedia



                   If more than one field is combined to form a primary key, then it is called a composite key.

                    Recap



                         A collection of programs required to store and retrieve data from a database is called
                         Database Management System (DBMS).
                         A database can be defined as a collection of data in an organised manner that can
                         be easily accessed, managed and updated.
                         A table is a group of related data organised into columns and rows in a database.


                                                        Exercise



                 A.  Tick ( ) the correct option.
                         ü
                    1.  Which of the following is a collection of characters and symbols that has no meaning?
                      a. Data                              b. Information                c. Field

                    2.  Which one of these helps to store and retrieve a large amount of data efficiently?
                      a. Record                            b. Database                   c. None of these
                    3.  Which of the following is a group of related data organised into columns and rows in a database?
                      a. Table                             b. Row                        c. Column

                    4.   A ............................ is a database object to that is specially designed to display or print the data in
                      the formatted way.
                      a. Form                              b. Table                      c. Report


                                                                                    Database Management System    17
   14   15   16   17   18   19   20   21   22   23   24