End users are basically those people whose jobs require access to the database for querying, updating and generating reports. The database primarily exists for their use. There are several categories of end users these are as follows:
1. Casual End Users –
These are the users who occasionally access the database but they require different information each time. They use a sophisticated database query language basically to specify their request and are typically middle or level managers or other occasional browsers. These users learn very few facilities that they may use repeatedly from the multiple facilities provided by DBMS to access it.
2. Naive or parametric end users –
These are the users who basically make up a sizeable portion of database end users. The main job function revolves basically around constantly querying and updating the database for this we basically use a standard type of query known as canned transaction that have been programmed and tested. These users need to learn very little about the facilities provided by the DBMS they basically have to understand the users’ interfaces of the standard transaction designed and implemented for their use. The following tasks are basically performed by Naive end users:
- The person who is working in the bank will basically tell us the account balance and post-withdrawal and deposits.
- Reservation clerks for airlines, railway, hotels, and car rental companies basically check availability for a given request and make the reservation.
- Clerks who are working at receiving end for shipping companies enter the package identifies via barcodes and descriptive information through buttons to update a central database of received and in transit packages.
3. Sophisticated end users –
These users basically include engineers, scientist, business analytics and others who thoroughly familiarize themselves with the facilities of the DBMS in order to implement their application to meet their complex requirement. These users try to learn most of the DBMS facilities in order to achieve their complex requirements.
4. Standalone users –
These are those users whose job is basically to maintain personal databases by using a ready-made program package that provides easy to use menu-based or graphics-based interfaces, An example is the user of a tax package that basically stores a variety of personal financial data of tax purposes. These users become very proficient in using a specific software package.
- Categories of SQL Functions
- Categories of Two Phase Locking (Strict, Rigorous & Conservative)
- Need for DBMS
- Starvation in DBMS
- Disadvantages of DBMS
- Cascadeless in DBMS
- Recoverability in DBMS
- Deadlock in DBMS
- Difference between DDL and DML in DBMS
- Interfaces in DBMS
- OLAP Operations in DBMS
- Difference between RDBMS and DBMS
- Implementation of Locking in DBMS
- Number of possible Superkeys in DBMS
- File Organization in DBMS | Set 2
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to email@example.com. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.