Turgut Tezir CS 606 Dr. Bellehsen CASE STUDY III The State Patrol Ticket Processing System 1. State Patrol Ticket Processing System: (SPTPS) records driver violation (fines paid by drivers) by the cord notify court if driver didn’t pay the fines on time. (If driver didn’t pay the fines) arrest driver. report (accident & tickets) driver’s record to Insurance company 1. renews driver’s license. 2. suspend driver’s license. (State Patrol ticket Processing System report to insurance companies’ drivers’ ticket and accident. State Patrol renews or suspend drivers license. Fines paid by driver. Cord decide if the driver guilty. Cord decides to arrest driver if the fines not paid.) Events
Trigger
1.SPTPS records driver violation 2. SPTPS notify driver violation to court.
violation Drivers mistake fines Late or unpaid fines Unpaid SPTPS or late record fines of the driver
3. SPTPS notify driver violation to court to arrest driver by the court decision if driver didn’t pay the fine 4. SPTPS report driver violation to insurance.
Source
Essential Activity Fines
Response
Destination
ticket
Arrest or pay the fines Arrest driver
Driver’s reasoning
Jail or pay fines Jail or pay fines
Fines
jail
violation Driver’s Renew or mistakes suspend driver license
Increase driver’s insurance
License
2. Officer
gives Record DB System
Ticket
Notify
receive
Driver
Other StatePatrol Suspend
Increase
Add
Raised
Many violations Court
Sent
Record
Insurance Notify
Driver didn’t pay the fee
Arrest
1. Officer gives ticket to driver. 2. Officer turned in the copy of the ticket to enter the system. 3. ticket creates driver record (officer, cord include) 4. Drivers mail the ticket. 5. Driver’s claims he is innocent and want court date about a ticket. 6. Ticket returns without a check. System notes the plea on the ticket record 7. Systems report the unpaid ticket to the court. 8. Questioner mail to do driver about ticket. 9. Drivers mail back to questioner to the court 10. Court schedule appropriate date for triad date
11. Court notified driver about the triad date 12. Court sent the verdict to ticketing system after triad finish. 13. Verdict and triad recorded for the ticket. 14. System report drivers insurance company if the driver innocent 15. Insurance company ignores the ticket. 16. Court gives ticket to the driver if the drivers guilty 17. if the driver doesn’t paid the ticket, ticket processing system sent warrant to the court.(two weeks after triad date) 18. Court suspends drivers’ license. 19. System Process handless the suspension.
3. Ticket Processing System Database Driver data Officer data License Name number Address of Name the office Address Date of birth Date license
Court data Name Address
Ticket data (System creates it) Ticket number ( unique) Location Ticket type Ticket date Ticket time Plea Trial date Verdict Fine amount Date paid
Data IdNo LName FName Address Tell_No
Officer data D_IdNo Skill_No Class_No
Licence A (Operator) D_IdNo ConstractionCA
Driver Data D_IdNo D_Birth Licence_No Licence_Date Vehicle_No Wheel_Num
Licence B(Truck) D_IdNo RoudNo
Court data D_IdNo Type_No
Ticket data IdNo Location_No Ticket_Type Ticket_Date Ticket_Time Plea Trial_Date Verdict Fine_Amount Date_Paid
Licence C (Handicap) D_IdNo HandicapHC
Ticket Type A IdNo Driver_Attitude
Ticket Type B IdNo Road_Condition