There are four different types of database-system users, differentiated by the way they expect to interact with the system. Different types of user interfaces have been designed for the different types of users.
Database Administrator (DBA) : Database Administrator (DBA) is a person/team who defines the schema and also controls the 3 levels of database. A DBA creates new account id and password for the user. DBA is also responsible for providing security to the database and allows only the authorized users to access/modify the data base.
System Analyst : This type of user analyzes the requirements of parametric end users. They check whether all the requirements of end users are satisfied.
Naive Users (End Users) : These users are unsophisticated users who interact with the system by calling one of the application programs that have been written previously.
For example, a bank teller who needs to transfer Tk. 50 from account A to account B invokes a program called transfer. Application program asks the user for the amount of money to be transferred, the account from which the money is to be transferred, and the account to which the money is to be transferred. A typical user interface for naive users is a forms interface, where the user can fill in appropriate fields of the form.
System Analyst: This type of user analyzes the requirements of parametric end users. They check whether all the requirements of end users are satisfied.
Application programmer: Application Programmers also referred as System Analysts or simply Software Engineers, are the back-end programmers who write application programs. Application programmers can choose many tools to develop user interfaces. Rapid application development (RAD) tools are tools that enable an application programmer to construct forms and reports without writing a program.
Sophisticated users: These users are the engineers, scientists, business analyst, who are familiar with the database. They interact with the system without writing programs. Instead, they interact the database by writing SQL queries directly through the query processor. Analysts who submit queries to explore data in the database fall in this category.
Database Designers : Data Base Designers are the users who design the structure of database which includes tables, indexes, views, triggers, stored procedures and constraints. He controls what data must be stored and how the data items to be related. His responsibility is to understand the requirements of different user groups and then create a design which satisfies the need of all the user groups.
Casual Users / Temporary Users : Casual Users are the users who occasionally use/access the database but each time when they access the database they require the new information, for example, Middle or higher level manager.
Statlearner
Statlearner