Hello, could anyone help me with a query for my school project?
The database represents the campus housing, and I need help with a query that assigns students to newly available rooms, and then updates the waiting list.
Once a Student graduates(indicated by GraduationDate), he/she will be unassigned the RoomID which then makes that room available in the Room table.
The next student on the waiting list would then be assigned the available room, and the waitlist number for that student will either be be updated to a null value (easier, and keeps the wait list column static) or can be dynamically updated(not sure how to do)
I would very much appreciate any help. Thanks!
The database represents the campus housing, and I need help with a query that assigns students to newly available rooms, and then updates the waiting list.
Once a Student graduates(indicated by GraduationDate), he/she will be unassigned the RoomID which then makes that room available in the Room table.
The next student on the waiting list would then be assigned the available room, and the waitlist number for that student will either be be updated to a null value (easier, and keeps the wait list column static) or can be dynamically updated(not sure how to do)
I would very much appreciate any help. Thanks!