Guest_ID (PK), First_Name , Last_Name , Phone , Email , Address . : Connects guests to rooms.
: Transitive dependencies are removed (e.g., moving room prices to a separate Room_Types table rather than keeping them in the Rooms table). Sample Usage Script BITHOTEL_DB_normalized.txt
Booking_ID (PK), Guest_ID (FK), Room_Number (FK), Check_In_Date , Check_Out_Date . : Tracks financial transactions. Guest_ID (PK), First_Name , Last_Name , Phone ,
: All columns contain atomic values, and there are no repeating groups. and there are no repeating groups.