I am designing a database which tracks courses and customers registered in these courses, etc. What I am looking for is suggestions in how to track students enrolled in classes and how to track when a class is full and who is on a waiting list. My thought is to have a table with the course id and the customers name and associated information. But how do I track who would be on the waiting list once the class size had been reached. The class size coming from a location table. Any ideas?