The following product backlog (shown on the next page) consists of three epics, containing a total of eighteen user stories. Using that product backlog, plan the release in hybrid fashion by initially allocating stories to sprints. Use the following assumptions: (1) The team can complete up to ten ideal developer days of work per sprint. (2) EPIC2 is the highest priority, then EPIC1, then EPIC3. (3) Within an epic, ensure the MH stories are created first, then SH, then NH. (4) If a story is a lower priority than MH but an MH story is dependent on it, then promote that lower priority story so that the MH story can be created. TIM 58 Winter 2023  Final Exam 2 1.1 For each story, fill in the planned sprint numbers (1, 2, 3, etc.) in the blank Sprint column. (10 points) 1.2 Show the number of planned ideal days to complete per sprint. (4 points) 1.3 Create an agile release plan (or flight plan). (7 points) 1.4 How many sprints will be required to complete this product backlog if all stories are completed? (2 points) 1.5 How many sprints will be required to complete this product backlog if only the MH stories are completed? (2 points) EPIC Story ID MoSCoW Priority Dependencies Ideal Days Estimate Sprint Epic 1.1 SH 2 Epic 1.2 MH Epic 1.1 3 Epic 1.3 NH Epic 1.2 2 Epic 1.4 SH Epic 1.3 1 Epic 1.5 MH Epic 1.4 2 Epic 1.6 NH Epic 1.5 1 11 Epic 2.1 MH 3 Epic 2.2 MH 2 Epic 2.3 MH 2 Epic 2.4 SH 1 Epic 2.5 SH 2 10 Epic 3.1 MH 1 Epic 3.2 SH Epic 3.1 2 Epic 3.3 MH Epic 3.2 3 Epic 3.4 SH Epic 3.3 2 Epic 3.5 MH Epic 3.4 1 Epic 3.6 SH 1 Epic 3.7 NH 2 12 33 EPIC 1 Ideal Days EPIC 2 Ideal Days EPIC 3 Ideal Days: Product Backlog Ideal Days: Epic 1 Epic 2 Epic 3 TIM 58 Winter 2023  Final Exam 3 Question 2 (25 points) A university dining service cafeteria located on a busy university campus would like to develop its service further and help those diners who want to place their food orders using a web-based or mobile application so that the diners do not have to wait for the preparation of their food in line. Dining service customers will use the application themselves. It applies to four of the stations at the cafeteria: grilled foods, sandwiches, salads, and sushi. The intent is that once a customer has placed the order, she can pick up her meal at a specified time from the cafeteria without any delays. The dining service would also like to improve its customer service with the system, making the customers experience as positive as possible. Thus, think about various details of the food service process that could be improved with the application. 2.1 Develop a casual use case narrative for this situation. (8 points) 2.2 Further develop the casual use case narrative from 2.1 into a fully dressed use case narrative with at least 3 extensions that are compatible with your description. Use the Larman version of a fully dressed use case. (12 points) 2.3 There are, of course, many other goals that the university dining service system could support. The system could allow various aspects of managing a university-specific payment system, managing customer preferences, providing feedback to the employees and management, advertising special deals, particularly for frequent customers, providing nutritional information, and so forth. Create a use case diagram that presents the use case narrative developed in 2.1 and 2.2 in the context of the overall system. Feel free to be innovative and add other functionality that you think could improve such a system. (5 points) Question 3 (25 points) The system sequence diagram from figure 14.10 in your S&T textbook is shown on the next page. 3.1 In 100 words or less describe the difference between a system sequence diagram and a design sequence diagram. (5 points) 3.2 Create a design sequence diagram for the initiatePickUp(orderNbr) message in figure 14.10. Show how the system responds under the condition that an order is not yet ready. Identify the presentation layer, business logic and data layer in your diagram. (8 points) 3.3 Draw a design sequence diagram for the enterQty(qty) message in figure 14.10 ending with the current subtotal response. Include all classes involved in this message and use your knowledge of loops to show how the system handles a situation where the quantity entered exceeds the quantity threshold for the upccode. Also identify which classes are in the presentation layer, business logic and data layer in your diagram. (12 points) TIM 58 Winter 2023  Final Exam 4 Question 4 (25 points): A UML class diagram for an online restaurant ordering system is shown on the following page. 4.1 Overlay packages on the class diagram, selecting classes that are logically closely related. Choose the number of packages that minimizes interactions between packages. (6 points) 4.2 Draw a UML package diagram illustrating the online restaurant ordering system using the packets you identified in 4.1. (4 points) 4.3 Identify the package that contains the Customer class. Draw the relational database table classes for this package identifying all the attributes required for each table. Ensure that the abstract classes include the appropriate attributes. (10 points) 4.4 Now add the data access and manipulation (DAM) classes to the relational database table classes in your diagram from 4.3 (5 points) TIM 58 Winter 2023  Final Exam 5