-- Example structure found in normalized hotel scripts CREATE TABLE Room_Types ( Type_ID INT PRIMARY KEY, Type_Name VARCHAR(50), Daily_Rate DECIMAL(10,2) ); CREATE TABLE Rooms ( Room_No INT PRIMARY KEY, Type_ID INT, FOREIGN KEY (Type_ID) REFERENCES Room_Types(Type_ID) ); Use code with caution. Copied to clipboard
: 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
: All columns contain atomic values, and there are no repeating groups. -- Example structure found in normalized hotel scripts
Room_Number (PK), Room_Type_ID (FK), Status (e.g., Available, Occupied). Room_Number (PK), Room_Type_ID (FK), Status (e
Payment_ID (PK), Booking_ID (FK), Amount , Payment_Date , Payment_Method . The "normalized" aspect of this specific file ensures that:
Guest_ID (PK), First_Name , Last_Name , Phone , Email , Address . : Connects guests to rooms.