SECTION A COMPULSORY QUESTION (15 marks) QUESTION ONE (15 marks) CASE SCENARIO A hotel launches its online check-in system (OCS) which allows preferential guests to commence check-in prior to arrival and without the assistance of its Front Desk or other Check-In personnel. Seven days prior to guests visits, they will receive an e-mail from the system inviting them to check-in at the hotels Web site and to confirm reservation. Via the Web, the guest would enter card information, and personal preferences including specific room location, and the need for high speed Internet access etc. Upon arrival at the hotel there is a kiosk at the check-in lounge which prompts the guest to insert a credit card or frequent guest card. OCS decodes the card information, accesses the Reservation database and displays the previously Web-entered guests reservation and preferences. Upon the guests modification/confirmation of the data displayed, the system checks the hotels Customer Relationship Management System (CRMS) to determine if the guest is a preferential customer. The CRMS is not managed by Front Desk or other Check-In personnel. Once preferential status is determined, OCS communicates with the hotels Property Management System (PMS) for room accessibility and availability information. OCS then assigns a room based on the customers preferences and preferential status. The system then encodes and issues the room key and dispenses a printed receipt which informs the guest of his/her room number, room rate, room directions and optional CRMS message. a) Draw a Context Diagram of the hotels Check-In Process from the perspective of the online check-in system (OCS). (5 marks) b) State the main sub-processes mentioned or inferred from the case for a High Level Diagram of the hotels Check-In Process from the perspective of the online check-in system (OCS). (2 marks) c) Draw a High Level Diagram of the hotels Check-In Process from the perspective of the online check-in system (OCS). (8 marks) SECTION B DO THREE QUESTIONS (45 marks) QUESTION TWO (15 marks) a) Draw the initial full Decision Table to represent the following case. MGMT2005 is a prerequisite course for the online course MGMT3011. If a student is successful in the Midterm Project, he can register for MGMT3011, provided he has passed both the course E-Quiz and the final exam. If he is successful in the Midterm Project but has failed the course E-Quiz, he can still register for MGMT3011, provided he has passed the final exam. If he fails both the course E-Quiz and the final exam, he has to repeat the MGMT2005 course. If he fails the final exam but passes the course E-Quiz, he is allowed to take an oral examination only if he is successful in the Midterm Project. If he is not successful in the Midterm Project and fails either the course E-Quiz or the final exam, he must repeat the course. In all other cases, he is allowed to take an oral examination. (6 marks) b) Draw the Reduced Decision Table to represent the combined rules of the case given in (a) above. (6 marks) c) Show all working used to derive the Reduced Decision Table. (3 marks) QUESTION THREE (15 marks) a. Make assumptions necessary to complete the diagram given above with both the minimum and maximum cardinalities for all relationships. List ALL assumptions made. (4 marks) b. For each entity in the E-R diagram, provide four (4) attributes, one of which must be clearly marked as the primary key attribute. (4 marks) c. For the relationships in the E-R Diagram, show the database tables for a relational database design. (7 marks) QUESTION FOUR (15 marks) Using the information in the table below: Start Node End Node Activity Name (T) in Weeks (M) in Weeks Cost $ 1 2 A 7 3 1200 2 3 B 2 4 800 2 4 C 9 2 600 3 5 D 6 4 1200 4 5 E 10 2 400 5 6 F 5 1 150 (i) Draw the PERT diagram showing the ECT (earliest completion time) and LCT (latest completion time) for each event. (4 marks) (ii) Show the Critical Path(s) using the All Paths method. (1 marks) (iii) Construct a current table showing K and the activities on the Critical Paths(s). (2 marks) (iv) Determine the least cost to reduce the overall project duration by two (2) weeks. Which activity or activities would you cut? (8 marks) QUESTION FIVE (15 marks) a) Describe the term packaged software. State and discuss two (2) advantages and two (2) disadvantages of using packaged software. (8 marks) a) Describe requirements prototyping and evolutionary prototyping. State and discuss one (1) disadvantage of each of these two types of IS prototyping. (7 marks)