On a certain date, time and location (Event) I have classes (content) that are attended by students who belong to a group which belongs to a program. I have to be able to look up what students belong to what program and what group and vice versa. I want to register what student of that group did and did not show up at a certain event. I also want to be able to look up which subject has been taught by which teacher and which students attended that specific event, etc. I also would like to register out of the contacts who joined which group when. Also everything reversed, so multi-multi. The subject of the Event should be looked up in Content tabel and be fixed. The contents of the event however should be looked up but can be a variation, so editable. This is just a coarse outline of the requirements. Perhaps best to chop it up in pieces. I have already made the tables and made some relationships, but I am not sure those are correct.