dichotomous
Registered User.
- Local time
- Tomorrow, 05:07
- Joined
- Oct 19, 2012
- Messages
- 62
Hello
I am building a hazard management data base for health and safety.
I'm not sure If I'm using my junction table correctly. The tables are for Job Safety Analysis to assign risk,harm and control.
Here are my tables. I've attached the DB also.
(table)
JSA_ID PK
JSAtask
(table)
JSAanalysis_ID PK
Task Analysis
JSA_ID FK
(Table - Jnction)
Connect_ID
JSAanalysis_ID FK
JSAcontrol_ID FK
(table)
JSAcontrol_ID PK
Control
Date Reviewed
there are additional tables sitting as sub data sets of (JUnction table connect). Risk and Harm.
I have difficulty representing this in a form. JSA title and Analysis flow as analysis is a sub data set of JSA Title. One JSA Title, has many steps. One to many.
One of the Analysis steps has 0 - many controls. I believe a Junction table is the right thing, because a control can belong to more than one of the Task's Analysis steps.
I believe that risk should hang off the connect table as a sub data set of both analysis and control.
I an open to correction and give many thanks in advance.
I am building a hazard management data base for health and safety.
I'm not sure If I'm using my junction table correctly. The tables are for Job Safety Analysis to assign risk,harm and control.
Here are my tables. I've attached the DB also.
(table)
JSA_ID PK
JSAtask
(table)
JSAanalysis_ID PK
Task Analysis
JSA_ID FK
(Table - Jnction)
Connect_ID
JSAanalysis_ID FK
JSAcontrol_ID FK
(table)
JSAcontrol_ID PK
Control
Date Reviewed
there are additional tables sitting as sub data sets of (JUnction table connect). Risk and Harm.
I have difficulty representing this in a form. JSA title and Analysis flow as analysis is a sub data set of JSA Title. One JSA Title, has many steps. One to many.
One of the Analysis steps has 0 - many controls. I believe a Junction table is the right thing, because a control can belong to more than one of the Task's Analysis steps.
I believe that risk should hang off the connect table as a sub data set of both analysis and control.
I an open to correction and give many thanks in advance.
Attachments
Last edited: