Page 242 - IT 402 v2.0 class 10
P. 242
Interactive Interface
A database provides a more convenient interface for entering or viewing data.
In conventional systems, the data is usually not arranged properly, and as a
result, the availability of organised information becomes poor, and it becomes
too di cult to search for the re uired information in a huge database.
However, in case of a database, there is easy availability of information as the
data can be presented in an exact and proper format. A database also makes it
easy to respond to unexpected requests for a new types of information.
Features of Database
he main features of a database are as follows:
here can be more than one table in a database. For example in a school in the Students database there
can be one table for saving general details about the student. Another table may be to save the marks and
progress of the student. Other tables may include, fee details, library books issued, etc. all related to the
student.
he information stored in a table in a database relates to one specific topic. So all the related information
on a topic can be viewed in one single table.
In a database data can be simultaneously accessed by many users. So it saves storage space by storing
one table in one place where every authorised user can access it.
atabase offers data protection and features like recovery and backup for easy recording and retrieval of
data.
atabase allows the users to views data in different ways with only the re uired information.
Data stored in a database remains permanently stored until it is manually deleted from the system/server.
If the database table has uni ue value field than there are minimum chances of duplication of data which
avoids confusion at a later stage.
DATABASE MANAGEMENT SYSTEM (DBMS)
A database management system is a software package that controls the creation, maintenance and use of
a database. It lets organisations to develop databases for various applications according to their needs. A
database is defined as an integrated collection of data records files and other ob ects. MS refers to a
package that enables the users to store, modify and properly maintain the database and helps to extract
useful information from the database as and when required.
N ot e s
MS is a computerised record-keeping system whose purpose is to manage the data and make it
available as per the re uirement. atabase can be referred to as a digital filing system.
It is a software designed to store handle and process the information. It manipulates different types of
information in such a way that it helps to analyse the data and thus help in decision-making.
MS performs the tasks of maintaining databases so that information is readily available. It helps to
manage the data of different sectors like banks corporates railways airlines universities hospitals space
exploration, etc.
240 Touchpad Information Technology-X

