Many persons are involved in the design, use, and maintenance of a large database with a few hundred users. Here we will consider people who may be called “Actors on the Scene”, whose jobs involve the day-to-day use of a large database.
- Database Administrators:
Administrating the primary (database) and secondary (DBMS and related software) is the responsibility of the database administrator (DBA). The DBA is responsible for authorizing access to the database, for coordinating and monitoring its use, and for acquiring software and hardware resources as needed.
- Database Designers:
Database Designers are responsible for identifying the data to be stored in the database and for choosing appropriate structures to represent and store this data.Database designer typically interact with each potential group and users and develop a view of the database that meets the data and processing requirements of this groups.
- End Users:
End users are the 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:
- Casual end user:
Occasionally access the database, but they may need different information each time. They are typically middle-or high-level managers or other occasional browsers.
- Naive or Parametric end user:
Their main job function revolves around constantly querying and updating the database, using standard types of queries and updates that have been carefully programmed and tested. Bank tellers, Reservation Clerks for airlines, hotels, etc are the example of Naive end users.
- Sophisticated end users:
Sophisticated end users include engineers, scientist, business analyst and others who thoroughly familiarize themselves with the facilities of the DBMS so as to implement their applications to meet their complex requirements.
- Stand-alone users:
They maintain personal database by using ready-made program packages that provide easy-to-use menu or graphics-based interfaces.
- Casual end user:
- Software Engineers:
System analysts determines the requirements of end users, especially naive and parametric end users, and develop specifications for canned transactions that meet these requirements.Application programmers implement these specifications as programs; then they test, debug, document, and maintain these canned transactions. Such analyst and programmers are called Software Engineers.
Attention reader! Don’t stop learning now. Get hold of all the important CS Theory concepts for SDE interviews with the CS Theory Course at a student-friendly price and become industry ready.