csc340 Information Systems Analysis and Design page 1/12University of TorontoFaculty of Arts and ScienceDepartment of Computer ScienceCSC340S - Information Systems Analysis and DesignSpring 2003 John MylopoulosApril-May ExaminationNo Aids AllowedDuration: 2 hoursMake sure that your examination booklet has 12 pages(including this one). Write your answers in the space provided.This examination counts for 35% of your final mark.Name: (Please underline your last name)Student Number: Question Marks1. ____________/152. ____________/153. ____________/154. ____________/205. ____________/156. ____________/107. ____________/10 Total ____________/100csc340 Information Systems Analysis and Design page 2/12The Parking Ticket Collection Division. Joanne Werke works for the Parking Ticket Collection Divisionof the Police Department. Her job is keeping track of the unpaid and paid parking tickets issued by thePolice Department. When she comes to work in the morning, the first job that she must do is build arecord of the tickets that were issued on the previous day. This is brought to her desk by one of thecouriers from the Meter Maid section of the Police Department. They arrive at 8:15 am, just fifteenminutes after Joanne has begun work. Occasionally, a packet of tickets also arrives from the SecurityDepartment of the University. This packet usually arrives at about 9:00 am and contains the tickets thathave been issued that week by the University. It's arrival is irregular and usually dependent on a decisionof the Security Department to crack down on illegal parking on campus. Joanne can be certain that packetswill arrive from University Security at the beginning of each term, after Alumni Week and after graduation,but the other times are arbitrary. Sometimes the tickets in the University packet have been issued twoweeks ago and Joanne has already received payment for them.Before processing the tickets, Joanne puts them in order by ticket number. If she is handling Universityissued tickets, they are assigned a different sequencing number so that Joanne does not have to wait untilthey arrive. Then Joanne processes each ticket individually. She uses the information on the ticket forthree different logs that she has been asked to keep and also fills out an unpaid ticket form. The logs shekeeps are: (a) Issuing Officer ticket record; (b) Projected ticket revenue; (c) Violation type summary.The Issuing Officer ticket record is a log of the number and type of parking ticket violations issued by eachofficer. It is used in personnel evaluations and in assessing the viability of the ticket issuing routes givento the officers. The log contains the name of each officer, the officer's personnel number, and a daily recordof the the types of tickets issued. The log looks as follows:Officer: Jake CartwheelP#: 406-567-908Day Violation A Violation B Violation C Violation QJan 28,2003 34 2 12 1Jan 29, 2003 21 5 28 0The Projected ticket revenue log is a Lotus 1-2-3 Spreadsheet that is used to project the revenue that willcome in from the payment of the parking ticket. It looks as follows:Day: January 28, 2003Ticket No. Violation Type Due Date Amount Out of Prov. Expected Revenue123456 Q 3/2/03 $30.00 1 $6.00678901 A 3/2/03 $20.00 0 $18.00…TOTAL $320 12 $246.00Only 20 percent of out of province issued tickets are paid. This is taken into account in the final total. Inaddition, approximately 10 percent of the remaining tickets are never paid. This is also taken into account.At the end of the day, Joanne takes this spreadsheet to the Accounting Department to be used in theirrecord keeping. She is not happy with keeping this log because she has to type in all the ticket numbers.She already has to re-transcribe them in filling out the unpaid ticket form. Typing them in again seemsredundant to her. She doesn't see why they can't just use the information in the unpaid ticket forms whichshe also brings them copies of. The Violation Type Log is a handwritten log that is tabulated approximately once per month. Joe Schupfrom the Planning Department calls up a day in advance and asks Joanne to perform the tabulations. Hethen picks up the log and takes it to a planning meeting, returning it at the end of the day. Joanne is notsure what the information is used for, but wishes they would be more careful about spilling coffee on hercarefully kept log. She also wishes that Joe would give her more warning because she already has to worklate to handle the crunch of tickets that arrive at her desk daily. The Violation Type Log looks as follows:csc340 Information Systems Analysis and Design page 3/12VIOLATION TYPE LOGDate Violation A Violation B Violation C Violation Q 25/1/03 23 45 65 126/1/03 43 40 56 227/1/03 45 45 108 3Joanne also fills out the Unpaid Ticket form. This is attached as is a sample copy of the unpaid ticket.She makes a copy of the Unpaid Ticket form to go to accounting and keeps the original in her files. Theparking ticket is sent to Microfilm to be copied and stored in the Police record microfilm files. To fill out the Unpaid Ticket form, Joanne uses an online database maintained by the Department of MotorVehicles. She types in the license number of the vehicle that has been issued a ticket. The database thenprints out the vehicle owner, more detailed information on the vehicle and the owner's address. If thevehicle has been stolen or used in a crime, the database will also print out this information. Unpaid Ticket FormTicket No. Date of Issue: License No.: Vehicle Owner: Address: City, Prov.: Postal Code: Where Issued: Officer Name: Type Violation: Officer No.: Amt. Due:
View Full Document
Unlocking...