Hi,
please could anyone help me in modeling a database for road traffic accident ?
I need a way to store the contributory factor of the accident. They could be classified as vehicle failure or human factor. The latter could be any of the traffic violation and some of that may be due to the physical state of the driver (under influence of alchool, drug, tiredness,etc).
Any accident could have one or more contributory factor.

Sure, what part of the assignment are you hoping we'll help you design? What have you done so far?

Before we go too far, do you have access to the teacher? They are usually your best source of help since they know exactly what their course expects to teach and what will be on the exams.

-PatP

This is not an exam assignment.
I have to create a software for recording car accident data for statistical purpose. I post what i have done at now.
Please feel free to give any advice on the design.

Ok, can you give us some input samples (the original forms or records), and more importantly detailed output requirements? This schema exists to collect data about vehicle accidents and transform that data into information of some kind. In order to help you with designing your schema, we need to know more about what you want that schema to do for you.

-PatP

Well, the system will be used to get statistical report about car accident.
So it should be able to reply to questions like :
- Which are the main contributory factor of car accident ?
- Which are the main contributory factor per vehicle type ?
- How many killed or injuried person ?
- Fatalities by Highest Blood Alcohol Concentration ?
- how many motor vehicle occupants and nonoccupants killed and injured?
- number of pedestrian involved in car crashes
- accident by type of road
... and so on... there could be many more reports
(probably in the future the database should populate a datawarehouse).

Possible contributory factor could be classified into two main category :
- vehicle defect (bkeaks, tyres,...)
- human behaviour (high speed, Failure to signal, getting drunk during driving,...)

I revised my earlier incident ERD.
This is my second, more detaled, version of the databse.
I have a big question about the Vehicle entity. In the statistica reports, i', intereseted in vehicle type, but i also need to discriminate which vehicle type a casualty is related to.
Example :
an incident involves a Car and a Truck with 3 injured in total, 2 car occupants and the trunck driver.

With this requirement do you think i need the vehicle entity (it has no significant attribute) ?

thanks