The functions of dba, Database Management System

Assignment Help:

The functions of DBA?


Related Discussions:- The functions of dba

Whenever the limit clause will be used, Whenever the LIMIT clause will be u...

Whenever the LIMIT clause will be used? LIMIT is used for the following kinds of problems: 1) Answering questions about first or last and largest or smallest 2) Splitting

What is an index, What is an index? An index is a structure that helps ...

What is an index? An index is a structure that helps to place desired records of a relation quickly, without probing all records.

Explain the cartesian product, Explain the Cartesian product:  The Cart...

Explain the Cartesian product:  The Cartesian product operation does not need relations to union-compatible.  The meaning of this is that the involved relations may have dissim

State the objectives-data source, You will be analysing a set of financial ...

You will be analysing a set of financial data of your choice. It is not necessary to collect any primary data of your own, and publicly available secondary data will be sufficient

Logical design part 1, create an e-r diagram usuing graphical dipicted soft...

create an e-r diagram usuing graphical dipicted software that could theoritically be used in resturant application

What are the various symbols used to draw an e-r diagram, What are the vari...

What are the various symbols used to draw an E-R diagram? Explain with the help of an example how weak entity sets are represented in an E-R diagram. Various symbols used to d

Explain the two constraints check and foreign key in sql, Explain the two c...

Explain the two constraints, check and foreign key in SQL along with an example for each. Give the syntax. CHECK constraint - CHECK constraint specifies an expression which

Can a domain, Can a domain, assigned to a data element be changed? Yes....

Can a domain, assigned to a data element be changed? Yes.  We can do so by just overwriting the entry in the field domain.

Develop a database design , A practice called Perfect Pets provides private...

A practice called Perfect Pets provides private health care for domestic pets throughout America. This service is provided through various clinics located in the main cities of Ame

Write short notes on tuple relational calculus, Write short notes on tuple ...

Write short notes on tuple relational calculus. The tuple relational calculation is anon procedural query language. It defines the desired information without giving a particul

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