Describe the roles of a data administrator (da)

Assignment Help Basic Computer Science
Reference no: EM13983436

The current database that your company is using keeps track of all of the customers and suppliers as well as products offered for sale, but the current environment has all of this data spread out across multiple different databases and it is difficult to see a complete picture of the environment. You have been tasked to consolidate the environment into a single database environment with the end goal of adding a data warehouse for the company.

Your manager is excited with the project description, is anxious to have a new database built for the company, and more excited that at the end of the project he will also have a data warehouse to help make strategic decisions. To start, your manager would like to understand the benefits of following a formal design methodology, especially with respect to database design. Describe how and why the company can benefit from spending time planning at the beginning of the project, instead of just jumping in and developing the applications to meet the perceived needs. To ensure that you give the best response, you choose to describe the 3-level ANSI-SPARC architecture and want to make sure you discuss how the use of this will promote data independence to save time in the long run.

You also want to take this opportunity to answer any potential questions about personnel needs with this new database environment. Describe the roles of a data administrator (DA) and a database administrator (DBA); describe the job functions of each and how the tasks they each perform differ. Would you recommend that your company has one person to perform both tasks, or should it hire two people?

Your paper should contain the following information:

Describe the 3-level architecture.

Describe data independence.

Talk about the differences between a DA and a DBA.

Discuss the pros and cons of having a separate DA and DBA or the need for 1 person doing it all.

2-3 pages of content APA formated with references

Reference no: EM13983436

Questions Cloud

How far away is the platform from the right end of the pool : Sandy is now given a 10.0 kg lead weight to throw. On land, She can throw it 4.50 m. If she again stands at the left end of the untethered platform and throws the weight to the right, exactly where docs it land relative to the right end of the pla..
Describe and explain the relationships among morality : Search the Internet to find an example of a hacking activity or situation that represents a morally, ethically, or criminally ambiguous situation but is different from any examples you used in other assignments for this course.
What is meant by intermediate punishments : What is meant by intermediate punishments and what programs are included in this category? How do intermediate punishments serve to keep down prison populations? Why has electronic monitoring proven so popular
Analysis of the current trends in macro business environment : You have been asked by the client to produce a short report that includes an analysis of the current trends in the macro business environment, and to identify the key opportunities over the next 3-5 years.
Describe the roles of a data administrator (da) : You also want to take this opportunity to answer any potential questions about personnel needs with this new database environment. Describe the roles of a data administrator (DA) and a database administrator (DBA); describe the job functions of ea..
Can gigi sue chow ltd for compensation for her illness : Gigi is an employee of Shiba Pty Ltd. Shiba Pty Ltd operates a factory that manufactures S20L16U8G23. S20L16U8G23 is a nitrogen-based chemical widely used in plastics manufacturing. Can Gigi sue Chow Ltd for compensation for her illness
Describe the upgrades necessary to improve the network speed : Perform an analysis of the current network, and describe the upgrades necessary to improve the network speed, security, and capacity sufficient for future growth.
Discuss role of the family in the rehabilitation process : What is the optimal relationship for a probation officer to have with an involuntary client and the client's family? Discuss the importance of the role of the family in the rehabilitation process
What would the length of the string be : A surfboard of mass S rests on a frictionless surface. The surfboard is attached to a spring (constant K) which is in turn attached to an immobile wall. The surfboard is displaced a distance of C from equilibrium and then is released.

Reviews

Write a Review

 

Basic Computer Science Questions & Answers

  What software must be considered to provide adequate

Based on the Vosevich (2012) article, what software must be considered to provide adequate security and risk management across the enterprise?

  Show how mips can implement the instruction swap

Show how MIPS can implement the instruction swap $rs $rt, which swaps the contents of registers $rs and $rt. Consider the case in which there is an available register.

  How to use dynamic programming to optimally make change

Consider a coin system for which we know the greedy algorithm would fail to always provide optimal change: d = [1,5,8] . Show how to use dynamic programming to optimally make change for 10 units.

  Discuss how the use of computers and technology have change

The four management tasks (planning, organizing, directing, and evaluating) existed long before computers.

  Prepare and submit a proposal to bill to business plan

prepare and submit a proposal to bill that gives your suggested solution to his business plan. provide bill with the details of what he needs to purchase in order to have what he needs to conduct his business using today's technology

  Write an application for the summerdale condo sales

Write an application for the Summerdale Condo Sales office; the program determines the price of a condominium. Ask the user to choose 1 for park view, 2 for golf course view, or 3 for lake view. The output is the name of the chosen view as well as th..

  Discussion focuses on optimization

Discussion focuses on optimization

  Using the sql server diagramming tools

Implement the data model below in your database, using the SQL Server diagramming tools. Implement the data model EXACTLY as it is shown. The Table names, field names, data types, nullable fields, keys, and relationships all need to be exactly ..

  Calculate fourier transform of function

Given a function f(x) as follows: f(0) = 2, f(1) = 3, f(2) = 5, f(3) = 4. Calculate the Fourier Transform of f(x), i.e: F(0), F(1), F(2) and F(3)!

  Using information in the lesson 09 online content

Using information in the Lesson 09 Online Content

  Which of the following baseband technologies

The IEEE 802.3u standard identifies which of the following baseband technologies

  How much memory is required to store picture

A 1024*768 image is displayed, noninterlaced, at a rate of thirty frames per second. If the image is stored with 64k-color resolution, which uses 2 bytes per pixel, how much memory is required to store the picture?

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