Sys & Infrast Lifecycle Mngt 1

MIS5203

Sys & Infrast Lifecycle Mngt 1

MIS 5203.951 ■ Spring 2022 ■ William Bailey

William Bailey

Systems and Infrastructure Lifecycle Management

by

This course will introduce you to the methods used as organizations builds an enterprise information system architecture within an environment of internal control. Topics include information system planning, management and usage, the development, acquisition and maintenance of these technologies and their impact on the organization’s business processes.

Course Objectives

  1. Evaluate the business case for the proposed investments in information systems acquisition, development, maintenance and subsequent retirement to determine whether it meets business objectives.
  2. Evaluate IT supplier selection and contract management processes service levels and requisite controls are met.
  3. Evaluate the project management framework and controls to determine whether business requirements are achieved in a cost-effective manner while managing risks to the organization.
  4. Conduct reviews to determine whether a project is progressing in accordance with project plans, is adequately supported by documentation, and has timely and accurate status reporting.
  5. Evaluate controls for information systems during the requirements, acquisition, development and testing standards, procedures and applicable external requirements.
  6. Evaluate the readiness of information systems for implementation and migration into production to determine whether project deliverables, controls and the requirements are met.
  7. Conduct post-implementation reviews of systems to determine whether project deliverables, controls and the requirements are met.

 

 

Unit Assignment

by

Instructions: In this assignment you will leverage what you have learned about data requirements modeling and database design from MSAD’s Chapters 8 & 9.  In this assignment you are provided a scenario describing the business process of a fictional package delivery service (a courier company) called On the Spot Courier Services.

Study the scenario and then using Visio’s Crow’s Foot Database Notation Shapes create an entity-relationship database model that shows the relationship between the various data entities that should be included in the package tracking and delivery system.  Your diagram should include at least 6 data entities and show the relationships among them using the crows foot notation.

  1. Use the noun technique and identify all the entities and their attributes that are important for this system.
  2. After you identified the entities determine what the relationships should be among the entities. Add multiplicity constraints, being especially cognizant of zero-to-many versus one-to-many differences.
  3. Finalize the database model by including all the necessary tables, attributes, primary keys, relationships, and multiplicity constraints.

By the Due Date (published on Canvas) submit your Visio diagram to Unit#8 Assignment in Canvas as a PDF formatted file with the following naming convention of Unit8_YourName_DatabaseModel.pdf.   

Scenario:

When Bill got an order, at first, only on his phone, he recorded when he received the call and when the shipment would be ready for pickup. Sometimes, customers wanted immediate pickup; sometimes, they were calling to schedule a later time in the day for pickup.

Once he arrived at the pickup location, Bill collected the packages. It was not uncommon for the customer to have several packages for delivery. In addition to the name and address of the delivery location, he also recorded the time of pickup. He noted the desired delivery time, the location of the delivery, and the weight of the package to determine the courier cost. When he picked up the package, he printed out a label with his portable printer that he kept in the delivery van.

At first, Bill required customers to pay at the time of pickup, but he soon discovered that there were some regular customers who preferred to receive a monthly bill for all their shipments. He wanted to be able to accommodate those customers. Bills were due and payable upon receipt.

To help keep track of all the packages, Bill decided that he needed to scan each package as it was sorted in the warehouse. This would enable him to keep good control of his packages and avoid loss or delays.

The delivery of a package was fairly simple. Upon delivery, he would record information about when the delivery was made and who received it. Because some of the packages were valuable, it was necessary in those instances to have someone sign for the package.

On the Spot courier services grew and changed over the years. At first, Bill received requests for package pickups on his mobile phone, recorded that information in a log, and would then drive around to retrieve all the packages later in the day. However, he soon discovered that with another driver, it was difficult to coordinate pickups between the two of them from his van. It was not long before he reorganized his business and turned the warehouse employee into a driver. Then, he stayed in the warehouse himself, and his two employees made all the pickups and deliveries. This worked well because he could control and coordinate the pickups and deliveries better. It was also easier for him to receive pickup requests working at a desk rather than trying to do it while driving a delivery van.

As he thought about how his business was growing and the services he provided to his customers, Bill began to itemize the kinds of information he would need to maintain.

Of course, he needed to maintain information about his customers. Some of his customers were businesses; some were individuals. He needed to have basic address and contact information for every customer. Also, for his corporate customers, he needed to identify a primary contact person. It was mostly his corporate customers who wanted to receive monthly statements listing all their shipments during the month and the total cost. Bill needed to distinguish which customers paid cash and which wanted monthly statements. In fact, for those that paid monthly, he needed to keep a running account of such things as when they were last billed, when they paid, and any outstanding balances. Finally, when payments were received, either for individual shipments or from monthly invoices, he needed to record information about the payment: type of payment, date, and amount. Although this was not a sophisticated billing and payment system, Bill thought it would suffice for his needs.

Next, he started thinking about his packages and shipments. At the time that a request for a pickup came in, he needed to keep track of it as some type of delivery request or delivery order. At that point in time, Bill mostly needed to know who the customer was, where the pickup location was, and what date and time the package(s) would be ready for pickup. He also recorded the date and time that he received the order. A delivery order was considered “open” until the delivery van arrived at the pickup location and the packages were all retrieved. At that point, the delivery order was satisfied.

Once the packages were retrieved, each package needed to be uniquely identified. Bill needed to know when it was picked up and which delivery person picked it up. Other important information was the “deliver to” entity name and the address. He also needed to identify the type of delivery. Some packages were high priority, requiring same-day delivery. Others were overnight. Of course, the weight and cost were recorded so the customer could either pay or have it added to the monthly invoice.

In the courier and delivery business, one of the most important information requirements is the date and time stamp. For each package, it is important to know when it was picked up, when it arrived at the warehouse, when it went back out on the delivery run, and when it was delivered. When possible, it is also important to have names associated with each of these events.

All Questions – Submit Answers in Canvas as PDF Document

by

Please answer the following PROBLEMS AND EXERCISES from our textbook “Modern Systems Analysis and Design” (MSAD). Submit your write-up as a PDF file via Canvas, by the due date published. Be sure to put your name on top left of document, and the question number for each of your answers next to each of your answers.

7.32

(MSAD 8e p. 210)

(MSAD 9e p.206)

Other Editions: Follow Provided Instructions

Choose a transaction that you are likely to encounter, perhaps ordering a cap and gown for graduation, and develop a high-level DFD or a context diagram. Decompose this to a level-0 diagram

7.35

(MSAD 8e p.210)

(MSAD 9e p.206)

Other Editions: Follow Provided Instructions

Refer to Figure 7-23, (viewable from Community Web Site) which contains drafts of a context and level-0 DFD for a university class registration system. Identify and explain potential violations of rules and guidelines on these diagrams. 

7A.2

(MSAD 8e p.235)

Other Editions – Follow provided instructions.

Draw an activity diagram that models the reimbursement process described below. Use one swimlane for each of the three actors in the process.

The travel reimbursement process for employees of West Nile Valley University involves three different actors: the employee, the employee’s departmental secretary, and the treasurer’s office. First, the employee has to gather and prepare all of the receipts the university requires for reimbursement. At the same time, she completes the official reimbursement form. She then submits both the receipts and the form to the departmental secretary. If something on the form is incorrect, the secretary returns the form to the employee for correction. If the form is correct, the secretary prepares a form required by the university. That form is then submitted to the treasurer’s office. The treasurer’s office then enters the amount to be reimbursed into the university’s system. The employee is then asked to review the reimbursement amounts. If the amount shown is not correct, the employee must indicate that this is the case. If the amount shown is correct, then the treasurer’s office sends the reimbursement to the employee’s bank, completing the process.

7C.9

(MSAD 8e pp. 244-245)

Other Editions – Follow provided instructions.

Draw a use case diagram for the following situation (state any assumptions you believe you have to make in order to develop a complete diagram). Then convert the use case diagram into a sequence diagram

Stillwater Antiques buys and sells one-of-a-kind antiques of all kinds (e.g., furniture, jewelry, china, and clothing). Each item is uniquely identified by an item number and is also characterized by a description, an asking price, and a condition as well as open-ended comments. Stillwater works with many different individuals, called clients, who sell items to and buy items from the store. Some clients only sell items to Stillwater, some only buy items, and others both sell and buy. A client is identified by a client number and is also described by a client name and client address. When Stillwater sells an item in stock to a client, the owners want to record the commission paid, the actual selling price, the sales tax (tax of zero indicates a tax-exempt sale), and the date the item sold. When Stillwater buys an item from a client, the owners want to record the purchase cost, the purchase date, and the condition of the item at the time of purchase.

All Questions

by

  1. Which of the four phases of the project management process do you feel is most challenging?  Why?
  2. What are sources of risk in a system analysis and design project?
  3. How does a project manager cope with risk during the stages of project management?

The following question will be answered as an Assignment in Canvas:

4, A project has been defined to contain the following list of activities along with their required times for completion:

Activity No. Activity Time in Weeks  Predecessors
1 Collect requirements 3
2 Analyze processes 2
3 Analyze data 2 1
4 Design processes 6 2
5 Design data 3 3
6 Design screens 2 3, 4
7 Design reports 4 4, 5
8 Program 5 6, 7
9 Test and document 7 7
10 Install 2 8, 9

4.A Draw a network diagram for the activities

4.B Calculate the earliest expected completion time

4.C Show the critical path

4.D What would happen if activity 6 were revised to take six weeks instead of two weeks?

4.E Construct a GANTT chart for the project (with tasks as specified in the table above)

4.F Look again at the activities and create a new diagram that is updated to reflect the following: Your team is in first week of the project and has discovered that each of the activity duration estimates is wrong. Activity 2 will take only one week to complete. Activities 4 and 7 will each take three times longer than anticipated. All other activities will take twice as long to complete as previously estimated. In addition, a new activity number 11 called “Stabilization”  has been added. It will take one week to complete, and its immediate predecessors are activities 10 and 9. Adjust the network diagram and recalculate the earliest expected completion times.

Question 4

by

The following question will be answered in Canvas.

A project has been defined to contain the following list of activities along with their required times for completion:

Activity No. Activity Time in Weeks  Predecessors
1 Collect requirements 3
2 Analyze processes 2
3 Analyze data 2 1
4 Design processes 6 2
5 Design data 3 3
6 Design screens 2 3, 4
7 Design reports 4 4, 5
8 Program 5 6, 7
9 Test and document 7 7
10 Install 2 8, 9

Using Visio and/or Project, (contact Nishit Derade tuk05160@temple.edu for help obtaining and/or installing) or any other drawing tool of your choosing, create a PDF and upload to Canvas in Assignment Unit#4.3 with the following:

4.A Draw a network diagram for the activities

4.B Calculate the earliest expected completion time

4.C Show the critical path

4.D What would happen if activity 6 were revised to take six weeks instead of two weeks?

4.E Construct a GANTT chart for the project (with tasks as specified in the table above)

4.F Look again at the activities and create a new diagram that is updated to reflect the following: Your team is in first week of the project and has discovered that each of the activity duration estimates is wrong. Activity 2 will take only one week to complete. Activities 4 and 7 will each take three times longer than anticipated. All other activities will take twice as long to complete as previously estimated. In addition, a new activity number 11 called “Stabilization”  has been added. It will take one week to complete, and its immediate predecessors are activities 10 and 9. Adjust the network diagram and recalculate the earliest expected completion times.

(Be sure to put your name at the top left hand corner of your Assignment 3 document and add the title to the document “Unit#4 Question 4”. Name the file Unit#4-Question4_YourName.pdf and upload to Canvas.)

Case Study 2 – All Questions

by

Post your answers to the following Case Study questions on Canvas, by the published due date.

  1. What are the positive benefits (“pros”) and risks (“cons”) of a buy versus build decision on the ES Package?
  2. What implementation challenges might Sebastian Joseph face in relation to training and change management?
  3. What the pros and cons of outsourcing IT infrastructure and software module development versus owning and developing them in-house?