The functions of DBA include-
(i) Database Design- Conceptual Database Design consists primarily of defining data elements to be included in database, the relationship that exists between them and the value constraints apply. A value constraint is rule defining permissible values for specific data items.
Physical Database Design determines physical structure of database and includes such decisions as what access methods would be used to retrieve data and what indexes would be built to improve performance of system.
(ii) User Training- the DBA is responsible for educating users in structure of database and in its access through the DBMS. This will be done in formal training sessions by interacting with users to create database views, through user''s manuals and episodic memos and through company information centres. An information centre is a region where users are provided with facilities to do their own computing.
(iii) Database Security and Integrity- The concept of combining an organization''s data into one common pool accessible to all has both compensation and disadvantage. The clear advantage of data sharing is offset by the drawback that data could be misused by the users who do not have original responsibility and authority over data. The DBA supplies procedures and controls to avoid abuse of data.
Access of database is at last controlled by password mechanism, whereby user attempting contact gives a system-validates password. A system allows validated user only those contact rights recorded in data dictionary. DBA is responsible for assigning passwords and controlling privileges. Data integrity refers to problems of maintaining accuracy and consistency of data values. Security mechanisms are as passwords and data views protect data integrity.
(iv) Database System Performance- A database system being simultaneously accessed by many users may respond very slowly at times because physical problems associated with users competing for same resources are not unimportant. Thus, the DBA staff should include technically capable.