How use of will promote data independence to save time

Assignment Help Other Subject
Reference no: EM132208178

Question: Deliverable Length: 2-3 pages

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.

Reference no: EM132208178

Questions Cloud

Compute straight line depreciation for each year : Expected annual costs of new product and direct materials are $455,000. Compute Straight Line depreciation for each year of this new machine's life
Define change you will need to make in day-to-day activities : Discuss the changes you will need to make in your day-to-day activities managing the network or the tools you will need. Assume the addressing scheme has been.
Identify a corresponding state standard from your state : Explain how the plan is designed to meet the needs of students at varying levels of intellectual, social, emotional, and physical development.
What is the exercise value of the call option : A call option on the stock with a $25 strike price currently sells for $7 (that's the premium.) What is the exercise value of the call option
How use of will promote data independence to save time : 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.
Calculate spot rate implied by the us treasury yield curve : Calculate the 2-year spot rate implied by the US Treasury yield curve data based on two zero coupon US Treasury bonds of 1 and 2 years maturity
How the requirements engineering team worked : You will need to describe how the requirements engineering team worked with the clients to perform project requirements discovery or elicitation.
What steps might have been taken to prevent perpetrating : David Doe is a network administrator for the ABC Company. David is passed over for promotion three times. He is quite vocal in his dissatisfaction.
Write a report explaining the method used to combine : Explain the purpose of (or why) you use this technique and the types of baking equipment used to achieve the results a baker would be looking for.

Reviews

Write a Review

Other Subject Questions & Answers

  Cross-cultural opportunities and conflicts in canada

Short Paper on Cross-cultural Opportunities and Conflicts in Canada.

  Sociology theory questions

Sociology are very fundamental in nature. Role strain and role constraint speak about the duties and responsibilities of the roles of people in society or in a group. A short theory about Darwin and Moths is also answered.

  A book review on unfaithful angels

This review will help the reader understand the social work profession through different concepts giving the glimpse of why the social work profession might have drifted away from its original purpose of serving the poor.

  Disorder paper: schizophrenia

Schizophrenia does not really have just one single cause. It is a possibility that this disorder could be inherited but not all doctors are sure.

  Individual assignment: two models handout and rubric

Individual Assignment : Two Models Handout and Rubric,    This paper will allow you to understand and evaluate two vastly different organizational models and to effectively communicate their differences.

  Developing strategic intent for toyota

The following report includes the description about the organization, its strategies, industry analysis in which it operates and its position in the industry.

  Gasoline powered passenger vehicles

In this study, we examine how gasoline price volatility and income of the consumers impacts consumer's demand for gasoline.

  An aspect of poverty in canada

Economics thesis undergrad 4th year paper to write. it should be about 22 pages in length, literature review, economic analysis and then data or cost benefit analysis.

  Ngn customer satisfaction qos indicator for 3g services

The paper aims to highlight the global trends in countries and regions where 3G has already been introduced and propose an implementation plan to the telecom operators of developing countries.

  Prepare a power point presentation

Prepare the power point presentation for the case: Santa Fe Independent School District

  Information literacy is important in this environment

Information literacy is critically important in this contemporary environment

  Associative property of multiplication

Write a definition for associative property of multiplication.

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