I have had a crack at normalizing some data for a database would appreciate any feedback as I had a bit of trouble but I feel I'm almost there.
Here is the structure:
I have used a composite key(Incident ID and Action code) as a certain incident would not require two actions of the same type. Is there a better way of doing this? I thought about just adding an Action ID auto number but is this OK?