I am writing an application using C#/Asp.Net. In the database i have three tables. (Students, Groups and Preference).
Students
Student Name---------Group ID(Not Data for now) Student A Student B Student C Student D Student E Student F Student G Student H Student I Student J Student K Student L
Preferences Tables
Student Name--------Preference 1--------Preference 2--------Preference 3 Student A------------Student G-----------Student F Student B------------Student H-----------Student K------------Student L Student C------------Student I Student D Student E Student F Student G Student H Student I Student J Student K Student L
Groups Table Group ID 1 2 3
Group ID 1 2 3
I want to create students groups for Labs based on preferences. Each group will have min 3 and max 4 students. If some students are left without group, that can be adjusted manually. Each student will enter max 3 preferences (optional), who he/she want's to group with. How can i implement this. Any Examples etc? Any help will be much appreciated.