Rolls in DataBase Environment

 Users of Database System:-

1. Data Administrator (DA)
2. Database Administrator (DBA)
3. Database Designer
4. Application programmers 
5. End users

Data Administrator (DA):-

A data administrator is a person who is responsible for entire data of an organization. He normally develop overall functional requirements for database used in the organization.

Main responsibilities:-

·       Database planning

·       Development and maintenance of standards, policies and procedures

Database Administrator (DBA):-

            A database administrator is an important person in development of any database system. He is responsible for the design, implementation, operation, management and maintenance of database. He must be technically competent and a good manager.

Main responsibilities:-

·       Physical realization of the database

·       Physical database design and implementation

·       Security and integrity control

·       Maintenance of the operational system

·       Ensuring satisfactory performance of the applications for users

Database Designers (Logical and Physical):-

                  The logical database designer is concerned with identifying the data (that is, the entities and attribute), the relationship between the data, and the constraints on the data that is to be stored in the database. It define the complete description of the data stored in the database.

The physical database designer decides how the logical database design is to be physically realized. This involves:

·       Mapping the logical database design into a set of tables and integrity constraints

·       Selecting specific storage structures and access methods for the data to achieve good performance

·       Designing any security measures required on the data

Application Programmers:-

              Once the database has been implemented, the application programs that provide the required functionality for the end-user must be implemented. This is the responsibility of the application developers.

End Users (naive and sophisticated):-

                A end users are the persons who directly interact with database system. They use database application without technical knowledge of databases. End users interact with databases through an interface. They do not write any programs. The end user must have the knowledge of the installed software to be used.