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

