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.
Don’t stop now and take your learning to the next level. Learn all the important concepts of Data Structures and Algorithms with the help of the most trusted course: DSA Self Paced. Become industry ready at a student-friendly price.
- Categories of SQL Functions
- Categories of Two Phase Locking (Strict, Rigorous & Conservative)
- Different types of Database Users
- Need for DBMS
- Deadlock in DBMS
- Recoverability in DBMS
- Difference between DDL and DML in DBMS
- Cascadeless in DBMS
- Difference between 1NF and 2NF in DBMS
- Disadvantages of DBMS
- Difference between 2NF and 3NF in DBMS
- History of DBMS
- Starvation in DBMS
- Interfaces in DBMS
- The CAP Theorem in DBMS
- Difference between 3NF and BCNF in DBMS
- Types of Schedules in DBMS
- Multivalued Dependency (MVD) in DBMS
- Implementation of Locking in DBMS
- Concurrency Control in DBMS
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to firstname.lastname@example.org. 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.