The functions of dba, Database Management System

Assignment Help:

The functions of DBA?


Related Discussions:- The functions of dba

Foreign keys , Foreign Keys and NULL Let us take the relation:         ...

Foreign Keys and NULL Let us take the relation:                 DEPT DEPT ID DNAME BUDGET D1 M

What is trigger, What is Trigger? Trigger: A database trigger is proced...

What is Trigger? Trigger: A database trigger is procedural code which is automatically executed in response to specific events on a particular table in a database. Triggers can

Write short notes on extension and intension, Write short notes on extensio...

Write short notes on extension and intension? In any data model, it is significant to distinguish among the description of the database and the database itself the description

Top down method and bottom up method, Evaluate, compare and contrast the tw...

Evaluate, compare and contrast the two methods of relational database design namely top down method and Bottom up method. What will be your choice if you are asked to select a meth

What are the ways in which signal can be generated, What are the ways in wh...

What are the ways in which signal can be generated A signal might be generated in many ways such as a Signal is result of particular physical condition. Whenever a process writ

Define the term domain, Define the term Domain. For each n every attrib...

Define the term Domain. For each n every attribute there is a set of permitted values known as the domain of that attribute.

Give two profit of reuse of code, Give two profit of Reuse of Code. Re...

Give two profit of Reuse of Code. Reusing the implementation . Place existing class directly inside a new class. The new class can be made up of any number and type of the oth

List the requirements needed to design a trigger, List the requirements nee...

List the requirements needed to design a trigger. The requirements are:- Specifying when a trigger is to be implemented. State the actions to be taken when the trigger im

Designing the fields in the data base, Designing the fields in the data bas...

Designing the fields in the data base The following are the considerations one has to remain in mind while designing the fields in the data base. Coding, compression, en

12/5/2013 4:46:57 AM

The functions of DBA include-

(i) Database Design- Conceptual Database Design consists primarily of defining data elements to be included in database, the relationship that exists between them and the value constraints apply. A value constraint is rule defining permissible values for specific data items.
Physical Database Design determines physical structure of database and includes such decisions as what access methods would be used to retrieve data and what indexes would be built to improve performance of system.

(ii) User Training- the DBA is responsible for educating users in structure of database and in its access through the DBMS. This will be done in formal training sessions by interacting with users to create database views, through user''s manuals and episodic memos and through company information centres. An information centre is a region where users are provided with facilities to do their own computing.

(iii) Database Security and Integrity- The concept of combining an organization''s data into one common pool accessible to all has both compensation and disadvantage. The clear advantage of data sharing is offset by the drawback that data could be misused by the users who do not have original responsibility and authority over data. The DBA supplies procedures and controls to avoid abuse of data.

Access of database is at last controlled by password mechanism, whereby user attempting contact gives a system-validates password. A system allows validated user only those contact rights recorded in data dictionary. DBA is responsible for assigning passwords and controlling privileges. Data integrity refers to problems of maintaining accuracy and consistency of data values. Security mechanisms are as passwords and data views protect data integrity.

(iv) Database System Performance- A database system being simultaneously accessed by many users may respond very slowly at times because physical problems associated with users competing for same resources are not unimportant. Thus, the DBA staff should include technically capable.

 

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