Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Altitude Online IS staff are beginning to prepare their databases for conversion to an ERP system. Each Altitude Online regional office maintains its own database

Altitude Online IS staff are beginning to prepare their databases for conversion to an ERP system. Each Altitude Online regional office maintains its own database and database management system (DBMS). In addition to relying on the database for daily operations, regional managers produce weekly, monthly, and quarterly reports that they provide to corporate headquarters in New York.

The new ERP system will eliminate the need for managers to transfer reports, because it will enable executives at headquarters to view real-time data from all regions at any time. Prior to the installation of the new ERP system, databases across the organization must be standardized so that they can be easily merged.

Altitude Online hired a database administrator, Tim Conway, to assist in the transition from multiple, disparate databases to one, central database. Tim has been working with regional IS managers in designing an enterprise data model. Because each regional database model has been serving the needs to the regional offices, Tim’s job mostly involves studying the current database structures, finding commonalities and differences, and discussing which entities and attributes to retain in the new design.

Tim uses entity relationship diagrams to define the logical structure of the database. Based on this structure, and working backward from current report specifications, Tim will design the SQL code required to provide the reports. Through this exercise, Tim confirms that the defined entity relationships are adequate to provide the information needed. Tim’s job requires going back and forth between the business intelligence requirements and the database base model, ensuring that requirements are met.

A considerable amount of data cleanup will be required to eliminate data redundancy across the regional databases and to eliminate outdated records.

All of Tim’s efforts are currently directed at preparing the existing databases for the upcoming major migration. The migration itself cannot commence until the ERP is installed. At that point, depending on the vendor and system selected, various tools and support will be made available to make the transfer a smooth one, without interruption to daily business. Having the data organized and cleaned prior to the move will make the process all the easier.

Questions: 

In a major move such as this, what opportunities can Altitude Online take advantage of as it totally revamps its database system that it perhaps wouldn’t have considered before?

Why do you think Altitude Online is beginning work on its database prior to selecting a HIP vendor?

Step by Step Solution

3.49 Rating (159 Votes )

There are 3 Steps involved in it

Step: 1

Characteristics and Benefits of a Database Managing information means taking care of it in order that it works for us and is beneficial for the tasks we perform By employing a DBMS the knowledge we co... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Project Management in Practice

Authors: Samuel J. Mantel Jr., Jack R. Meredith, Sco

4th edition

470533013, 978-0470533017

More Books

Students also viewed these General Management questions

Question

Calculate the missing values

Answered: 1 week ago