O Unit: ISY201 Systems Analysis and Design Trimester 1 – 2016 Assignment 15% Due in Week 10 Monday 16, 2016 OVERVIEW This is assignment covers chapters 1 to 5 and 9 which include three major topics discussed in this unit; Project Planning, Requirements modelling, Data and Process modelling and Data Design. There are 5 case studies covering these four topics. Answer all the questions listed at the end of each case study. Draw pictures and diagrams if needed. Submit the hard copy of the assignment along with the coversheet to your Lecturer in Week 10 class. Also submit the softcopy of the assignment through my kent or private email addresses. 1. Brightstar Industries- Chap3-: Project Planning –p120 You will lead a training session for new employees at Brightstar Industries. You must develop a specific schedule for the following tasks (the estimated duration is shown in parentheses) First, you need to contact the participants and explain their roles (1 day). Then you must obtain approval from their department managers (3 days). • After you obtain the approval, two tasks can begin at the same time: you can arrange the meeting room (1 day) and prepare an agenda for the initial session (8 days). • When the agenda is ready, you can start two more concurrent tasks: prepare the information packets (3 days) and create visual aids (6 days). • When the meeting room is arranged and the information packets are ready, you can send out an e-mail to participants (1 day). • Finally, after the e-mail is sent to participants and the visual aids are ready, you can conduct the JAD sessions (7 days). Tasks 1. Prepare a list showing all tasks and their durations. 2. Analyze the fact situation carefully to determine which tasks are concurrent and which ones depend on other tasks. 3. Develop a PERT/CPM chart that shows the project. Use a format similar to Figure 3-27 on page 110. Use project management software if it is available. 4. What is the critical path for this project? How do you know? 2. General Hardware Products- Chap4: Requirement Modelling – p168 Your boss, the IT director, wants you to explain FDDs, BPM, DFDs, and UML to a group of company managers and users who will serve on a systems development team for the new marketing system. Tasks 1. Explain how an FDD can be used in requirements modeling. 2. Describe BPM and how it can be used. 3. Explain how DFDs can be used in requirements modeling. 4. Describe the UML and how it can be used during systems development. 3- Kitchen Gadgets- Chap5: Data and Process modelling- p215 Kitchen Gadgets sells a line of high-quality kitchen utensils and gadgets. When customers place orders on the company's Web site or through electronic data interchange (EDI), the system checks to see if the items are in stock, issues a status message to the customer, and generates a shipping order to the warehouse, which fills the order. When the order is shipped, the customer is billed. The system also produces various reports. Tasks 1. List four elements used in DFDs, draw the symbols, and explain how they are used. 2. Draw a context diagram for the order system. 4- Big State University – Chap5 : Data and Process Modelling-p216 The Big State University course catalog reads as follows: "To enroll in MIS 260, which is an advanced course, a student must complete two prerequisites: MIS 120 and MIS 222. A student who completes either one of these prerequisites and obtains the instructor's permission, however, will be allowed to take MIS 260." Tasks 1. Create a decision table that describes Big State University course catalog regarding eligibility for MIS 260. Show all possible rules. 2. Simplify the table you just created. Describe the results. 3. Draw a simplified decision tree to represent the Big State University catalog. Describe the results. 4. Why might you use a decision tree rather than a decision table? 5. Parrot Palace- Chap 9: Data design -p395 Parrot Palace works with TV and movie producers who need birds that can perform special tricks, such as playing dead, reciting poetry, ladder climbs, and various other tricks. Parrot Palace has about 50 birds and a list of 20 tricks from which to choose. Each bird can perform one or more tricks, and many tricks can be performed by more than one bird. When a bird learns a new trick, the trainer assigns a skill level. Some customers insist on using birds that score a 10, which is the highest skill level. As an IT consultant, you have been asked to suggest 3NF table designs. You are fairly certain that an M:N relationship exists between birds and tricks. Tasks 1. Draw an ERD for the Parrot Palace information system. 2. Indicate cardinality. 3. Identify all fields you plan to include in the birds and tricks tables. For example, in the bird table, you might want species, size, age, name, and so on. In the tricks table, you might want the trick name and description. You will need to assign a primary key in each table. Hint: Before you begin, review some database design samples in this chapter. You might spot a similar situation that requires an associative entity that you can use as a pattern. In addition, remember that numeric values work well in primary key fields. 4. Create 3NF table designs. Task 5: Due week 10 Monday 16,2016 Case study – Grand Wines 20% You are an employee of Grand Wines Ltd and project leader of a proposed project to equip each of the company's 20 sales representatives with a wireless data entry device by which they could instantly communicate customer orders to the company's central sales database in Sydney. The sales representatives operate over all areas of NSW and service around 400 independent wine and liquor stores in the state. Currently, the sales representatives complete customer orders manually and after leaving a copy with the customer, they forward the customer orders by mail or fax to the sales department in Sydney, where the orders are entered into the sales database and processed through the inventory system for shipment to the customer. The problems with the current process are: • At least one-day is lost in supplying customers with products because of the delays in getting orders into the system. • Sales representatives do not know the latest inventory position of their products when they accept orders from the customer. Delays in delivery can result when orders are placed on "back-order" because of a lack of stock. • Orders are often "lost" or entered into the sales database incorrectly through human error. • The sales representatives and many customers are dissatisfied with the current situation. Competitive wine companies have improved their order systems and are outperforming Grand Wines Ltd in terms of delivery speed, order accuracy, availability of ordered stock and overall customer satisfaction. Your CEO has stressed the importance of the project to the company and asked you to use your skills as a project manager to make sure the project is successful by following the relevant project management processes. You have been assigned a project leader of this project. Your manager has given you guidance that the project needs to be completed within 6 months and that costs should be minimised wherever possible. Now that the project sponsor has approved your Initial Project Plan and associated documents, you may proceed to the planning phase of the project by providing a formal project report for the project sponsor based on the following project planning documents. You may make any appropriate assumptions needed to enable the successful completion of the project. • Schedule and Gantt chart • Identify at least eight milestones for this project using SMART criteria. • Network Diagram (Critical path diagram) • Resources table • Project budget, • RACI Table • Identify 6 potential risks for this project and write the risk register for all of them. Ensure one of your risks is a positive risk. • Construct the Probability/ Impact Matrix for those 6 potential risks. Marking Criteria Task 1 • Gantt chart is Correct (5 marks) • Time allocated for each tasks and dependencies given makes sense (2 marks) • Allocated resources for each tasks makes sense (1 mark) • No overload of any resources (2 marks) Task 2 • Milestones given make sense (4 marks) • Correctly explained the milestones using SMART criteria (4 marks) • Quality of presentation of answers (2 marks) Task 3 • Critical path duration is realistic (10 marks) Task 4 • Project resource table is correct (8 marks) • Quality of presentation of answers (2 marks) Task 5 • Project budget is realistic (8 marks) • Quality of presentation of answers (2 marks) Task 6 • RACI table makes sense (8 marks) • Quality of presentation of answers (2 marks) Task 7 • Risk registers given are realistic (12 marks) • Risk register format is correct (6 marks) • Quality of presentation of answers (2 marks) Task 8 • Probability/ Impact scores make sense (4 marks) • Probability/ Impact matrix is correct (4 marks) • Quality of presentation of answers (2 marks) END