1. Introduction to DBMS

1.5. Role of key players in Database Design and Development

ROLE OF KEY PLAYERS IN DATABASE DESIGN AND DEVELOPMENT
1. Data Administrator – a business manager responsible for controlling the overall corporate
data resources
2. Database Administrator (DBA) - a technical person responsible for development of the
total system
3. Systems administrator - Oversees the database systems general operations.
4. Database administrator (DBA) - Manages the DBMS use and ensures that the database is
functioning properly. His functions include:
i. Scheme definition - The original database scheme is created by writing a set of
definitions, which are translated by DDL compiler to a set of tables that are
permanently stored in the data dictionary.
ii. Storage structure and Access Methods Definitions - By writing a set of definitions for
appropriate storage structures and access methods, which are translated by the data
storage and definition language compiler.
iii. Scheme and physical organisation modifications - Modification to either the database
schema or description of the physical storage organisation are accompanied by
writing a set of definitions which are used by either the DDL compiler or the data
storage and definition language compiler to generate modification to appropriate
internal systems tables e.g. data dictionary.
iv. Granting authorization to data access - This is so as to regulate which parts of the
database users can access.
v. The database manager keeps integrity Constrains in a special system structure
whenever an update takes place in the system.
5. Database designers - These are the database architects who design the database structure.
6. Systems Analysts & Programmers (application programmers) - They design and
implement the application programs they design & create the data entry scheme, reports &
procedures through which users access and manipulate the databases data.
7. End users - These are the people who use the application programs to run the
organizations daily operations.