Role of Database Administrator and types of users for a DBMS

Role of Database Administrator:

In general there are three types of users for a DBMS:

1. The END User is the person who uses the application. Finally he is the one who actually puts the data into the system into use in business. This user require not know anything about the organization of data in the physical level.

2. The Application Programmer who makes the application programs. He / She have more knowledge about the data and its structure. He / she is able to manipulate the data using his/her programs. He/she as well need not have access and knowledge of the complete data in the system.

3. The DBA (Data base Administrator) who is like the super-user of the system. The role of DBA is extremely important and is defined by the following functions.

a) Defining the schema- The DBA describes the schema which contains the structure of the data in the application. The DBA determines what data requires being present in the system and how this data has to be presented and organized.

b) Liaising with users - The DBA requires interacting constantly with the users to understand the data in the system and its use.

c) Defining Security and Integrity checks- The DBA finds about the entrance restrictions to be defined and defines security checks accordingly. Data Integrity checks are describe by the DBA.

d) Defining Backup/Recovery Procedures- The DBA as well defines procedures for backup and recovery. Defining backup procedure comprises specifying what data is to be backed up the periodicity of taking backups as well as also the medium and storage place to backup data.

e) Monitoring performance- The DBA has to incessantly monitor the performance of the queries and take the measures to optimize all the queries in the application.

Latest technology based Database Management System Online Tutoring Assistance

Tutors, at the www.tutorsglobe.com, take pledge to provide full satisfaction and assurance in Database Management System help via online tutoring. Students are getting 100% satisfaction by online tutors across the globe. Here you can get homework help for Database Management System, project ideas and tutorials. We provide email based Database Management System help. You can join us to ask queries 24x7 with live, experienced and qualified online tutors specialized in Database Management System. Through Online Tutoring, you would be able to complete your homework or assignments at your home. Tutors at the TutorsGlobe are committed to provide the best quality online tutoring assistance for Database Management System Homework help and assignment help services. They use their experience, as they have solved thousands of the Database Management System assignments, which may help you to solve your complex issues of Database Management System. TutorsGlobe assure for the best quality compliance to your homework. Compromise with quality is not in our dictionary. If we feel that we are not able to provide the homework help as per the deadline or given instruction by the student, we refund the money of the student without any delay.

©TutorsGlobe All rights reserved 2022-2023.