Responsibility of DBA
1. Schema definition:
Creation of the original database schema is accomplished by writing a set of tables.
2. Storage Structure and access method definition:
The creation of appropriate storage structure and access method is accomplished by writing a set of definition.
3. Schema and Physical organisation modification:
DBA involves either the modification of the database schema or the description of the physical storage organisation.
4. Granting of authorisation for data access:
DBA allows the granting of different types of authorisation for data access to the various users of the database.
5. Integrity constraint specification:
The DBA specifies the constraints. These constraints are kept in a special system structure, the data dictionary that is consulted by the database manager prior to any data manipulation.