KEMBAR78
DBMS Users: Naive Users On-Line Users Application Programmers Database Administrator (DBA) | PDF | Business | Computers
Scribd
Upload
421 views6 pages

DBMS Users: Naive Users On-Line Users Application Programmers Database Administrator (DBA)

The document classifies DBMS users into four categories: naive users who are unaware of the database system; online users who can directly or indirectly communicate with the database; application programmers who develop programs for other users to interface with the database; and database administrators who have central control over the database system and perform functions like schema definition, data access authorization, and backup/recovery.

Uploaded by

ritu
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
421 views6 pages

DBMS Users: Naive Users On-Line Users Application Programmers Database Administrator (DBA)

The document classifies DBMS users into four categories: naive users who are unaware of the database system; online users who can directly or indirectly communicate with the database; application programmers who develop programs for other users to interface with the database; and database administrators who have central control over the database system and perform functions like schema definition, data access authorization, and backup/recovery.

Uploaded by

ritu
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
You are on page 1/ 6

DBMS Users

Depending on the degree of expertise and the role of interaction with DBMS,
DBMS users can be classified as

Naive users
On-line users
Application Programmers
Database Administrator(DBA)
Naive Users/End users
users who need not be aware of the presence of the database system or any
other system supporting their usage are considered as naive users.
e.g. ATM users
On-line Users
• users who are aware of the presence of the database system

• may communicate with the database directly via an online terminal or


indirectly via an application program

• more sophisticated users.

• may also use DML to manipulate the database directly.


Application Programmers
• professional programmers who are responsible for developing application
program utilized bu naive or online users.

• application programs could be in any programming language such as C,


Visual Basic etc. and include the commands to manipulate the database.
Database Administrator(DBA)
• The person or group of persons having central control over the system is
called Database Administrator.

• Functions of DBA
(i) scheme definition(conceptual)
(ii) storage structure and access method definition(physical)
(iii) scheme and physical organization modification
(iv) granting of authorization for data access
(v) integrity constraint specification
(vi) responsible for backup and recovery due to failure
DML(contd.)
• Two types of DML
(i) Procedural DML- requires a user to specify what data is
needed and how to get it.

(ii) Non-Procedural DML- requires a user to specify what data is


needed without specifying how to get it. Also known as
declarative language.

You might also like