Written Case Study: Summarize by restating the case in your own words In 1-2 paragraphs highlight the key points (This helps to ensure that you are getting the important points) Problem statement In...

Written Case Study:

1. Summarize by restating the case in your own words
   
   
   1. In 1-2paragraphshighlight the key points (This helps to ensure that you are getting the important points)
   
   
   
   


2. Problem statement
   
   
   1. In 1-2sentences, state what the problem is and what the solution should focus on.
   
   
   
   


3. Recommended Solution and Analysis (Qualitative)
   
   
   1. Provide a recommended solution to the situation.
      
      
      1. Give bothpros and consto the solution
      
      
      2. Recommend implementation considerations
      
      
      3. Document issues or risks
      
      
      
      
   
   
   
   


4. Analysis (Quantitative)
   
   
   1. If numbers are available, use them to reinforce Part 3 above
   
   
   2. Recommend appropriate key performance indicator metrics
   
   
   
   

Note: Document formulas, assumptions or information presented

Additional case specific guidance will be provided in class. Guidance will also be provided on “Things not to do” on the case study deliverables.

Your Individual Case Study deliverable should be between 8-12 pages. However, there is no page count requirement and grades are not highly correlated to number of pages submitted. Remember:Quantity does not equal quality.

5.APA Style citations are required and you should have a minimum of 8 citations

6. Textbook Title:
Fundamentals of Information Systems, 9th Edition byRalph M. Stair; George Reynold

Case study – Unit 3 TECH 5F70 – Foundations of Information Technology and Management Case study – Unit 3 Altitude Online: Using Database and Business Intelligence 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: 1. 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? 2. Why do you think Altitude Online is beginning work on its database prior to selecting an ERP vendor? Outline 1. Altitude Online from its major move can take the following advantages of total revamping of its database system : · View real-time data from all regions at any time · Automatic daily, weekly, monthly reports can be prepared from the real time data · Lessening of efforts in sharing of reports · The new system would help eliminate data redundancy · Easy updation of the outdated records · Better Organisation of Data · Better searching and filtering of content in the database 2. The ERP system will eliminate the need of transfer reports by enable executives at headquarters to view the 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.