SQL Tables: Customer Information Reservations Invoices Guest Rooms Guest Room Gallery Promotions User Management

SQL Objects: SP - Mapped Data SP - Invoices View - Mapped Data View - Payment Summary Trigger - Audit Function - Invoice

Guest Room Information

Add New Guest Room

RoomID RoomNo Room Type ID Room Picture ID Room Capacity Room Rate Room Status Delete Update

Add New Guest Room