Page 206 - Computer - 10(A&B)

Sharing of Data

A DBMS facilitates sharing of data by storing it at one place and providing centralised access to the various users
or applications for different purposes.

High Data Security

The information stored in the database may sometime be confidential or of a great value and unauthorised
access to that information can cause unrecoverable losses to the organisation. DBMS ensures that the database is
to be accessed with the proper permissions and through proper channel.

Enforcing Standards

DBMS ensures that the values entered in the database should be in a specific format and only valid information
is stored by enforcing checks on the values entered by the user.

Concurrent Usage

DBMS allows multiple users to use or update the common database at the same time i.e., if two or more users
send the request at the same time for the data retrieval or updation, DBMS ensures that all the requests are
processed for the successful operation on the database.

Types of Database

Database can be of mainly three types:
v Flat database
v Relational database
v Distributed database

Flat Database

In a flat database, the entire data is stored as single file in the form of a table i.e., different
files in a database do not have any type of relationship with each other. For example,
a spreadsheet is a kind of flat database. This type of database is ideal for storing small
amount of data. Storing complex data in a flat database system can be more costly in
terms of time and processing power.

Relational Database
In a relational database, data can be stored in multiple tables which can be related or linked with each other on
a common field in such a way that user can retrieve the required information from the multiple tables and the
output can be in the form of a table itself. The software which is used to maintain this type of database is known
as Relational Database Management System (RDBMS). Microsoft Access, LibreOffice Base, Oracle and MySQL
are examples of RDBMS.
Department Professor
No. Name No. Name Dept No. Courses

Table 1

Table 2

Database
Table 3

Table 4
88