Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 987
  • Last Modified:

School timetabler and room booking database design

Hi,

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
0
Nick1988
Asked:
Nick1988
1 Solution
 
Eugene ZCommented:
check as example:
hotel rooms reservation project - the same idea
http://www.sourcecodester.com/visual-basic-net/hotel-reservation-system-vbnet.html
0
 
aheddellCommented:
With respect, aren't you re-inventing the wheel here?  There are dozens of applications out there that do this kind of thing and quite a few open source.

Does the school run Outlook and Exchange?  I would have thought an Outlook form would be a very effective way forward.  I certainly have implemented room booking that way in the past

Sorry to not really answer your question - there's nowhere near enough detail here but I would have thought there are better ways forward.

Hope you don't take this the wrong way...!?!?

Alex Heddell
0
 
EvilPostItCommented:
Just at first glance i would split this into 4 sections for though.

Lecturers
Students
Courses
Allocation Time Slots

With regards to the Allocation Time Slots i would assume (obviously i could be way off) that there are specific blocks of time (almost like periods) throughout the day. You could create all of the allocatable periods within a week in a table along these lines.

The courses table would have a list and description of all courses and maybe some other tables linking off from it with larger information. Critically you should have an linking table sitting between the courses table and the allocation time slots table (Maybe CourseTimeTable. Then simply you would confirgure a course and allocation what times it took place on any given week.

The lecturer table would be referenced from the course table thus making only 1 lecturer assignable on any 1 course.

For the Student table i would have an Enrollment table so that each student could be enrolled to more than 1 course and each course can have more that 1 student.

Obviously this is just my initial thoughts on how i would design it and there will be hundreds out there. So hope this helps and good luck.

Or on the other hand use outlook ;-)
0
 
HumpdyCommented:
depending on complex you need to get ..
break it down into blocks of what data you need to store.

firstly, you need to store info about the student.
so you would have a students table, containing something like studentID, first_name, last_name, date_of_birth.
You may also need info about the lecturer
Lecturers table, containing LecturersID, first_name, last_name, email_address, phone

secondly, you need information about the courses.
so you would have a courses table, containing something like CourseID, course_description

thirdly, you may have modules under these courses
so you have would have a CourseModule table, containing CourseModuleID, CourseID, Module_name, Lecturer_ID

thirdly, you need to know what students are taking what module, which can then refer to what course it is with the above table.
so you would have a StudentsCourseModule table, containing something like StudentsCourseModuleID, StudentID, ModuleID


this getting you in the right direction ?



0
 
Nick1988Author Commented:
thanks and sorry for taking so long to get back to the question!
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now