{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

week 5 table.docx - Table Name Hotel Reservation Attributes...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Table Name Attributes Data Type Key Type Hotel Hotel_Code Integer(20) PRIMARY KEY Hotel_Name Varchar(20) Hotel_Address VarChar(50) Hotel_NoOfRooms Integer(10) Reservation Reservation_No Integer(20) PRIMARY KEY Reservation_Hotel_Code Integer(20) FOREIGN KEY Reservation_Guest_ ID Integer(20) FOREIGN KEY Room Room_ID Integer(20) PRIMARY KEY Room_Reservation_No Integer(20) FOREIGN KEY Room_Type Integer(10) Employee Employee_ID Integer(20) PRIMARY KEY Employee_Name Varchar(20) Employee_Address VarChar(50)
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}