SECTION A COMPULSORY QUESTION (15 marks) QUESTION ONE (15 marks) Case Study CaribAir is a Caribbean airline carrier providing passenger travel and cargo delivery to the USA. The shipper is expected to call in a reservation to CaribAir and provide information on each piece of cargo, namely, the dimensions, description, point of origin and contact information. A record is created in the reservation database once a reservation is made. All cargo must arrive at the Cargo Section within three hours of scheduled flight departure accompanied by a receipt indicating that payments have been made to the airline for this specific service. An agent at the Cargo Section, upon acceptance of the items of cargo and following all security procedures will check the Airline Flight Information System to enquire whether the aircraft has ample space to take the cargo and to confirm the departure time. Once the aircraft can accommodate the cargo, a machine-readable barcode is printed with all the cargo details and the flight information. The machine-readable bar code is attached to each piece of cargo. All pieces of cargo are placed on the conveyor belts and taken to a holding area near the Ramp Section. A manifest providing the details of all items of cargo accepted for air freight must be sent electronically to the Federal Aviation Authority at least 60 minutes prior to departure for all flights to the USA. The supervisor of the Cargo Section is responsible for doing this FAA transmission. Clearance notification from the FAA comes directly to the Cargo Section. If the FAA objects to some aspect of the cargo being shipped, an objection notification is sent to the Cargo Section. Depending on the nature of the objection, personnel from the Cargo Section may remove the particular piece of cargo and notify the shipper of the objection. Prior to departure, a staff member from the Cargo Section will take two copies of the manifest to the supervisor on duty in the Ramp Section. As the cargo is loaded, the bar code reader at the Ramp Section reads the barcode and a shipping record for each item of cargo loaded is created in the shipment database. The ramp supervisor will check-off the items on the manifest and update the shipping database. He will send the copy of the manifest to the supervisor of the Cargo Section and keep the original document. Once the shipment has been loaded onto the aircraft, shippers can log onto CaribAirs website and track their cargo from the shipment database. a) Draw a Context Diagram of the Cargo Shipping Process from the perspective of the Cargo Section at CaribAir. (5 Marks) b) Draw a High-Level DFD of the Cargo Shipping Process from the perspective of the Cargo Section at CaribAir. Include at least FOUR (4) sub-processes on your diagram. (10 Marks) SECTION B DO THREE QUESTIONS (45 marks) QUESTION TWO (15 marks) (a) Draw the initial full Decision Table to represent the following case. SWL customers will get a special 50% discount certificate provided that they have requested a catalogue, made an order in the past two years or registered on SWL's website or both. Those customers who did not qualify for the special 50% discount certificate but who registered on the SWL website will receive a 25% discount certificate. In all other cases, the customer will have to pay the full price. (6 marks) (b) Draw the Reduced Decision Table to represent the combined rules of the case given in (a) above. (5 marks) (c) Show all working used to derive the Reduced Decision Table. (4 marks) QUESTION THREE (15 marks) a. Complete the diagram above by inserting both the minimum and maximum cardinalities for all relationships. Make sure to state 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: (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. (2 marks) (iii) Construct a current table showing K and the activities on the Critical Paths(s). (3 marks) (iv) Determine the least cost to reduce the overall project duration by one (1) week. Which activity or activities would you cut? (6 marks) Start Node End Node Activity Name (T) in Weeks (M) in Weeks Cost $ 1 2 A 8 2 600 1 3 B 4 4 1000 2 3 C 4 3 600 2 4 D 7 4 600 3 5 E 7 5 750 4 6 F 4 6 1500 4 5 G 4 5 500 5 6 H 5 2 700 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) b) A Systems Analyst should always prepare alternative systems recommendations to help Management decide which system to pursue. Give three (3) reasons why this is considered necessary. (7 marks)