I noticed earlier when I added a room, S102 , stime = "1000" and etime = "1050" to the room_status table, it verified the room existed with the building code and the room number by checking the rooms table.
However, it did not check to see if there was a conflicting time. We may need to alert the user that the time of a class conflicts with one already in the system. For Example:
S102 stime = "1000" and etime = "1050" // currently in DB
then I added S102 stime = "930" and etime = "1045"
So if we were checking class times for room s102, it would think that class was from 930-1050, when really only one of the entries is true. I am not sure this is an urgent issue, but it is definitely worth fixing if we have time.
I noticed earlier when I added a room, S102 , stime = "1000" and etime = "1050" to the room_status table, it verified the room existed with the building code and the room number by checking the rooms table.
However, it did not check to see if there was a conflicting time. We may need to alert the user that the time of a class conflicts with one already in the system. For Example:
S102 stime = "1000" and etime = "1050" // currently in DB
then I added S102 stime = "930" and etime = "1045"
So if we were checking class times for room s102, it would think that class was from 930-1050, when really only one of the entries is true. I am not sure this is an urgent issue, but it is definitely worth fixing if we have time.