MySQL + SQL · Lesson 7

Types of DBMS Users

Who are DBMS Users?

DBMS Users are the people who interact with a database in different ways — some design it, some maintain it, some write programs for it, and most simply use it to get their daily work done. A single database like a bank or school system is used by many types of people at the same time, each with a different role and different level of technical knowledge.

Think of a school database. The IT person who creates backups, the developer who builds the fee software, the clerk who enters fees, and the principal who views reports — all four are "users" of the same database, but their jobs are completely different. DBMS divides these people into clear categories so that responsibilities and permissions stay organized.

Main Categories of Users

In DBMS theory, users are commonly divided into five main categories based on what they do with the database:

Database Administrator (DBA) — controls and maintains the whole database
Database Designer — designs the structure (tables, keys, relationships)
Application Programmer — writes programs/software that use the database
End Users — actually use the application to enter and read data
System Analyst — studies requirements and plans the system

1. Database Administrator (DBA)

The DBA is the most important and most powerful user. This person manages the entire database and is responsible for its smooth, safe operation.

Responsibility	What it Means
Creating Users & Permissions	Deciding who can access what — using GRANT and REVOKE commands
Security	Protecting data from unauthorized access and attacks
Backup & Recovery	Taking regular backups and restoring data after failures
Performance Tuning	Adding indexes, optimizing slow queries
Storage Management	Managing disk space, archiving old data

Real example: In a school ERP, the DBA gives the accountant access only to the fees table, but blocks them from the salary table.

2. Database Designer

The Database Designer decides how data will be organized before any data is stored. They identify the entities (Student, Teacher, Fee), define tables, choose primary and foreign keys, and plan the relationships between tables.

Identifies what data needs to be stored
Designs tables, columns and data types
Sets primary keys, foreign keys and constraints
Applies normalization to remove data redundancy

Designer decides: students(roll_no PK, name, class_id FK) + classes(class_id PK, class_name)

3. Application Programmer

Also called the software developer. This user writes the actual programs and applications (in PHP, Java, Python, etc.) that talk to the database using SQL. The end user never writes SQL — the programmer writes it inside the software.

// Programmer writes this inside the fee software
$stmt = $pdo->prepare("INSERT INTO fees (roll_no, amount, month) VALUES (?, ?, ?)");
$stmt->execute([$roll, $amount, $month]);

The clerk just clicks "Save Fee" — this SQL runs behind the scenes.

4. End Users

End users are the largest group — the people who use the application daily. They are further divided into two types:

Naive (Casual) Users
Have no technical knowledge. They use simple menus and buttons. Example: a clerk entering student fees, or a bank cashier processing a deposit.

Sophisticated Users
Know SQL or use advanced tools to query data directly. Example: a data analyst running reports, or a researcher querying the database.

There are also Specialized Users who build complex applications like CAD systems or expert systems that use the database in advanced ways.

5. System Analyst

The System Analyst studies what the organization actually needs and converts those requirements into a plan for the designers and programmers. They are the bridge between management and the technical team.

Example: Before building a school ERP, the analyst meets the principal, lists requirements (admission, fees, results, attendance), and hands a clear specification to the design team.

Quick Comparison Table

User Type	Main Job	Technical Skill	Writes SQL?
DBA	Manage & secure database	Very High	Yes
Database Designer	Design table structure	High	Yes (DDL)
Application Programmer	Build software	High	Yes
Naive End User	Use application daily	None	No
Sophisticated User	Run reports & queries	Medium	Yes
System Analyst	Plan requirements	Medium	Rarely

Real Example – School ERP

One school database, six types of users working together:

Person	User Type	What they do
IT Admin	DBA	Backs up database nightly, manages logins
Senior Developer	Designer + Programmer	Designed tables, built the ERP software
Fee Clerk	Naive End User	Enters daily fee payments through forms
Exam Coordinator	Sophisticated User	Runs result-analysis reports
Principal	End User	Views dashboards and summaries

Common Mistakes

Confusing DBA with Database Designer — DBA maintains, Designer plans the structure.
Thinking end users write SQL — they use the application, the programmer writes SQL.
Forgetting that one person can play multiple roles (e.g. designer + programmer in a small team).
Mixing up "naive user" (no skill) with "sophisticated user" (knows SQL).

Practice Questions

List the five main types of DBMS users.
What is the role of a DBA? Name any three responsibilities.
Differentiate between a naive user and a sophisticated user with one example each.
Who writes SQL inside a fee-management application — the clerk or the programmer? Why?
In your school, identify one real person for each user category.

Summary

DBMS users are divided into five main types based on their role.
DBA manages and secures the database (most powerful user).
Designer plans the table structure; Programmer builds the software.
End users are the largest group — naive (no skill) and sophisticated (know SQL).
System Analyst plans requirements and links management with the tech team.
In real projects, one person may handle several roles.

💻 Live Code Editor

This page's programs are ready here — run them, edit them, and learn. No installation needed.

Powered by OneCompiler. The code loads into the editor automatically — press Run to see the output. If the editor does not open, open it in a new tab.