I am currently having a major issue with a project im working on. I need to devlop a school timetable and room booking application with quite simple functionality e.g. being able to generate a students timetable i am currently relaly struggling with how i can create the database to store all of the information.
I am really struggling to come up with a suitable database design that will hold all of the students information all of the lecturer's information. The module information to its pertaining course, the lecturer that looks after the module how long the lecture is e.g. 1 or 2 hours long lastly generating all of that information into a timetable for a specific course showing you the day of the week it is on and the time it is on.
Any help in the design and normalisation of the required tables would be of a great help, i really am at a loss.
Apologies if this isnt clear, i will try and explain / answer any queries as quickly as possible