Question

In: Computer Science

Compare Data Administrator and Database Administrator functions. Functions need to be compared

Compare Data Administrator and Database Administrator functions. Functions need to be compared

Solutions

Expert Solution

Solution:

Database Administrator:

The basic role of a Database Administrator is to store and manage the information in the database. They are responsible for reviewing the contents in the database. They are performing all the activities related to maintaining the database and responsible for designing, implementing the database. Also their responsible is to backed up data regularly and prevent from unauthorized access. They are also known as Database Coordinator or Database Programmer.

The different functionalities of a database administrator are maintaining database system software, developing physical database structures and data dictionary.

Data Administrator:

The Data Administrator is responsible for defining data elements, data names and their relationship with the database analyst. The basic responsible is how to install and configure the RDBMS applications and also they have to know the requirements of the software application in terms of functions and assure the data integrity. They are also known as Data Analyst. Following are some basic steps for a Data Administrator,

• Specification of organization data.
• The design and maintenance of data management application.
• Validating the data and files.
• Security of files or databases.

#please consider my effort and give me a like....thank u....


Related Solutions

Database administrators use backups and replication to protect data stored in a database. Compare and contrast...
Database administrators use backups and replication to protect data stored in a database. Compare and contrast the two operations. Describe a business application scenario, and provide and discuss a sample query of a common backup or restore operation.
Compare a data warehouse used for decision support to an operational database. How do the data...
Compare a data warehouse used for decision support to an operational database. How do the data warehouse and the operational database differ in their purpose, their structure, the technology they use, and the way they are managed? Why would a company need both?
Compare the Data Modeling difference between relational database and NoSQL MongoDB.
Compare the Data Modeling difference between relational database and NoSQL MongoDB.
Data Modelling is the primary step in the process of database design. Compare and contrast Conceptual...
Data Modelling is the primary step in the process of database design. Compare and contrast Conceptual data model versus Physical data model. Illustrates with help of example to list down data (entities), relationship among data and constraints on data.
Compare the functions of the small intestine and the large intestine. Why do proteins need to...
Compare the functions of the small intestine and the large intestine. Why do proteins need to incorporate into the triglyceride molecules to form the chylomicrons? Why can’t the chylomicrons move directly into the capillaries like monosaccharides and amino acids?
I need to draw an ER diagram for a future database necessary to hold application data...
I need to draw an ER diagram for a future database necessary to hold application data for students wishing to apply for an internship at a tech company. The students will provide the following information on the application: first name, last name, email, phone number, address, city, state, postal code, major, currently enrolled in school?, expected date of graduation, web framework of choice, list of programming languages in which the student is proficient, SAT score, ACT score, GPA, 4 character...
Database design is the process of producing a detailed data model of database. This data model...
Database design is the process of producing a detailed data model of database. This data model contains all the needed logical and physical design choices and physical storage parameters needed to generate a design in a data definition language, which can then be used to create a database. (Wikipedia). Using a diagram/chart software, elaborate a database design Requirements: Define your database objective Explain your database's type of table relationship Explain and design your database elements and datatypes (tables, fields, etc,)....
Explain the differences between data, Information, and a database. Describe the purpose of a database in...
Explain the differences between data, Information, and a database. Describe the purpose of a database in health care and provide an example of one utilized locally, statewide, and nationally.
When is the conceptual schema of a database changed?- if we update data in the database...
When is the conceptual schema of a database changed?- if we update data in the database -if we alter the logical structure of the database -if we retrieve data from the database -if we alter the storage structure of the database Which of the following has the same meaning as the outer union? Group of answer choices -the left outer (natural) join -the right outer (natural) join -the full outer (natural) join -the inner (natural) join Assume {A, B} is...
Redesigning a database involves the process of reverse engineering a legacy database to create a data...
Redesigning a database involves the process of reverse engineering a legacy database to create a data model. There are a host of software tools available to assist with this process. Identify 2 separate tools that will reverse engineer an existing database. What database management systems (Microsoft SQL, Oracle, MySQL, DB2…) will this system work with (list all that apply)? Briefly describe how the tools work for reverse engineering an existing database and the output that the tool provides.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT