csc340 Information Systems Analysis and Design page 1 1 2 University of Toronto Faculty of Arts and Science Department of Computer Science CSC340S Information Systems Analysis and Design Spring 2003 John Mylopoulos April May Examination No Aids Allowed Duration 2 hours Make 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 Marks 1 15 2 15 3 15 4 20 5 15 6 10 7 10 Total 100 csc340 Information Systems Analysis and Design page 2 1 2 The Parking Ticket Collection Division Joanne Werke works for the Parking Ticket Collection Division of the Police Department Her job is keeping track of the unpaid and paid parking tickets issued by the Police Department When she comes to work in the morning the first job that she must do is build a record of the tickets that were issued on the previous day This is brought to her desk by one of the couriers from the Meter Maid section of the Police Department They arrive at 8 15 am just fifteen minutes after Joanne has begun work Occasionally a packet of tickets also arrives from the Security Department of the University This packet usually arrives at about 9 00 am and contains the tickets that have been issued that week by the University It s arrival is irregular and usually dependent on a decision of the Security Department to crack down on illegal parking on campus Joanne can be certain that packets will 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 two weeks 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 University issued tickets they are assigned a different sequencing number so that Joanne does not have to wait until they arrive Then Joanne processes each ticket individually She uses the information on the ticket for three different logs that she has been asked to keep and also fills out an unpaid ticket form The logs she keeps 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 each officer It is used in personnel evaluations and in assessing the viability of the ticket issuing routes given to the officers The log contains the name of each officer the officer s personnel number and a daily record of the the types of tickets issued The log looks as follows Officer Jake Cartwheel P 406 567 908 Day Violation A Jan 28 2003 34 Jan 29 2003 21 Violation B 2 5 Violation C 12 28 Violation Q 1 0 The Projected ticket revenue log is a Lotus 1 2 3 Spreadsheet that is used to project the revenue that will come in from the payment of the parking ticket It looks as follows Day January 28 2003 Ticket No Violation Type Due Date 123456 Q 3 2 03 678901 A 3 2 03 TOTAL Amount Out of Prov 30 00 1 20 00 0 Expected Revenue 6 00 18 00 320 246 00 12 Only 20 percent of out of province issued tickets are paid This is taken into account in the final total In addition 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 their record 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 seems redundant to her She doesn t see why they can t just use the information in the unpaid ticket forms which she also brings them copies of The Violation Type Log is a handwritten log that is tabulated approximately once per month Joe Schup from the Planning Department calls up a day in advance and asks Joanne to perform the tabulations He then picks up the log and takes it to a planning meeting returning it at the end of the day Joanne is not sure what the information is used for but wishes they would be more careful about spilling coffee on her carefully kept log She also wishes that Joe would give her more warning because she already has to work late 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 1 2 VIOLATION TYPE LOG Date 25 1 03 26 1 03 27 1 03 Violation A 23 43 45 Violation B 45 40 45 Violation C 65 56 108 Violation Q 1 2 3 Joanne 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 The parking 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 Motor Vehicles She types in the license number of the vehicle that has been issued a ticket The database then prints out the vehicle owner more detailed information on the vehicle and the owner s address If the vehicle has been stolen or used in a crime the database will also print out this information Unpaid Ticket Form Ticket No Date of Issue License No Vehicle Owner Address City Prov Postal Code Where Issued Officer Name Type Violation Officer No Amt Due Issued Ticket Date Officer Name Officer No Location License No Vehicle Desc Type Violation A B C Q Note The above description is complex may leave details out and supply unnecessary information You will need to make some assumptions about the problem for the parts below MAKE SURE you write your assumptions down csc340 Information Systems Analysis and Design page 4 1 2 1 Entity Relationship Diagrams 15 marks Draw an Entity Relationship diagram that represents the information about tickets issuing officers vehicles owners and payments Your solution should be an Entity Relationship diagram N O T a UML class diagram csc340 Information Systems Analysis and Design page 5 1 2 2 Sequence Diagrams 15 marks Draw a sequence diagram that describes the processing of tickets at the Parking Ticket Collection Division Your diagram should include Joanne the Tickets Division the Accounting Department Joe Schup and the Department of Motor Vehicles database You can ignore University issued tickets csc340
View Full Document
Unlocking...