Consider the following hypothetical scenario

Assignment Help Database Management System
Reference no: EM13946105

Consider the following hypothetical scenario. A hypothetical company has grown substantially using an acquisition strategy. As new companies were acquired, new systems that those companies were using were also acquired. At this point, this company has "one of each" of the core, production system (this could be an ERP, HR/Finance, manufacturing, or any other enterprise-level system.) It is clear to everyone that over time following this strategy created many problems and inefficiencies.

The new CIO and his biker buddy the COO decide to form a Steering Committee to clean up the mess. They involve the key decision makers from their respective organizations and get the commitment from Senior VP of Marketing. The CIO and the COO make it clear that they are the executive co-sponsors of this effort.

The Steering Committee commissions the feasibility study and determines that consolidation of the systems will result in significant operational, support, and licensing savings. It determines that many positions will no longer be needed. It also determines that none of the existing systems are year-2000 (Y2K) compliant.

Meanwhile, the Steering Committee participants spread the word around to their rank and file, and although systems consolidation will mean that positions will be lost, most people feel that "it was about time someone did something about the mess."

The Steering Committee next commissions a market survey to determine commercial availability of a replacement system. Three months are budgeted for the market survey. A consultant is brought in to draft a SRS based on the composite features of the existing systems, new requirements, and Y2K compliance requirements. Working closely with the Operations staff and Information Systems staff, and consulting with the Marketing, the consultant develops the SRS and a request for proposal (RFP). RFP is fielded, responses evaluated, a vendor selected, and a contract negotiated. The project plan for the systems consolidation and replacement is organized into several phases roughly approximating the lines of business. The overall project plan budgets nine months and is scheduled for completion with about three months to spare before the clock strikes midnight on December 31, 1999.

The project is off to a slow start, but the co-sponsors personally "drag" some of the reluctant decision makers to the now regular weekly Steering Committee meetings. Actually, the two sponsors participate in all Steering Committee meetings to ensure that issues are identified, defined, and addressed, and that the necessary resources are made available. Many, many problems are encountered; too numerous to list here. The problems range from the vendor misrepresenting some of the capabilities of the system, lack of certain required functionality, performance issues, platform instability, and on and on...The Steering Committee organizes many swat teams and slowly all issues are overcome: some through fixes and some through workarounds. Almost everyone within the company is aware of this project, and many of the staff are invited by the Steering Committee at one time or another to provide their input to solving some of the issues and problems. Although there appears to be some communication redundancy, overall everyone is "kept in the loop" well and timely.

So how does this hypothetical story end? The project goes over budget and beyond the schedule, but not by much. The expected efficiencies are obtained, although it took a little longer than planned. Some positions are eliminated, but there were no surprises and many were able to transfer elsewhere within the company. Everyone who participated in the project learned a lot.

Would you say that this was a well-managed or poorly-managed system implementation? Identify and discuss at least three specific elements that make it a well-managed or poorly-managed implementation. Be sure to explain why and be specific.

Reference no: EM13946105

Questions Cloud

Define and briefly discuss corporate strategic planning. : Identify and briefly describe the four phases involved in managing a project.
Would this sampling method be considered a cluster sample : Twenty-three faculty members volunteered. Each faculty member gave the survey to all the students in one course of their choosing. Would this sampling method be considered a cluster sample? Why or why not?
How would you describe the shape of the distribution : Draw a relative frequency histogram to describe the distribution of penny ages. How would you describe the shape of the distribution?
Thermal entrance length associated with the highest reynolds : Determine the tube length L that meets a design requirement that the tube be twice as long as the thermal entrance length associated with the high- est Reynolds number of interest. Evaluate water properties at 305 K.
Consider the following hypothetical scenario : A hypothetical company has grown substantially using an acquisition strategy. As new companies were acquired, new systems that those companies were using were also acquired.
What probability that customer arrive within next 0.5 minute : On average 2.4 customers per minute arrive at an airline check-in desk during the peak period. Assume that the distribution of arrivals is Poisson. Then T the time between 2 arrivals will be exponential. What is the probability that a customer will..
Surface heat flux for tube diameters : Consider air flowing in a small-diameter steel tube. Graph the Nusselt number associated with fully devel- oped laminar flow with  constant  surface  heat  flux for tube diameters ranging from 1 µ,m D 1 mm.
What are the most important aspects to monitor your servers : We can all agree that it's important to monitor your servers' performance over time. But, what are the most important aspects to monitor and how often? As a network administrator, how do you best use this information for future planning?
Discuss deleting items from binary search trees : If the item to be deleted is contained in a node with one child, the reference in the parent node is set to reference the child node and the node containing the data item is deleted. This causes the child node to take the place of the deleted node..

Reviews

Write a Review

Database Management System Questions & Answers

  Write a sql query that finds all the job classifications

Write a SQL query that joins two tables in the example database and uses LIKE to restrict record selection. (Use telephone area codes to restrict data.)

  Instructions are executed in the polling loop

Let us have a 20MIPS processor, you have to calculate the percentage of time it spends in busy wait loop of a 75-character line printer, when it takes 2 msec to print a character and a total of 665 instructions require to be executed to print a 75..

  Writing a program to manage a student database

writing a program to manage a student database

  Create an xml representation of data

Create an xml representation of data describing various relational database management systems (e.g. Microsoft SQL Server, MySQL, ...)

  Designing and documenting your system

Create a document named: surnameStudentIDAssign1.doc .  In your document, you must include the following section headings:  System Overview, Class Diagram, Class Descriptions, Testing.

  Creating erd containing order and customer entity

Create ERD containing Order and Customer entity types connected by 1-M relationship from Customer to Order. Select suiatble relationship name using your common knowledge of intersection.

  Explain user activity monitoring

In this lab, you will save user activity data in a database. A record of each user's IP address and the current date and time will be created whenever a user visits the Personnel form.

  Create and input the design of the table

When building a database, you should first create and input the design of the table and reports at the same time. determine the input and then design the tables

  Define the benefits of use-case modeling

Describe the biggest challenge to the successful use of use-case modeling and recommend how to overcome the challenge.

  Describe technology options associated with an edms

Identify and describe the technology options and functionality associated with an EDMS. describe EHR functionality for ambulatory care facilities, considering the key clinical processes performed and data needed in such a facility.

  Illustrate concurrency control method by two phase locking

For each table argue whether or not interference with another transaction is possible. Illustrate concurrency control method using two phase locking.

  Write select statement that returns three columns

Write a SELECT statement that returns three columns: InvoiceTotal From the Invoices table, 10% 10% of the value of InvoiceTotal.

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