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

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

Need your ASSIGNMENT done? Use our paper writing service to score better and meet your deadline.


Click Here to Make an Order Click Here to Hire a Writer