CREATE TABLE C_RoomAmenities (
  ID_RoomAmenities INT NOT NULL CONSTRAINT PK_RoomAmenities PRIMARY KEY CLUSTERED,
  Description_RoomAmenities varchar( 255 ) NOT NULL,
  CreatedOn datetime NOT NULL CONSTRAINT DF_CreatedOn DEFAULT getdate(),
  CreatedBy varchar( 100 ) NOT NULL CONSTRAINT DF_CreatedBy DEFAULT user_name()
)

INSERT C_RoomAmenities (ID_RoomAmenities, Description_RoomAmenities) VALUES( 1 , 'Bathroom')
INSERT C_RoomAmenities (ID_RoomAmenities, Description_RoomAmenities) VALUES( 2 , 'Shower')
INSERT C_RoomAmenities (ID_RoomAmenities, Description_RoomAmenities) VALUES( 3 , 'A/C')
INSERT C_RoomAmenities (ID_RoomAmenities, Description_RoomAmenities) VALUES( 4 , 'TV Set')
INSERT C_RoomAmenities (ID_RoomAmenities, Description_RoomAmenities) VALUES( 5 , 'Telephone')
INSERT C_RoomAmenities (ID_RoomAmenities, Description_RoomAmenities) VALUES( 6 , 'Internet Access')