Its for my dad!... he has asked me to do it as i am trying to get an a level in it

i asked my teacher for advice yet he doesn't...

My teacher told me to break them up, because it will make it easier when it comes to the restricting of the seats. yet the dumb bloke has no idea...

THANK YOU LOT SO MUCH FOR THE REPLIES SO FAR

This is a screen shot of the relationships with the fields in the database, it is now to late for me...