Excellent. There are only three columns in the Student table: ID, Name, and RoomID. The column ID is the identification number of each student in our table, Name is the full name of a student, and RoomID is the iD of the room in which a student lives. The room ID is, of course, taken from the Room table.

If you examine the Student table close enough, you'll find that some students don't have a room assigned to them. Remember this detail; we'll make use of this information later on.

Okay, let's check the last table.