Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2007
    Posts
    24

    Help with database design

    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.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    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
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    Feb 2007
    Posts
    24
    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.

    Click image for larger version. 

Name:	carAccident.jpg 
Views:	47 
Size:	52.2 KB 
ID:	10910

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    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
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  5. #5
    Join Date
    Feb 2007
    Posts
    24
    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,...)

  6. #6
    Join Date
    Feb 2007
    Posts
    24
    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
    Attached Thumbnails Attached Thumbnails Incident_ERD.gif  

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •