Database structure

L

Luc Ferrari

Rookie question :

I want to make a database for the evaluation of occupational safety of
different jobs

Job 1 : Example : "Installing electrical cabinets & cables"
I want to split the job in tasks : example "Task 1: Installing cable
ladders"
Each task can have multiple risks attached to it : example risk
for Task 1 : "Falling from height"
For each risk there are different sub-risks : example :
"Falling through the roof"
Four each sub-risk there are different preventive
measures that can be coupled with the sub-risk : example " use safety
harness"


The risks, sub-risks and preventive measures are all selectable throug a
table (or extra items can be added).


So how do i set up such a database.
I want to enter the data through a form, in a easy and clear way.
Are there examples with the same structure available ?


Thanks for your replies,

Luc
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top