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

  Explaining content of document in natural language

Explain the content of this document in natural language;Design the graph representation of document;

  What is the note about loretta swits character in mash

What is the note about Loretta Swit's character in MASH and Who were the two leading men who played the leading role in Bewitched

  Create two uml diagrams showing a conceptual view

Create two (2) UML diagrams, one (1) showing a conceptual view and one (1) showing a process view of the architectures for each of the two (2) following systems (for a total of four [4] diagrams) through the use of Microsoft Visio

  Scanner object associated with standard input

Assume that name1, name2, and name3 have been declared and use them in your code. Assume also that stdin is a variable that reference a scanner object associated with standard input.

  Management studio for database design

1.Use the Management Studio to create a new database called MyWebDB using the default settings. (Ifthe database already exists, use the Management Studio to delete it and then recreate it.) 2. Use the Management Studio to create the following tables ..

  Implement the entity relationship model

Implement the entity relationship model provided in the sample solution of Assignment - Map the ERD into a set of relations in at least Third Normal Form (3NF). You must ensure that your relations meet 3NF. There is no need to show your working.

  Identify department store transactions that can be stored

Identify the potential sales and department store transactions that can be stored within the database. Justify how Big Data tools could be used for forecasting sales and inventory of the department store.

  Designing of database

a. Discuss the degree to which you believe the Visio diagram reflects the database design. b. Describe any assumptions that you had to make about the business rules to in order to create the Visio diagram and the associated relationships.

  Indicate change to make original premiere products database

Indicate the changes (using the shorthand representation) that you would need to make to the original premiere products database desing to support the following requirements.

  Justify a question on database management

When a student has not chosen a major at a university, the university often enters a value of "Undecided" for the major field. Is "Undecided" a way to represent the null value? Should it be used as a default value? Justify your answer carefully.

  Design an entity-relationship model of the problem

You are required to design an entity-relationship model of the problem, convert the model into a relational model, and assess the normal form of each schema.

  List the steps that are needed to pick a proper dbms

List the steps that are needed to pick a proper DBMS. Once the database is set up, describe the separation between users and database administrators. Explain which specific DBMS is most appropriate for your chosen organization, and why

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