Search results

I realize there are several threads already dedicated to this particular topic but my situation is slightly different... First, my tables are set up like so: tblStudent(studentID,LName,FName,MI,Gender) tblRack(rackID,roomID,studentID,rackNumber) tblRooms(roomID,roomNumber) There are 3 racks...

Trying to set up a fairly simple DB. Here is the layout: tblRoom(roomID, roomNumber, rackOne, rackTwo, rackThree) tblStudent(studentID, name) Each student will be assigned to one, and only one, rack. There will be 3 students to one room. One student can only have one room but a room can...

Greetings, I was hoping someone could offer some advice on how I would design the following project: Student Table - ID - Name - Unit (each student belongs to one specific unit) - License type (each student could have multiple license types) Unit Table - Unit Name (string) License...