I'm working with a really big dataset and I'm a little out of my depth with one aspect of my problem.

I have around 30 tables imported. One table holds information about people and there are 29 other tables containing records about processes applied with those people.

Scaling the problem down, let's say we have a person named Timmy.

There are 6 records for Timmy in process 1.

2 of which end the process with no further action and the other 4 trigger process 2.

Of the 4 instances of process 2

There is no further action in one case

While there are 3 instances where process 3 is triggered.

How would we normalise this while preserving the links between the child and the process, while also being able to see the links between processes?

I've managed to get this working to start a decomposition tree with info about 6 processes but it uses many to many relationships with lots of blank space in a fact table and I think there's probably a way to do it better. Any ideas?