Home

Jump to bottom

Md Nayan Mia edited this page Nov 4, 2025 · 1 revision

Welcome to the HotelCore wiki!

04/11/2025 - I have started work on this project.

Created the Git repo, Project Structure, System Flow Diagram, and ER Diagram.

Key Design Decisions

Atomic Booking with Concurrency Control Challenge: Prevent double-booking when multiple users attempt to reserve the same room/time slot simultaneously.

Solution:

Use SQL Server transactions with UPDLOCK and ROWLOCK in sp_CreateBooking (Store Procedure)
Check availability and insert BookingSlots atomically