Page 216 - IT_V1.0_Class10
P. 216
Recap Zone
A database is defined as an organised collection of data that can be visualised as a container of
information. It allows for the storage, modification, and retrieval of data efficiently.
A database provides an efficient system for managing data and records. It has many advantages like
Organised Storage, Data Analysis, Data Sharing, Minimal Data Redundancy etc.
A database management system is a software package that controls the creation, maintenance and
use of a database. It allows organisations to develop databases for various applications according to
their needs.
Database servers are dedicated computers designed to store and manage databases.
A data model is a conceptual representation of data structures and relationships that helps in
organising and understanding the data. Various types of Data-models that are used are: Hierarchical
Data Model, Network Data Model, Relational Data Model.
RDBMS is a relational DBMS in which tables are linked to each other based on the common field.
Some of the important terms of RDBMS are: Entity, Keys, Data Value, Relationships, Constraints,
Degree, Cardinality.
In the LibreOffice Base, data between tables can be related on the basis of a common field called key
field. Examples of keys are Primary Key, Candidate Key, Alternate Key, Composite Key and Foreign
Key.
There are different objects that help in executing the purpose of database package namely Tables,
Queries, Forms, Reports.
Exercise
Section A (Objective Type Questions)
A. Multiple choice questions.
1. Database servers are referred to as .............................. [CBSE Sample Paper, 2022]
i. Front-ends ii. Back-ends iii. Clients iv. Model
2. ............................. ensures that the data entered in a particular field is accurate and up-do-date across all related records.
i. Referential Integrity ii. Field level data validation
iii. Data Consistency iv. Data Insurance
3. A database is an organised collection of ..............................
i. Data ii. Attributes iii. Record iv. Keys
4. In a company, employees use different software to manage and analyse data, but one program is not designed
for database management. Which of the following is not a database program?
i. MySQL ii. Oracle iii. Writer iv. LibreOffice Base
5. In RDBMS, data is organised in the form of ..............................
i. Table ii. Record iii. Field iv. Entity
6. What is the term used to describe the number of columns in a table?
i. Cardinality ii. Degree iii. Entity iv. Key
214 Information Technology Play (Ver 1.0)-X

