Foreign keys (DormitoryID, RoomID, StudentID) establish relationships between entities by referring to primary keys from their respective tables.

Answer 1

Correct. A foreign key is a column or a set of columns in one table that refers to the primary key in another table. It establishes a relationship between entities by creating a link between the two tables. In this example, the foreign keys (DormitoryID, RoomID, StudentID) refer to the primary keys of the respective tables, creating relationships between the dormitory, room, and student entities.