Page 31 - 2501_KVS_C-8

Note: As we add more records in our Table “Contacts” our query will show those records
which fulfil the condition of “Delhi” city automatically. This is a very good feature in our
DBMS Base of LibreOffice.

Now, it’s your time to practice the above steps to create a query for better understanding.

Let us revise what we have learnt:
Ø Data represents facts and figures, while a database stores interrelated data
systematically.

Ø A Database Management System (DBMS) helps manage data by enabling users to
create, edit, and search within databases.

Ø Tables organize data in rows and columns, with each intersection forming a cell to
store information.
Ø A primary key uniquely identifies records, and data types define the kind of data in
each column.

Ø The Query Wizard in LibreOffice helps users create queries to retrieve specific data,
with automatic updates as new records are added.

Exercise

Something to know

A. Answer the following questions:

1. What do you mean by Wizard?
________________________________________________________
2. What is the importance of a Wizard?
________________________________________________________

3. Can we assign a primary key to a field during the creation of a table using wizard?
________________________________________________________

4. What do you mean by a query?
________________________________________________________
5. What is the use of query in a database?

________________________________________________________

B. Fill in the blanks.
1. A ____________ is a step by step help of the procedure of creation of a database
object.

2. A ____________ is a request to fetch some information from a database.

Introduction to Database Concepts 29