Wednesday, 29 July 2020

What are the 5 components of DBMS?

Components of DBMS:



Every component plays a vital role in database management. These components are:

1.    Data:

A data can be defined as a collection of raw facts and figures.  The term database is referred as a collection of the related data. The data is a key component and for the management of it the DBMS works.

2.    Software:

It includes both types of software viz. system and application software that are used to work on a database. The software is set of instruction required to manage, maintain and work with data. It also provides an interface between the user and a database.

3.    Hardware:

The hardware includes CPU as well as other peripheral devices such as monitor, keyboard, hard disk, printer, etc. These are required for input, processing and output purposes.

4.    User:

It includes all types of users that are benefited by the DBMS. Following are the various types of users commonly associated with a DBMS:

a)    The DBA (Database Administrator) is a person or group of persons that have the central control over the DBMS. They are in charge of implementing the system within an organization. Further, they have all the system privileges and it is they decide access permissions for other users to access the database system.

b)    The end users are persons who sit at workstations and interact with the system. They may need to respond to requests from people that are outside of an organization, or to find answers to the questions quickly asked by higher level management. In some cases they may generate periodic reports. If required, they should be allowed to change data within the system.

c)    Direct users are those users that use the database system directly by following instructions provided in an interface. Such users interact with system using applications that are already developed.

d)    Indirect users work with the DBMS indirectly. They commonly use output generated programs for decision making.

e)    The application programmers interact with the system using HLL such as VB, Java, C#.Net etc. they access the data from programs written using such HLL.

 

5.    Procedures:

Procedures are instructions and rules that assist on how to use the DBMS, in its design and running the database. They serve as a guide to the users that operate and manage it.

1 comment: