Exam Room Allocation

[Satish_S]

Hi i need to allocate students to the exam hall,These are the rules for placing an exam to a room: 1. If total of students is bigger than the biggest room capability, then the class will be split. (ex. if the total of students is 120, but the biggest capacity of room is 40, then the exam will be split into three rooms) 2. One room can handle two (maximum, cant more than 2 exams) exams at the same time and day. I am going to minimize the use of room and day. So the exam will be held densely (lets say, if the timetable made by human will product a timetable for 12 days, i want to minimize it to 10 days.. or 9 days can you give me what logic i should start with. thanks

[Blue_Boy]

Ok, and now you want logic for query or to design your web application?

---

I Love T-SQL "VB.NET is developed with C#.NET" If my post helps you kindly save my time by voting my post. www.cacttus.com

[Satish_S]

Hi Logic for design thanks

[Lost User]

sathimailin1 wrote:

can you give me what logic i should start with.

You have specified the logic in your question, just write down how you would calculate how many rooms you need, how many exams you can run per day, etc.

The best things in life are not things.

[David Mujica]

if this is a "real" problem, then you should also consider that all students taking the "history exam" need to be scheduled on the same day. Otherwise the students who take the exam on day 1 will tell the students on day 2 about the exam. This sounds too much like a homework assignment, so your not going to get specific help in doing your homework.