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
|
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.
|