Page 234 - PYTHON-12

12.2.2 Components of a Database System

The various components of a database system are described in Fig. 12.6 below:

Fig. 12.6: Components of a Database System

Let us discuss these various components.

1. Users: Users can be of varied types, usually a DB administrator, System or Application
developers and End-users. DBMS provides the following critical services to the user:
(a) Database Creation: A DBMS helps the user in creating and defining the required data or,
in turn, a database. It manages and organizes the required data and databases.

(b) Database Maintenance: It helps in maintenance of data and database by addition,
deletion, modification and regular updation of the tables and its records.

(c) Database Processing: A DBMS performs one of the major tasks of query processing—it
processes the queries or the information requirement of users and retrieves necessary
information from the database.
2. Database Application: Database application may be Personal, Departmental, Enterprise and
Internal. It may be general-purpose or customized as per the needs of a user.

3. DBMS: Software that allows users to define, create, access and manage database(s) is termed
as a DBMS. For example, MySQL, Oracle, etc.
Computer Science with Python–XII 12.4 12.2.3 Advantages of a DBMS
4. Database: It is a collection of logical data.

Apart from providing various salient features described above, a DBMS has several advantages
over traditional data processing techniques.

Elimination of Data Redundancy: Duplication of data leads to wastage in storage space.
1.
A DBMS eliminates data redundancy (duplication of data) by integrating the files so that
multiple copies of the same data are not stored.