Data base managment system 1254658543135

book

1. T
Session1
Session 2
Stegs
Session 3
ie'd stiect cr
Introducing Databases
esch cond
Session 4
Chck here for
table wizard
Creating
Database
and
Tables
Select the sor fing otder
tton
unctered
Creating/Editing
Tables in
Design
View
Performing
Operations on
Tables
Selec sor-fe
here
Window below
Session 5
535eril
System
Session 6
Su0a'ertvame
Database
Management
Address
Queries in Base
Session 7
Session 8
Structured Query Langauge
Form Wizard
Stess
SadaA Eritt
Report Wizard
Arranne the
ontrole on yOr forn
Pheretnber
Choose an
arrangement

2. 1
11 Introduction
e SS i O n
Introducing Databases
earhing Objectwes
A database refers to a collection of related data and a database system is basically a computer
based record keeping system. A database contains information about one particular enterprise
It maintains any information that may be necessary to the decision-making processes
involved in the management of that organization.
L2 Dotabase Functioning
A Database Functioning
AA Designing a Database
The intention of a database is that the same collection of data should serve as many
appications as possible. Hence, a database is often conceived of as the repository o
imformation needed for running certain functions in a corporation or organization. Sucn d
database would permit not only the retrieval of data but also the continuous modification or
data needed for control of operations.
A How Database Works
A Advantages of Databases
Ihus session is going to discuss the basics of databases and their functioning. This discussio
will lay foundation of BASE -the dbMS of OpenOffice.org (O00) for you.
stored in two separate files
In a typical file-processing system, permanent records are
stored in various files. A number of different application
programs are written to extract records from and add records
to the appropriate files. But this schemné has a number of
major limitations and disadvantages, such as data redundancy
(duplhcation of data), data inconsistency, unsharable data,
unstandardized data, insecure data, incorrect data etc. A database
management system is answer to all these problems as it
provides a centralized control of the data.
128
DEF.
to
Database
the
refers
collection of
interrelated data
and Database Managemen
System
(DBMS) is a
compute
that
program
database
etfectively
efficiently.
Imanages d
For instane, in a nesidential school, if two files are being maintained -one for school
and
another
for hostel-it might create problems. As for the students who live in hostel, their
records
ar
and
school file and hostel file. Now consider a situation,
in
which a

3. A
R
B
138
Student Table
Figure 1.7 shows a
relationship
between two tables.
4.
7
9.
Rollno
2
Name
Rohit
Kush
Mehul
Neha
Surabhi
heck Point
(a)
Address
Relationshio on the basis
of
commo field rollno
M.Ngr
(a) Table
A. Garg
S.Ext.
P. Ganj
B. Ngr
See. for each roll no. in
student table, there exists a
record in
marks
tabie also
(a) Data Redundancy
(C) Data Inconsistency
Duplication of data is known as
Data Redundancy
D.0.B.
(c) Data Inconsistency
12/10/92
18/02/93
Computer based record keeping system is knoWn as
(a) CRKS -Computerized ReCord Keeping System
(b) DBMS -Data Base Management System
(c) DMS -Data Managemnent System
(a) All of these
14/05/92
17/12/92
12/12/93
(b) Query
Marks Table
5. Multiple copies of same data that mismatch, are knoWn as
Rollno English
(a) Prinary key (b) Candidate key
1
2
3
5
Fiqure 1.7 A Relationship between two tables.
A formal, presentable printed doCument that lists
(a) Table
30
(b) Data Repentance
(d) None of these
(c) Report
5. A field that uniquely identifies records in the table is known as
35
30
(b) Data Repentance
(c) Unique key
26
(d) None of these
(c) Table
40
INFORMATION TECHNOIo
data in formatte
(b) Query (c) Report
Named collection of fields which represent a conplete
(a) Field (b) Record
Maths
40
A statement that gives you filtered data according to
your conditions and
(a) Table
(b) Query (c) Report
An interface in user-defined layout that lets users view,
(u) Table
(b) Query (c) Report
50
30
36
46
unit of information
(d) Form A storage container storing data pertaining to simple object, subject or
PurpOse is
known as
Science
40
42
35
28
40
(d) Special key
IIT
32
43
is called
(d)
None
of
these
29
32
38
(d) Form in tables, knOwn
enter or
change data
(d) Form
Way is
known as
(d) Form
Specitications, is called

4. INTRODUCING DATABASES
in
a
table is also
knoWn as :
(a) A reCOrd
(a) Table I1
Whih
of the
following
hoids a single piece of data ?
2
What
is the
correct
definition of primary key ?
i)
The
first
field in a
table
:
What is
the
coorrect definition of foreign key ?
(0) A
tield
that
contains
unique data in each record.
)
The
tield
which we will usse to search with.
()
A
field
which
contains
numbers only.
The
common field of two
tables.
i) The field same as
primary key. (b)
A
field
that
contains unique data in each record.
(a) Alternate key
(b) A field
(c) Foreign key
(b) Record
: When a
primary key
Contains more than one field, it is known
as
(a) Foreign key
lä) A
field that
stores v values coming from primary key of another table.
() Datatype
: Which is not true for a database file?
: What is used to uniquely identify each record in a table ?
(a) Each record may contain several fields
(b) Fields are organized in columns
i) Data types have to be declared in advance
la) Each field may contain several records
la) Purpose of database
(c) Field needed
(a) Lists
(o) Tables
(c) A data typ
(c) Field
While
designing
a database, we should keep in mind
a) It
can
print
reports.
What are the main building blocks of a database ?
retrieves data related to its
queries.
(a) Field properties
(a) it
provides a
relationship between integers. (bj it
consists of
Separate tables of related data.
Data
should be
organized into tables based on :
0Character lengths
a)
All of
these
(b) Candidate key
(b}
Subjects associated with the real-data
(d) Comnposite key
Which of f the
following
describes a relational database ?
(b) Field
(d) Primary key
(b) Tables required
(d) All of them
(b) Queries
(d) Reports
(d) A tupie
(d) Form
UNIT:III : DATABASE MANAGEMENT SYSTEM
139

5. R
T
B
140
21. Which of the following best describes a query ?
(a) A query enables people to enter or view data in your database easilv
() A query summarizes and prints data.
(c) A query filters data from a database based on a criteria.
(d) All of these
22. Which of the following best describes a form ?
(a) A form enables people to enter or view data in a database easily.
(b) A form summarizes and prints data.
(c) A form filters data from a database based on a criteria.
(d) All of these
23. Which of the following best describes a report ?
(a) A report enables people to enter or view data in a database easily.
(b) A report summarizes and prints data.
(c) A report filters data from a database based on a criteria.
(d) All of these
24. A database table should always contain
(a) images
(c) lots of ready made queries
25. Data in a database is stored in a
(a) table
(a) field
(a) record
26. A collection of data which is stored in a logical structure is known as a
(a) datatbase
27. One piece of data about a single person or thing is known as a
(a) table
(b) query
(a) query
(b) database
28. All of the information about one person or one thing is known as a
(b) field (c) file
(b) file
29. A collection of records on a particular topic is stored as a
Create
(b) lots of records
(d) a key field
called a
(c) report
(b) record
key.
(c) record
(b) report
databases.
(c) field
to help ensure data integrity.
31 To organize the different tables of related data, a relational
INFORMATION TECHNOLOGA)
(c) folder
30. To find a particular record or set of records in a database you would use a
(c) table
(d) search
(d) table
(d) database
32. To display data in a specific format or distribute a summary of data,
33. To get data input from user in a well-organized, formatted way on screen,
34. In the database view of a relational database, a row of information is called a
(d) record
(d) field
35. To control how information is entered into a database, programmers and database
administrators
(d) relationship
is used.
are created.
36. In a relational database, a common field that links two tables in a relationship but not a|
primary
key is
are used.
37. The database use common fields to create links between tables, Thus Such databases
are
called a

6. Session
7:
INTRODUCING DATABASES
8
Primary
key is
used to
39
40
A Foreign
key is
linked to the primary key of the same table. T/IF? is a
collection of related
information.
41.
A
Database
can have only one table. T/F ?
13
42.
If a
piece of data
(field-value) is stored in two places in the database, then storage space is wasted
and changing
the data in one place will not cause data
inconsistency. T/F
A5
A field can
store
group of
values. T/E
44. In a
relational
database, two
tables cannot have a
common field. T/F
A foreign key is the
primary key of
another table, T/E
6 Forms are used for
searching data in table. T/E
Competency Based GQuestions
(a) Relational
4 Akshat wants to store a huge
amount of
information about his firm in a
database. Which type of
table
organization
would be most suitable for this
purpose ?
(c) Either
Relational or Flat file
identify the reCord in a table.
(a) Inconsistency
(c) Standardisation
ihis type of storing data at
multiple locations is known as data
. Juan has stored the data related to his work in
multiple files. He did not realise that samne data
related to an
important thing was stored in three different files
separately.
Ihis problem is known as data
(a) Inconsistency
(c) Standardisation
uan has stored the data related to his work in
multiple files. He did not realise that same data
related to an importarnt thing was stored in three
different files
separately.
mdO a huge problem for Juan when he
modified the data in one file while
forgetting to
update other files.
(b) He
wants to club fields in a unique way.
(b) Flat File
(C) He wants
to create a field having a special
(d) He wants
to create a
(d) Hierarchical
only those
(b) Redundancy
Wants to create a foreign key ín each table.
values which are
(d) None of these
30. To
Support and help Juan, his
brother's friend
Prabhnoor has come. He explained the need and role
of
database in Such a case. So he advised him to create tables such that there should be a way to
Tecognise each row of the table uniquely.
What does
Prabhnoor mean by this way ?
(a) prinary
() composite primary
uniquely), then that field must be declared as
(b) Redundancy
(d) None of these
\. While designing the database, Prabhnoor suggested that if in a table there is a field which must take
141
value in it.
primary key in each table.
[CBSE
Sample Paper Term I,
2021-22]
key.
part of a field in another table, (where it can recognise the records
(b) altermate
(d) foreign
UNIT III: DATABASE
MANAGEMENT SYSTEM

7. leaes takens, CL. IWP. PL etc. (CL
-Casual Leaves, LWP -Leaves Without Pay, PL -l Privilege
leves taining to the attendance of employees eg, employees' no., monthis, years, no. of days Uorkvd unbhr
enployer name, desig1natten, department, grade, basic etc. Similarly, Attendance table may Contain data pe
example, an employee table may contain all
information pertaining
t0 an
enplye?e
A table is a
storage container that stores data
pertaining to single object, subject o
Purpose
Ans. In a
database
management system, various types of
objects together manag
SVstem. Tables are one of them.
3. What do you iu
Hderstand by tables in a
database
management system
?
One can
analyze or print data in a
specific layout using Reports.
one can find and retrieve just the data, which is
required using Queries
" one can view, add and update table data using Forms
one can divide one's data into separate storage containers called Tabies
manage databases. With BASE, one can manage all
information stored in a .odb tie: Within the file,
Ans. BASE is a
database management system part of
OpenOffice.org.
It otters mny
2. Write a short note on OOo BASE
functiwming.
(v) Enhanced Data Security.
(it) Starndardization
(ui) Data Consistency
(i) Data Sharing
Controlled Redundancy
required. The centralised storage facilitates many advantages like:
The database systems store data centrally at one place wheretrom all applications can ge he
Maageent Sstems (DBMS)
Ans. A database is a collection of logically related data.
()
terng sy ste.
1. What is database ? What is its significance ?
Time
A report is ar ejective way to present date in a printed format. It is a formal presentable document about data
Afom is an interfae in user speciffed layout that lets users view, enter, or change data directiy in the tobie
Soluion
A quey is a statement that gives you filtered data avrding to your conditions and specifications.
A primary key is a field that unique identifes the reords in a tabie.
A tabie refers to a stoage ONtairer storing data pertaining to single objert. subject or purpose.
Dupticatior of data is known as data redundany.
program that menages a database etethe and ethtenty.
DatahaR eÉs t the othon of inteetet ta ani Database
stem is hasiall & te baset ra
3 BASE ofers mary features ke tables. forms. queries and reorts to manage date.
3
3
LET US REVISE
3
3
5
JA databzse
142

8. UNIT III : DATABASE
MANAGEMENT
SYSTEM
b)
Which Department has
maxmunt enmployees
and what are theií Payroll
Numbers
?
0)
The Job
Title of
the employee with Payroll
Number
M421 is ?
Purchasing Clerk
143
Factory Manager
Sales Rep
Secretary
Accountant
Job Title
9,11,000
18,17,000
11,19,000
19,500 Payroll Clerk
23,11,000
14,15,000
9, 29,000
9,00,000
20),000
Price (Rs.)
39,000
24,000
18,500
35,000
9
Finance department their Payroll
Numbers
are : A621,
M502.
Salary (Rs.)
6289 XF 54
1233 CD 33
B G8347
DD B4978
SB A5526
BFK 297
M134
VSE 648
H219
W815
M421
M502
A621
Number
Payroll
1.2
1,4
1.6
1.2
1.4
2.0
1.8
Purchasing
Factory
Human Resources
Size of engine Registration
Sales
Finance
Department
Finance
0) How many felds are there in this part of the database ? 4) How many records are there in this part of the database
?
to mininize redundancy.
Megane
Model
Clio
Jetta
Raunag Singh
Firstname
Polo
Golf
Wahadevan Shruthi
Zafira
Vectra
James
lia
Fiza
Ahmed
Msder the following database.
Ans. (a) 7 (seven) (b) 5 (five)
Renault
Renault
Lastname
Volkswagen
Volkswagen
Volkswagen
Make
ns.
Walker
Opel
Mahotra
Opel
Sen
Shafia
i Th managCT
of a car shoæroonn USCS a database to store data about cars he sclls. This is part of the database.
OpenOffice.org
is a
relational database. n a relational
database, data is stored in multiple tables linked via common fields e.g., BASE of
Ans.
In a fat . databasc,
all the data is stored in a single file c., a spreadsheet.
4 Mhat
is
the differene
betueen
a fat t database and relational database ? ike redtuced
redundancy,
standardization and data integrity. Therefore,
tables,
provide a way to store related data together under one roof, taking care of things
Both
these
tables
reside in single database as both of them are related to single object called
INTRODUCING DATABASES
tables are maintained
enmployee. Two

9. is a feld ina table that urniquely iienities each record in a table.
Ans A
ioreign key is a
feli or ields that reter to a
primarv kev of
another
table whik
OpeningSa PANNber
Account'ho and PANNumber
Dateofih
Alternate ie: PANumber
NemherNhe
Aacounto
Caniidatz i
Ars Prmar, ke
sP rimarr es is 2 fed that uriquely idertiies the reoris in a tare
144
¿B

10. TEM
145
key different from a primary key ?
primary key ?
gn key ?
types of keys in a table.
Telational
database
different from a flat database
?
are the different steps involved in Designing a Database' ?
ht are -
forms
queries and reports
in BASE ?
at
are
advantages
of DBMS Over normal file system ?
one Popular DBMSs.
hatis
a
DBMS
?
What
Importance
does it have for an enterprise
Nhatis the
need
of setting relationships
between
tables
?
Mhatis
a
Primary
key ? What is an alternate key
tow do
you
interpret Field' in context
of a DBMS
?
Mrite the basic features of OOo BASE ?
Nrte the key
features of a DBMS ?
inat is meant by Data Redundancy ?
inat do you understand
by Data Inconsistency?
What is Database ?
De A storage
container
storing
data
pertaining
to a single object, subject
or purpose.
Nsignment
aer A formal,
presentable
printed
document
that lists
data in a formatted
manner.
itona Database
Manogement
System
RDBMS
y A statement
that gives
filtered
data according
to specified conditions.
himary
key
A field that uniquely
identifies
records
in a table.
Am
An
intertace
in user-specified
layout
that allows users to view, enter or change
data directly in table.
mismatching
copies
of same data.
segn
K¿y
A non-key
field
ofa
table
that refers to the primary key of another table.
ta mconsisteny Multiple
Duplication of data. HS
A COmpurer
program
that
manages
a database effectively.
e Monogenment
System
DBMS.
of interrelated data.
Collection
key
A primary
key
having a combination of more than one field.
GLOSSAR Y
INTRODUCING DATABASES

11. 145
UNIT III: DATABASE MANAGEMENT SYSTEM
18.
How
is a
foreign
key different from a primary key ?
17.
What is a
composite primary key ?
\6.
What is a
foreign key ?
15.
Name
different types
of keys
in a table.
14. How iS a relational database different from a flat database ?
enterprise ?
13.
Name some
popular DBMSs.
12. What are the
different steps
involved in 'Designing a Database'
?
jorms, queries and reports in BASE ?
11. What are
10. What are advantages of DBMS Over normal file system ?
9.
What
is a DBMS ? What
Importance
does it have for an
8.
What
is the need of
setting relationships
between
tables ?
Wnat iS a Primary key ? What is an alternate key ?
0W do you interpret 'Field' in context of a DBMS ?
Write the basic features of OOo BASE ?
Write the key features of a DBMS ?
What do you understand by Data Inconsistency?
3. What is meant by Data Redundancy?
3.
Aosignment
4.
1. What is Database ?
2.
Table A storage container storin8 data pertaining
to a single object, subject or purpose.
Ronort A formal, presentable
printed document
that lists data in a formatted
manner.
Relational Database
Management
Systemn RDBMS Query
A statement
that gives filtered data according to specified conditions.
Primary
key
A field that uniquely identifies
records in a table. Form
An interface
in user-specified
layout that allows users to view, enter or change data directly in table.
Foreign
key
A non-key
field of a table that refers to the primary key of another table.
Data Inconsistency
Multiple mismatching
copies of same data. Data Redundancy
Duplication
of data. DBMS
A computer
program
that manages a database effectively.
GLOSSARY
Data Base Management
System
DBMS. Data
Base Collection
of interrelated
data. Composite
Primary
key
A primary key having a combination of more than one field.
Session
7 : INTRODUCING
DATABASES

12. can app"
what
13/03/08
14/04/08
21/10/07
17/04/08
31/12/07
24/02/08
13/05/08
Give two other functions of database software that make it suitable for storing members
06/11/07
VISIT
years old
20. In a
relational database
if the
primary key in one table is used
as the link to another
table,
LAST
F
J
This data is
entere
F
F
21. The table shows some
members
of a
community centre. Anyone under twenty
for junior
membership
at a
lower rate.
J
TYPE MEMBER
State the DATE OF BIRTH of the member who will be first on the sortea lis
(b) The database needs to be sorted in
ascending order of
SURNAME.
INFORMATION TECHNOLOG
M
M
F
(c) Being able to sort data is one
function of
database software.
M
(iii) Give the
MEMBER-ID
of one of the female members.
M
(i) Give the
SURNAME of the youngest member shown.
M
M
GENDER
the term used to
describe the field in the
second table ?
when they join a
studio.
12/11/78
29/03/89
16/05/84
15/09/80
16/11/94
25/02/79
09/12/75
07/07/93
BIRTH
DATE OF
(a) (i) State how many records are shown.
George
Amandeep
Justine
Edmond
(a) secondary key
Carl
Kulbir
Leanne
Reece
FORENAME
(d) foreign key
(c) order key
Armson
(b) alien key
Singh
Logan
Skirrow
Jones
Nannar
McShane
data.
Briggs
2
1032
0672
0076
1145
1062
1075
0046
1036
MEMBERID SURNAME
Here is part of the file.
into the MEMBERS file.
19. Zest for Life' collects personal data from members
Applicotion Oriented Questions
146
`B
T
R
A
Pp

13. [Delhi 2002 (2 marks)]
[Delhi 2002 (2 marks)]
|Delhi 2009 (1 mark)]
[Delhi 2003 (1 mark)]
[OD 2005 (2 marks)]
[Delhi 2006 (1 mark)]
[Delhi 2006 (2 marks) ]
[Delhi 2007 (1 mark)]
[Delhi 2007 (L mark)]
[Outside
Delhi 200S (1 mark)]
[Delhi 2008 (2 marks))
[Delhi 2008 (1 mark)]
[Delhi 2008 (1 mark)}
6.
How are fields, record and a table
related
to each other
? Explain
with the help of an example.
4. Write the relationship between a database and a table.
147
Y
S. Disinguish between a reCord and a field in a table, with an example.
S.
Wite full form for () URL (ii) RDBMS.
Paid ?
Tecord Consists of several fields including
AdmissionNo
(Admission
Number)
RollNo
(Roll
Number),
Name. Which field Out
of these
three
should
be set as the Primary
key and why
? A
table named School (containing
data
of students
of the whole School)
is created
where
each
13.
what is the
difference between
"Rows'
and 'Columns'
in a table
?
2.
Wite
any two
advantages
of using database.
Full
1.
Define the terms
:
Table and Field in the context
of Base.
0.
Give any one use of
database.
can be used to capture
data on screen.
A database package allows
users
Junior
Full
Full
Junior
Member Type
Define
forms.
What is the need of using them ?
Each record is made up of.
Complete the following
paragraph
using the words provided. Barrv runs a small printing
company.
He wants to store details about his clients in a database.
Management System.
REPORT,
RECORDS,
CRITERIA,
FORMS, FIELDS,
TABLE, DATABASE
1. Define Database Management
System.
Write one example.
03/04/77
16/06/92
02/11/85
06/07/74
12/10/89
Date of Birth
UNSOLVED EXAMINATION QUESTIONS
Purpose of Database
(a) relative
b) referential
A database
file in which tables are linked together is
Ashish
d) recorded
Charan
What is a need of a database ?
Faqir
Sandie
Jatin
Forename
Data is stored in tables of
Use each word only once.
Ram
Singh
5. Write the
to query data that meet
Mirza
Smith
Puri
Surname
(c) relational
07073
12027
16104
17171
07135
3.
Member Number
Use
the information
given to answer questions :
Sesson
7:, INTRODUCING
DATABASES

14. Run...
Help and Support
Default Programs
Devices and Printers
Control Panel
Network
A
Creating Table with Table wizard
Opening an
Existing Datobase
Search
programns
and fil
A
Creating Base
Database
AA
Starting OOo Base
Back OpenOffice
OpenOffice Writer
OpenOffice Math
OpenOffice Impress
OpenOffice Draw
OpenOffice Calc
a OpenOffice Base
OpenOffice 4.1.1
ones. In
this
session, you are
going to
practically learn about
a relational GUI database.
Hhit
management systems
are
available today, out of
which
relational
databases are the
most
usu
previous chapter that data is
compiled
in the
form
of
tables
containi8
records and
fields,
0
store and
process data
effectively, databases
are used.
Different types
of datab1s
A
database
is a
collection
of
data that can be
used as
information.
You have
learnt
in t
Leathing Objectives
[see Fig. 2.1(a)).
OpenOffice Base
OpenOffice folder ’
All Programs ’
Start button ’
() Chck on
To
start
BASE, you may
follow
these steps :
once it is
put into
a
framework
or
structure that
provides
Context. In both these cases,
the dat
measure
a
temperature,
or
barcodes
can be
scanned
at a
till. This data becomes
informat
information. Computer input
devices often collect data
automatically. Sensors
can continuali
understand
it.
Data must
have some kind of
headings
Or
structure
around it to becom:
context and
meaning to the
data. This gives
it
meaning so that people
and Tables
Creating Database
2.2
Starting OOo
Base
is
part of
OpenOffice Suite
-
BASF
will be
read into
a
database
for
processing.
Information adds
Introduction
Se S SI 0 n
2.1
2

15. end (of Database,
called the front end of the database. However,
actual
work is done b
by the
The users work on a database using the interface provided
to them
(such,
as wizards, design view etc.).
The interface
with which users
Work
is
X
per the user instructions. This
None
per your sele
(d) None of these
(b) Military base
of action.
selected course
Do as
per your
server) is called the back end.
STEP 5
Database Server as
To view the data in this table once again, double click on its name and it will show
you i
INFORMATION TECHNOOG
Description
Figure 2.12 Table as part of the database.
NOTE
HSQL database engine
your table.
data and save
Enter the desired
the database.
table is part of
See, the created
Create View..
S Vse Wizard to Create Table..
Create Table in Design View.
AnvOIces
Window Help
Fiqure 2.11 Insert data in table.
12/10 2009
ShipDate
(c) Database component
(a) Air base
1. O00 BASE is an example of
data in the table.
12/10 09
InvorceDate
(i) Ater entering and saving data, you'll be taken to
database window
where you can See voUr newly created table as part of your database [see Fig. 2.12 below].
Embedded database
Reports
Forms
(Check Point
Qvenes
Tables
Eile Edit Yiew Insert Tools
Invoice.odb-OpenOffice.org Base
|of Record
101 1201
1001
CustomerlD IvoicelD
Eile Edit View Inset Ioos Window Help
previous step, it took
entry screen (see Fig. 2.11 below].
takes you to
screen
as
action. As we chose to Insert data immediately in
(vi) Once you click at Finish of previous step, it
Invoces Invoce-OpenOffice.org Table Data View
156

16. 157
SeSSION
2:
CREATING
DATABASE
AND
TABLES
?
(b)
create
table
through
table
wizard
directlv
in
a
blank
sheet
and
save
it
as
table
(e)
(a)
and
(b)
all
(c) enter data
(d)
all
the
above
(d) formula bars
?
(c) forms
(b) queries
(a) tables
(b)
A
date
field
(a)
A
customers
account
number
(d)
A
student
admission
number
(d) dbo
(c)
An
AutoNumber
field
(c) odb
is
5.
The
detault
extension
of
OOo
BASE
database
(d)
Ctrl
+
D
(c)
Ctrl
+
A
6
The
shortcut
key
to
create
a
new
database
is
(b)
Ctrl
+
O
(a)
Ctrl
+
N
(d)
Ctrl
+
D
and horizontal
Ctrl + A
(c)
-
The
shortcut
key
to
open
an
existing
database
is
(b) Ctrl +O
(a)
Ctrl
+
N
S.
A
table
is
a
set
of
data
elements
that
is
organized
using
a
model
of
vertical
(b) Columns, Rows
[CBSE
Sample
Paper
Term
I
2021-22]
(d) Forms, Reports
(a) Rows, Tables
(c) Rows, Columns
(d) Entry
(c) Field Type (c) Edit menu
Ater
opening
a
database,
vou
can
create
tables
interactively
using
(b) Tools menu
(a) Tables
specifies
the
type
of
data
that
may
be
stored
in
a
field.
(b) Autovalue
(d) Table wizard
(a) Autosave
)
A
database
can
have
muliple
obiects
like
table,
forms,
queries,
reports
etc.
9
1nere
can
be
multiple
primary
keys
in
a
table.
1.
State
True
or
False.
are
called
records
and
rows
in
tables
are
called
fields.
(iv) A be
(d) Model
|CBSE
Sample
Paper
Term
l
2021-22]
(c) Clients
(b) Back-ends
12 Database Servers
(a) Front-ends
13. Zoya learnt
Create
a
table.
But
when
the
Base
started,
she
cancelled
the
dialog
of
ompetency Based Guestions
She
was
unable
to
create
tables.
Help
her
do
this
by
picking
up
the
database.
OOo BASE to
She started
a
opening/creating
a
new
blank
database
or
open
an
existing
database.
Only
in
an
open
(a) Zoya Table
right
solution
from
the
options
b) Zoya
must either create
database, tables can
UNIT
III:
DATA
BASE
MANAGEMENT
SYSTEM
Base
OOo
in
your
to
new table database
a
2
What
method
can
yOu
use
to
add
a
(a)
Use
Design
view
to
create
table
of
up
made
the
following
components
EXCEPT:
is
3.
A
BASE
database
key
a
4.
Which
of
the
following
fields
would
not
make
suitable
primary
(b) base
(a) oob
Tab
(üi)
Columns in tables
NULL. primary value
key can
referred are
to as
about
database
tables.
She has
enthusiastically
downloaded
Open
Office. has recently
Wizard.
She
must
download
Table
Wizard
also.
has
not
downloaded
given below.
be created.

17. 158
a to
INFORMATION TECHNOL
Wizard
to
be
used
database.
new
a
and
her
has
She
interactivelv.
Which
feature
of
OOo
tables
in
this
way
?
(d)
The
Table
Wizard
(c)
The
Queries
Tab
BASE
will
help
her
to
create
the
using
Table
Wizard,
Zoya
is
clear
about
15.
While
creating
tables
(a)
The
Tables
Tab
(b)
The
Forms
Tab
this
what
type
of
data
(whether
Wizard?
()
She
should
create
a
text
file
which
stores
the
detalls
of
data
types
for
eachet.
(b)
Zova
cannot
define
the
type
of
data
to
be
stored,
in
Table
Wizard
choOse the
with other
(d) can the table.
LET US REVISE
BASE
is
the
database
component
of
open
source
office
suite
OpenOffice.
org
(00o).
P'P
The
default
extension
of
00o
BASE
database
is
.odb.
A
One
can
create
a
new
database
either
using
Table
Wizard
or
by
creating
constituent
tables
in
Design
View.
RIR
Time
Jhe
manager
of
a
car
showroom
uses
a
database
to
store
data
about
cars
he
sells.
This
is
part
of
the
aamei
Price (Rs.) 9,00,000
Registration
VSE 648
Size of engine
1.8
Model
Vectra
Make
Opel
9, 29,000
BFK 297
2.0
Zafira
Opel
14,15,000
SB A5526
1.4
Golf
Volkswagen
23,11,000
DD B4978
1.2
Polo
Volkswagen
11,19,000
B G8347
1.6
Jetta
18,17,000
1233 CD 33
1.4
Megane
Volkswagen
Renault
9,11,000
Clio
Renault
6289 XF 54
1.2
(a)
Give
the
nanne
of
a
field
that
contains
umeric
data.
(b)
Identify
the
field
type
of
the
'model'
field.
(c)
Which
field
cOuld
be
made
the
key
field
or
the
primary
key
?
Ans.
(a)
Size
of
Engine
and
Price
(b)
Character
or
Text
(c) Registration
(d) Zova should
install
special
extension
which
allows
create
tables
without
t
(c)
Zoya
must
fetch
the
settings
for
Table with base.
Zoya
rectified
mistake
created
database
14.
now
warnts
to
create
data
tads
in
be
will
what
date
etc.)
stored
the fields.
For
or
text
or
should
she
do
while
using
a
tabs
should
Zoya
fields,
the
selecting
After
()
Field
Type
for
each
field
in
the
table,
alorg
details.
Zova change
only the type
data from default
the Table
after
types,
wizard
has
create

18. 159
books
sells
TABLES
Plant: Geranium
Cost (Rs)
Number
41.50 63.00
2
44.50
3
56.00
4
be
67.50
5
to
storing?
Name
at
least
three
tables.
Listing B
Price (Rs.)
Listing A
Title
90
Bulbs for Spring
115
Price (Rs.)
90
Title
Green Lawns
Bulbs for Spring
225
115
Orchids
Green Lawns
300
195
Bonsai for Beginners
Orchids
300
Specify
which
database
operation
has
taken
place
that
has
converted
the
table
shown
in
Listing
A
to
that
of
table
shown
in
Listing
B.
Bonsai for Beginners
(iii)
Equipments
and
Materials
(ii) Books
(b)
Modification
of
record
has
taken
place.
(a)
Names
of
possible
tables:
(i)
Plants
Ans.
which
should
not
be
present
in
each
of
the
following
tables
:
do
as
directed
:
y
the
Item Quantity
Date of Birth
Item No.
(0)
Table
2.
:
Book
Accssn No
Price
Admno.
(i)
Table
3.:
Firmotive
Phone Number
Design Cat
FNo.
(iii) Phone Number
(ii) Admno
Ans.
(i)
Date
of
Birth
UNIT
III:
DATABASE
MANAGEMENT
SYSTEM
and
of
a
that
gardening
center
has
Nursery
plants
that
plants,
manwc,
gardening
a Rshalt oUns
enter
to
IISer
a
She
and
and
vthr
rclated,
itstrunents,
equipments
material.
lhas
developcd
program
that
asks
the
as
a
and
The
i
and
the
price
ofa
plant.
program
then
calculates
displays
table
ofprices shown below.
1
AND
CREATING DATABASE
(a)
Ca
you
nane
some
possible
tables
of
this
database
and
what
kind
of
information
would
they
of
database
to
store
details
books
stocked
by
the
center.
She
uses
the
database
a
() Rushali uSeS
roduce
lists
of
books
on
special
offer.
column(s)
out
of
the
given
three,
LlOK
at the
table
structures slhown below
and
(0) Table 1:Stock

19. 160
INFORMATION 1ECHHYOIC
GLOSSARY
features of
Primary
key
A
designated
field
having
unique
value
for
each
row
inatah
Assignment
datalase e Nated?
1
Hon
can
a
BASE
ot
designing
talbles
?
eated
in
BASE
?
4hat
is
the
n
How
can
a
table
wizard do ?
What
does
a
table
4
Can
vou
et
the
priman
kev
ot
a
table
through
the
table
wizard
2
5
PRACTICAL ASSIGNMENT
Start
5ASE
and
open
new
database
named
Employee.
Define
structure
of
first
table
of
your
data-base
as
follows
in
design
view.
Structure
of
Table
1
Data type
TINYINT
Field Nane Empcode
6RR R
Text (15 characters)
Fname
B
Text (15 characters)
Lname
Text
Address
Text (20 characters)
Date
City DOB
Text
Phone
Specity
Empcode
as
Primary
key
and
save
this
table
as
Table
1.
3
Define
structure
of
second
table
(Table
2)
as
follows
:
Structure
of
Table
2
TINYINT
Data Type
Empcode
Iield Nante
Text
Number
Date
Department
DOJ
Basic Salary
4.
Suggest
a
primary
key
for
table
2
and
set
it
for
table
2.
and
functions.
Dote
Type
Means
to
identify
type
data
type
and
associated

20. n
Se SS i
Creating/Editing Tables
in Design View
jearing Obyectias
Creating/Editing a
Table
in
Deign
View
A
Modifying
a
Table
in
Design
View
A
in
the
previous
session,
you
learnt
about
how
to
create
tables
using
table
wizard.
In
this
session,
introduction
we
shall
talk
about
how
you
can
create
and
edit
tables
in
design
view. DEF.
with
along
The
table
Design
View
shows
the
structure
of
a
table
by
showing
the
details
such
as
Field
Name,
Field
Type
and
settings
for
each
field.
Description
2
Creating/Editing a
Table
in
Design
View
Working
in
design
view
is
similar
for
creating
or
editing a
table
as
you
can
see
yourself
by
going
through
coming
sub-sections.
n
the
Database
window,
firstly
click
the
Tables
tab
(see
Fig.
3.1).
NOW
click
on
Create
Table
in
Design
View...
(see
Fig.
3.1)
To
Creote
a
Table
in
Design
View
i
Ne
Detabase.odt
-
OpenDficeorg
Bese
Fie
[dit
Yes
rset
Ioos
ndow
Heip
Creete e
teble
by
spectyng
the
figsd
rames
and
properties
Dessiption
as
we#
s
the
dete
1ypes.
Srete
Table
on
Desagn
View.
Click here to
create new table
in design view
e
Wcard
to
Crete
Tebie..
reate Vie
gbis
tione
Quenes
Tables tab
Fogms Prports
HSQL database rgine
Ebedde d detabese
hgure
3.1
Tables
tab
of
Database
window.
161

21. 23412
Scientfic
Ootions
1234 S
Decimal places Lesding zeroes
jegatue tured
Eormat code
TIhoutndt corto
Genera!
Cancet
the desired changes
Fiqure
3.7
Setting
Format
property
heck Point
add
to
you
can
a
new
table
Khat
ia)
Use
Design
new
to
create
a
tabla
(b)
create
table
through
table
wizard
a
(e)
(a)
and
(b)
hich
d
all
the
above
(d) Primary key
(c) Length
(b) Field type
()
number
of
records
(e)
size
of
table
(c)
LONGVARCHAR
(d)
all
these
:
Which
of
the
following
represent
Text
field
type
categories
in
OOo
BASE
?
(b) VARCHAR
1a
(d) .odb (d) null
a) .adp.
(c) void (c) .mdb
When
vou
save
a
BASE
database,
what
file
format
do
you
use
?
(b)
xml.
:
Ihe
iegal
empty
value
in
BASE
database
is
termed
as
(b) Time
(b) empty
i
Which
of
the
following
is
are
not
a
BASE
field
type
?
(d) Text
field
type
in
BASE.
(d) BigDouble
(c) Date/Time
(c) Double
(b) Percent
UNIT
IIL:
DATABASE
MANAGEMENT
SYSTEM
Once
you
have
made
in
the
table
structure,
you
can
enter
or
edit
data
in
learn
in
the
coming
session.
table
as
you
will
method
use
to
your
database
in
O0o
Base
?
blank
in
directly
data
sheet
and
save
it
(C)
enter as table
of the
following 1s/are
not
part(s)
of
table structure
in
OOo
BASE2
ia) Field Name
CHAR
TIMESTAMP belongs to
la) Hollow
(a) Integer
9) TinyINT

22. (b)
A
field
that
uniquely
identifies
each
record
is
called
a
21.
Fill
in
the
blanks
|CBSE
Sample
Puper
2011|
(d)
None
of
the
above
(c)
To
enter
lookup
data
that
the
field
should
refer
to
(b)
To
define
the
data
type
applied
to
each
field
within
the
table
(a)
To
describe
the
data
that
should
be
entered
in
each
field
20.
What
is
the
purpost
of
the
description
column
in
Table
Design
View
?
|CBSE
Sample
Paper
2011
(d)
A
student
admission
number
()
An
AutoNumber
field
(a)
A
customers
account
numnber
19.
Which
of
the
following
fields
would
not
make
a
suitable
primary
key
?
(b)
A
date
field
(a)
Text
(b) Number
(d)
All
the
above
[CBSE
Sample
Paper
2011)
(a)
Age
in
vears
(b)
Date
of
Birth
(c)
Age
in
days
(a)
Age
in
months
[CBSE
Sample
Paper
2011
One
of
these
is
required?
Out
of
the
following
which
one
is
most
appropriate
data
field
in
context
of
employee
table
u
(a) Data (2) Data
(b) Type
l6
What
identifies
the
contents
of
a
field
?
(b) Field Value
The
organizing
of
data
according
to
text,
number,
currency,
date/time,
(c) Date type
(c) Field name
(d) Table name (d) Data structure
(a) Tiny Integer
(b) Small Integer
The
number
487.52
should
have
a
field
size
of
: (c) Integer
etc is called
(d) Big Integer
(a) Field Name
(b) Data Type
(c) Description
(d) Field Size
optional2
13.
(2) record
(b) long integer
(c) column
(d) field
table,
each
D\D
will
be
entered
as
a
:
a
11.
A
BASE
database
is
made
up
of
all
the
following
components
EXCEPT:
(c) forms
(a) tables
(b) queries
(d) formula bars
(a) Format
(b) Entry Required
(c) Default Value
(d) Length
be
left
enptu
?
of
(d)
all
of
the
above
(e)
none
of
these
(a) Yes/No
(6) Image
(c) Binary
field
(b) Real
8.
(d) Float (a) Integer(lNT)
(c)
Small
Integer
(SMALLINT)
172
INFORMATION TECHIOIOGty
tield
is
knoWn
(a)
The
type
that
dictates
what
Sort
of
data
can
be
stored
within
What
data
tvpe
should
you
choose
for
a
zip
code
field
in
a
table
?
(c) Varchar
When
vou
define
a
field
for
a
table,
which
of
the following
parameters
does
BASE
always consider
up
d
12
Suppose
vou
like
to
set
table
in
BASE
to
monitor
your
growing
collection
of
DVDs.
In
that
10.
Which the
tollowing
field
properties
ernsure
"data
that
cannot
be
skipped
in
the
field"
or
"field
cannt
Which of the
following types cannot
9,
allow
integers
or
numbers
or
text
in
them
?
Which of the
following
field
types
can
represent
upto
5 digits numbers?

23. UNIT
II
:
DATABASE
MANAGEMENT
SYSTEM
(b) Time
(C)
"Tinestnip
(a) Date
tie
ffeld ?
in tIhe Otti
held
that
can
store
the
iate
and
the
attendance
of
the
table about
29.
Isha
has
nOW
SOme experience ofCeating
>f nty
Cmployees.
Alon
witlh
othr
lotail,
the
tbl<
shou
lo hav
nd
updatiny
tablS.
er
nus
nsCd
he
t
Cnàts
What
hoelt
bo
tlhe
icli
VPe
tr
his
s
theld
to
an
existine
taaole
in
not
alloe
iit
Be.
(c) (6)
She shoald
Open
the
table
in
Design
SHtte
Sna
should
delte
tine
old
table
an
create
A
ne
aiready
created
tabie
?
ohe
tield.
She
ha
alrnv
nter
n
te
oCUrds.It
add
(a) Tabie Wizard
eating
tables
(e) Design Viem
tO
Rt
tbl
I
*
Sa
ova´s
friend,
has
also
learnt
about
-ompetency Based QJEstiOns
() Date
() Tìme
data
wpe
sos
dat
and
tìme
walu
tK
tl«
(Oalidation Rule () aption
(«) Dault
Which ield pVpert
b
usd
tO
aChi
thìs
In
the
datashvt
ie
oi
th
Studont
talle,
tlh
S«iera
d.teir
tilu
ehis
tr
iis
()Alt ()Tabe Vie (a) ataheVi
Alr
that
qets
nterSn
Datas dispav iavot
Length
esutt Vali
Numbe
Dlaces toe
CRTG =
173
tO
delet
alI
the
rerords
in
the
talbl
oet
lhu
mI
n«w
ticlu
SSruly
created
her
irst
tnbl,
But while
ntri
dat
li Ealis«i
tit
e tNUt
t
interacivei
sne
sInou
ld
Na
te the
tables tO
and other settings,
What shoul
sn
ns
Dntaass.
he iS
a
O

24. (CBSE N
Or
1. Discuss various types of nunericc fields that you can have in BASE. Which field type is tihe upe ?
Explain any three data types in OpenOffice Base.
Time
J Null value represents a legal empty value in a database.
Soluen
3 Different field properties that can be set are : Entry Required, Length, Decimal Places, Default value and Form example.
J Special datatypes include : Yes/No, Image, Binary and Other.
J Numeral data types are : Tiny Integer, Small Integer, Integer, Big Integer, Float, Real, Double, Numenc
2
Decimal.
3 Date/Time data types are : Date[DATE], Time[TIMEJ,
Date/Time[TIMESTAMP].
3 tec data ypes are Tet () (CHAR], Tet (VARCHARJ, Tet[VARCHAR-IGNORECASE] and Memo[LONGVARCHAR.
J Maximum length of all text type field is 2 GB.
J BASE datatype have these categories: Text, Date/Time, Numeral and Special.
much iength as needed by the contents of the field.
3 Fxed length fields allot same length to all fields irrespective of their contents whereas variable length jielas 2u.
(c) By setting field property Decimal Places (d) By setting field property Entry Required
(b) By setting field property Default Value
JA table can be created or edited in design view.
(d) Default value property
LET US REVISE
empiovee. How can Isha achieve this ?
creating table, Isha has been asked to ensure that 'Charity Cause' field never goes blank ior a
32 Isha's office is a progressive office where each employee must commit to a charity catuse
(b) Length property
value int these fields.
a Isha should change the field type of Bonus and Salary as lext type and type Rs' wi.
(a) By setting field property length
(c) Isha should use Text type for these fields so that commas can be inserted in the values
k Isha should choose the field format for Bonus and Salary as the currency forrm a
look distinct s,
that the clearlv tell about the money value. What can Isha do to achieve this
(Salary and Bonus) should
(a) Isha cannot show two number fields differently from others.
31 In tables, the age number of days, salary and bonus fields have the sarne data type
Number
() Decimal places property
(a) Entrv Required property
policv of the organisation,
minimum
guaranteed
yearly Bonus is 7500/-
Bonus can be
ever tos
depending
upon the performance
of the employee.
What
should Isha set so that
the
rniritr
30. While creating tables for emplovees, in one of the tables, there is a field namely Bonus
amount of bonus is automatically
inserted in the Bonus field 2
174
However, the boss wants the field storing noney values

25. UNIT III: DATABASE MANAGEMENT SYSTEM
Quantity Purchased
(b)
ItemID
and
ItemName
can act as the primary key.
[CBSE Sample Paper 2011, Term I
Number
ItemD0P
Date
Number
Text
Text
a field or control.
175
Quantity Purchased
ItemDOP
ItemStock
ItemStock
Item Name
(b)
Which two fields can act as the Primary Key from the ab0ve table ?
ItmelD
()
TNo,
TName,
DOB, Address, B Salary.
Item Name
(4) Suggest the data types of all the fields
ItemId
() (a)
() Look at the table called "Item" given below and answer the question.
be present in the table called Teacherinfo.
Ijormation of the teachers teaching in the institution. Suggest five fieldnanmes, which you think must
) Pronita is a programmer in an institution and is asked to handle the records containing personal
thev can be entered in such situations.
neld but user does not have any value to enter. Since Null values are legal empty values in BASE,
Ans. Null values are very useful while entering data in a field when table demands data for the
Ans.
6. Do as directed :
and hence can store a combination of date and time, also known as timestamp.
times only. But the field type Date/Time[TIME
STAMP] is a combination
of both Date and Time types
Ans. The Date[DATE] field type stores the dates only and the Time[TIME] field type stores the
5. iVhat is the significance ofNull values ?
4 Hxc s the feld type Date/Tine (TIMESTAMP]
different from Datel{DATE] and TimelTIME] field types ? add records to the table, they can either accept this value or enter the name of a different house.
Pxample, in Student table, you might set the default value for House as "Tagore House". When users
The default value is automatically
entered in a field or control when a new record is created. For
3 I17aat do you understand
by default value ?
should
be used
when purely whole numbers are to be stored in the field. hle numbers, numbers with decimals, fractional numbers etc. On the other hand, INT field type NUMERIC tield tvpe should be used when we need to store all types of numbers such as
set automatically.
nineteen (19) spaces. Tt also has an auto value feature that fills up the field with a value you i) Bis lnteger (BlGINT|. This tield accepts integers or whole numbers with a fixed length of
eN3s, It also has an auto value feature that fills up the field with a value you set automatically.
1: should vOu prekr a NUMERIC fieldtype over INT ?
(i) Integer
|NT). This ield accepts integers or whole numbers with a fixed length of ten (10)
of five (5) spaes.
o) Small integer|S\1A1INT, This field accepts integers or whole numbers with a fixed length
three (3) spaces.
) Tinv Integer |TININT). This field accepts integers or whole numbers with a fixed length of
CREATING
EDITING TABLES IN DESIGN VIEW
Ans.
In BASE, we can have following tvpes of Numeric fields
Ans The default value is used to specify the default value for