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

For example       ndy  New Market  ane   ccountant       5     is one of the records of the table given
           below.

                                                     Fields



                         Age      Name          Address         Designation        Phone
                          22     Andy      New Market  ane      Accountant           5
             Table        50     James      . .  oad            Clerk             55 5
                                                                                                    Records
                          27     Sandra    New Fashion Street Cashier              5 5

                          32     Sandy      . . Market          Administrator      5

           RELATIONAL DATABASE MANAGEMENT SYSTEM (RDBMS)

         elational means establishing links between two or more tables in a database.    MS is a relational   MS
        in which tables are linked to each other by fields. In addition to all the advantages of   MS  as discussed
           MS helps in the management of a database in a broader way.   relational database is defined as  a
        collective set of multiple data sets organised into tables  records and columns. It establishes a well-defined
        relationship between  database  tables. Tables can  share  information,  which  facilitates data  searchability,
        organisation and reporting.   relational database uses Structured  uery  anguage  S    application that
        provides an easy programming interface for database interaction.

                      Do you know?

                       he concept of relational database was developed by  .F.  odd at I M in     .


        For example  assume that in an organisation  there are three different tables that contain information about
         mployee  Salary and  ttendance separately.   he first table contains information of each employee like
         mployee  ode  Name   ddress   esignation  etc.  he second table contains  mployee  ode   asic Salary
         F       etc. Similarly  the third table contains information about monthly attendance of each employee
        including the Employee Code.
         o generate the  ay Slip of an employee   mployee Name and  ddress can be obtained from the first table
         asic  ay and other allowances from the second table and Monthly  ttendance from the third table.

        This information is interrelated to each other by their Employee Code. The data of such relation can be easily
        manipulated and organised by using    MS like MS- ccess  Oracle  OpenO ce  ase  etc.

           DATABASE OBJECTS

         here are different ob ects that help in executing the purpose of database package.

          Tables:   table is the basic element of a database in which data is kept in columns  called Fields  and rows
            called  ecords . It acts as a container which stores data pertaining to a single ob ect  sub ect or purpose.
          Queries: A call or a request to generate some information from the tables is called a query. It is the basic
           tool for retrieving information from the database.  uery helps in the filtration of a large volume of data
           and displays required format of information. It fetches records from one or more tables of a database
           so that they can be viewed, analysed and sorted on a common database. It also produces information
           according to specified need.



         242       Touchpad Information Technology-X
   239   240   241   242   243   244   245   246   247   248   249