Database Design

[admin]

Heres my problem....
if anyone wants to help
The database is the mysql sort.
the thing will be use to track animation projects.
the relationship is a follows,
project
1 to many
sequence
many to many
scene
many to many
this is the strcuture would be something like this

|project|
|ID|name|
|1 |Test|
|2 |tmp |
|3 |bla |

|sequence|
|ID|seq_name|PID|
|1 |seq 01 |1 |
|2 |seq 02 |1 |
|3 |seq 01 |2 |
|4 |seq 02 |2 |


|scene|
|ID|sc_name|SeqID|
|1 |sc 01 |1 |
|2 |sc 02 |1 |
|1 |sc 01 |2 |
|2 |sc 02 |2 |

Now to explain my logic
The PID stands for Project to track What sequence will belongs to what project

The SeqID
The SeqID stands for SequenceID to track What scence will belongs to what Sequence

My Question IS
Their Must be a simpler answer or a more logical way to the the same thing.
Thanks
Nils