Describe the responsibilities of the dba and the database, Database Management System

Assignment Help:

Describe the responsibilities of the DBA and the database designer ?

The responsibilities of DBA and database designer are:
1. Planning for the database's future storage needs
2. Describing database availability and fault management architecture
3. Defining and forming environments for development and latest release installation
4. Creating physical database storage structures after developers have designed an application
5. Constructing the database
6. Determining and setting the physical and size locations of data files
7. Evaluating latest hardware and software purchase
8. Researching, testing, and recommending tools for Oracle development, database administration, modeling, and backup and recovery implementation, as well as planning for the future
9. Giving database design and implementation
10.Understanding and employing the optimal flexible architecture to ease administration, permit flexibility within managing I/O, and to increase the capability to scale the system


Related Discussions:- Describe the responsibilities of the dba and the database

What is a super key, What is a super key? A super key is a set of one o...

What is a super key? A super key is a set of one or more attributes that collectively permits us to recognize uniquely an entity in the entity set.

Define the term multimedia database, Question : (a) Explain with the h...

Question : (a) Explain with the help of appropriate examples the difference between ‘Data' and ‘Information'. (b) A digital image is an array of pixels, where each pixel h

Database application development, The database application project (DAP) fo...

The database application project (DAP) for this assignment consists of the creation of a fully functional Microsoft Access database application for a real client. I recommend you s

RDBMS, DISADVANTAGES OF RDBMS

DISADVANTAGES OF RDBMS

What are the purpose for having variable length records, What are the purpo...

What are the purpose for having variable length records? What kinds of separator characters are required for each? Variable-Length Records - Variable-length records are thos

Fragmentation, let us consider a table having 2200 records and the fixed si...

let us consider a table having 2200 records and the fixed size of the table to be considered as 25.then how many numbers of table is requredto perform horizontal fragmentation

What create when a primary key combined with a foreign key, What will be cr...

What will be create when a primary key if combined with a foreign key? A primary key if combined with a foreign key it creates Parent-Child relationship between the tables that

State about the tables- DBMS, State about the Tables- DBMS Data is sto...

State about the Tables- DBMS Data is stored in columns and rows (much like a spreadsheet -main difference is how data is organised). Every row in a table is known as a record

What is derived and stored attribute, What is Derived and stored Attribute?...

What is Derived and stored Attribute? Derived and Stored Attribute - In a few cases, two or more attribute values are associated, for example, Age and BirthDate attributes of a

Statistical analysis of data, An important first step to the statistical an...

An important first step to the statistical analysis of data is to "get to know your data".  The following tasks should contribute to this. (a)   To the right of the dataset cons

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