Database - 2 Tables (Student, Rooms)

Student

Room

fname

-

student's first name

dorm

-

the dorm name

password

-

his rand generated password

roomNo

-

the room number

priorityNo

-

inputed priority nomber

section

-

grouping of the rooms (ie. halls, suites) used

class

-

year in school

in pulling, locking and room swapping

residence

-

where student lived previous year

occupancy

-

the maximum/required number of occupants

roomClaim

-

room that student has claimed

claimer

-

the current

dormClaim

-

dorm that student has clamed

claimedNo

-

the effective priority with which the room was claimed

lname

-

student's last name

roomPulled

-

the room (if any, 0 if N/A) that was pulled with this one

floor

-

the floor of the dorm where the room is