Users in DBMS environment

Updated

Database Management System (DBMS) is used to optimize and manage the storage and retrieval of data from databases. DBMS offers a systematic approach to manage databases and workloads accessing the databases.

DBMS allows users to create their own databases as per their requirement. DBMS has various advantages and properties over traditional file system.

In this article, we learn various category of DBMS users.

Users in a DBMS environment :

Following, are the various category of users of a DBMS system :

  1. Database Administrators :
    Database Admin is responsible for managing the entire DBMS system. He/She is called Database admin or DBA. Administrators also look after DBMS resources like system license, required tools, and other software and hardware related maintenance.

  2. Application Programmers :
    Application programmers (also known as designers) write programs in various programming languages to interact with databases. Designers are the group of people who actually work on the designing part of the database. They identify and design the whole set of entities, relations, constraints, and views.

  3. End-Users :
    End users are those who actually reap the benefits of having a DBMS. They conduct various operations on database like retrieving, updating, deleting, etc.



Please write comments if you find anything incorrect. A gentle request to share this topic on your social media profile.

Comment
Next tutorial
CPP_Programmer Published 4 Sep 2020 · 2 min read

Related tutorials

  • What is a database link in DBMS and its types

    We can define a database link to be a connection between 2 databases or two or more physical databases. Database links plays an significant role in case of…

    3 min read
  • Database Transaction Models and the CAP Theorem

    According to Brewer’s theorem (also called CAP theorem), any distributed data store (like a database) can only provide two of the following three guarantees: Consistency Availability Partition tolerance…

    3 min read
  • Some Interesting Facts About MySQL

    MySQL is a relational database management system (RDBMS) based on SQL- Structured Query Language and is free and open source.MySQL was created by MySQL AB, a Swedish company…

    2 min read
  • Normalization in DBMS: 1NF, 2NF, 3NF and BCNF

    If a table has data redundancy and is not properly normalized, then it will be difficult to handle and update the database, without facing data loss. It will…

    4 min read
  • Need for DBMS

    Database Management System (DBMS) is a system software for easy, efficient and reliable data processing and management. It can be used for: Creation of a database. Updating the…

    2 min read
  • Unary or Recursive Relationship in DBMS

    An entity relationship (ER) diagram, is a graphical representation of entities and their relationships to each other. ER modelling is based on two concepts: Entities, defined as tables…

    1 min read