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

