Explain the role of a database administrator, Database Management System

Assignment Help:

Explain the Role of a database administrator

a. Defining the Schema 

 The DBA describes the schema which consists of the structure of the data in the application.

The DBA defines what data needs to be present in the system ad how this data has to be denoted and organized. 

b. Liaising with Users 

The DBA wants to interact continuously with the users to understand the data in the system and its employ.

c. Defining Security & Integrity Checks 

 The DBA finds out about the access restrictions to be defined and demonstrates security checks accordingly. Data Integrity checks are as well defined by the DBA.

d. Defining Backup / Recovery Procedures 

 The DBA as well defines processes for backup and recovery. Defining backup procedures involves specifying what data is to backed up, the periodicity of taking backups and as well the medium and storage place for the backup data. 

E. Monitoring Performance 

The DBA has to incessantly check the performance of the queries and take measures to optimize all the queries in the application.


Related Discussions:- Explain the role of a database administrator

What are axioms, What are axioms? Axioms or rules of inference give a s...

What are axioms? Axioms or rules of inference give a simpler technique for reasoning about

Create a query to produce single output-er model, This assignment concerns ...

This assignment concerns the Research database. The database ER model is shown above, where attributes are omitted for clarity. The relational model for the database is: Departm

What is the main goal of raid technology, What is the main goal of RAID tec...

What is the main goal of RAID technology? Describe the levels 1 through 5. RAID stands for Redundant Array of Inexpensive (or sometimes "Independent")Disks. RAID is a met

Shadow paging, Describe the shadow paging technique.

Describe the shadow paging technique.

Define rule that value of foreign key appear in other table, Determine the ...

Determine the rule that a value of a foreign key should appear as a value of some particular table is called a  Ans: Referential constraint.    The rule that a value of a fo

Confirming.., I just purchased a document for you guys and wanted to confir...

I just purchased a document for you guys and wanted to confirm that it will be send within an hour or 2 to my email or where will document be sent to?

What are domain constraints, What are domain constraints?  A  domain is...

What are domain constraints?  A  domain is  a  set  of  values  that  might  be  assigned to an attribute  .all  values that appear in a  column of a relation must be taken fro

How many types of views are there, How many types of Views are there? ...

How many types of Views are there? There are Four types of views:- Database View Help View Projection View Maintenance View

Data Minnning, Can i get help with weka software

Can i get help with weka software

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd