QUESTION 10 The Moose Wings Cooperative Flight Club owns a n

QUESTION 10 The Moose Wings Cooperative Flight Club owns a number of airplanes and gliders. It serves fewer than 2,000 members, who are numbered sequentially from the founder, Tom Eagle (0001), to the newest member, Jacques Noveau (1368). Members rent the flying machines by the hour, and all must be returned on the same day. The following six records were among those entered for the flights taken on September 1, 2010: Flight DatePlane Takeoff Landing Member #MMUDDNYI Used time time 8:46 8:49 10:23 3:42 5:42 1:59 12:43 12:29 15:32 Record 1234 1210 0023 012A 0999 9/1/2010 L 15:31 13:45 Valid plane codes (plane used column): C . Cessna, G = glider, L = Lear Jet, P Piper Cub) Match Each Application Control with the field that it should be applied to prevent data errors to occur A. Takeoff Time B. Member # C. Flight Date D. Plane Used E Landing Time Vaidation citeria 1 and 1368 Click Save and Submit to save and submit. Click Save All A to saue all answers. Save All A

Solution

IN THE GIVEN SCENERIO THERE ARE VARIETY OF ERRORS,CHECK THE ERRORS AND THEN SUGGEST POSSIBLE CONTROLS.

a.Errors in the data from the scenario are:

Members-should be numberes between 0001 to 1368

Flight date -shpuld be 09/01/10.

plane used-should be from the allowable group of planes.

take of and landing time-should be logical and the takeoff need to occur before landing.

B.THE FOLLOWING INPUT EDIT CONTROLS SHOULD BE PUT IN PLACE FOR EACH FIELD TO LIMIT THE AMOUNT OF ERRORS.

Members

Flight Date

plane used

take off and landing times

C.CONTROLS THAT COULD BE PUT INTO A SPREADSHEET IONCLUDE THE FOLLLOWING:

D.OTHER CONTROLS THAT COULD BE PUT IN PLACE TO REDUCE THE RISK OF INPUT ERRORS INCLUDE: