Access Challenge 2

A few weeks (Months?) ago now, we created a database to help our fictitious Police department record the Traffic Fines (Yes, of course all descriptions of police activity in this exercise are completely fictitious.) You sit down for an easy day at work playing solitaire, only to discover the following email in your inbox:

Hi again! The new Traffic Fines database is being utilised very well within the department, which is great as it's increased our revenue ;). A few of the officers have some suggestions though:

• Is it possible to have a form where we can enter multiple offences against a person at once? Sometimes when we pull people over for speeding, we find that they've got a few defects with their car, or have broken some other regulation... We'd like to enter these multiple fines against the one incident.
  
• Secondly, I hope we're not asking too much, but it'd be great when we do record multiple offences for an individual incident, to be able to see a total of the fines. For example, if Joe Blogs is pulled over for speeding (10 over the limit, $250), but we also find that his car is unregistered ($750) and he talks back to us a bit ($190 for abusing an officer), it'd be great to know that we've got a hat-trick worth $1190 straight away - kindof, calculated automatically on the form... is that possible?

We've got some new budget available to pay for the changes. Taa.

You'll need to get together in your team to:

1. Analyse the requirements to make sure you understand them - drawing the form on paper might be a good way to do this...
2. Review your Police Fines database design to see if the requirements can be satisfied with the current design - and if not, come up with a new design that can fulfil the requirements.
3. Make a copy of your Police Fines database and implement a working prototype together.