Designing & Implementing Data Bases & Applications ?

The DBA function also provides data modeling & design services to end users. One of the primary activities of a DBA is to determine and enforce standards and procedures to be used.

The DBA design the data base at conceptual, logical & physical levels.

Conceptual design®Both DBMS & hardware independent

Logical design ®DBMS dependent & hardware independent

Physical design ® Both DBMS & hardware dependent

The DBA also works within application programmers to ensure the quality & integrity design & transactions. DBA also view the transactions are Correct : Transactions are correct. Efficient : Transactions code efficient (or) not. Complaint : Provide integrity rules and standards.

Before an application comes online the DBA must develop test and implement the operational procedures required by new system.

operational procedures include: Utilizing training , security, backup & recovery.