Explain the different categories of End Users in DBMS?

End users are going to perform various database operations like querying, updating and generating reports.

The different types of end users are as follows −

  • Casual end users

  • Parametric end users

  • Sophisticated end users

  • Standalone users

Casual end Users

The casual end users access the database occasionally. Each time they access the database their request will change.

They use sophisticated database query language to retrieve the data from the database.

Example − High level managers who access the data weekly basis.

Parametric end users

Parametric end users spend most of their time in querying and updating the database using standard types of queries.

They make up a large section of the end-user population.

Example − A bank teller who does this activity for an entire shift of operations.

Sophisticated end users

The sophisticated end users access the database to implement their own applications to meet their specific goals.

These include business analysts, engineers, scientists which are familiar with the system capabilities.

The users interact with the system without writing programs. They submit each query to a query processor.

Standalone users

The standalone end users maintain their own database by creating one using the ready-made program packages that provide a graphical user interface.

The different categories of the end users in the database management system (DBMS) are given in the chart below −