New member here so I hope I'm posting in the correct forum. I have been requested to come up with a Student Challenge database for elementary students in grades 4-7. They want to randomly assign the teams (up to 20-30) to play each other in different games in different rooms at certain times. There are 6 games to compete in, a break time, lunch and downtime. For example:

Game 1 - 9:25-9:55 4 teams competing
Game 2 - 10:00-10:30 4 teams competing
Game 3 - 10:35-11:05 up to 12 teams competing

Also throw in lunch time and break time. I have attached a rough db and was hoping that someone may be able to tell me if this is possible to do or not. I am definitely not good with code. Any advice anyone can give would be appreciated.

Thanks.