01 / 06
Availability Matrix
Date-based inventory engine connects room types, concrete room instances, and guest stay ranges with overlap validation.
Hotel Management.
A complete Django academic capstone: engineering a server-rendered monolith with SQLite for room inventory, reservation lifecycles, and front-desk workflows, coupled with a decoupled retrieval-augmented assistant.
Django 5.xPythonSQLite + WALServer-RenderedFAISS Vector RAGMVT Pattern
PRJ-03 · HOTEL-MGMT
COMPLETED CAPSTONE
Django 5 + SQLiteFAISS Vector RAGServer-Rendered
2025.10 → 12
Development window
6
Focused test suites
SQLite + WAL
Core database
Completed
Capstone status
Modular Architecture Schema
Operational Monolith with an Isolated Knowledge Boundary
The transactional reservation engine operates with strict ACID semantics on relational SQLite, while the semantic RAG assistant lives in a decoupled inquiry boundary.
TIER 01 /
ACID · TRANSACTIONALCORE OPERATIONAL MONOLITH (DJANGO MVT)
01 / Routing & Guard
URL & Role Dispatcher
Routes incoming requests through class-based views with role-guard decorators for Admin, Desk Staff, and Guests.
02 / Business Engine
Reservation State Machine
Validates date intervals, allocates room inventory atomically, and handles cancellation restitution workflows.
03 / Data Layer
Optimized SQLite ORM
Concrete select_related and prefetch_related query tuning ensuring sub-2ms relational query execution.
Decoupled Semantic Query Bus
TIER 02 /
VECTOR · NON-BLOCKINGAUXILIARY KNOWLEDGE RETRIEVAL (FAISS RAG)
01 / Corpus
Resort Policy Corpus
Chunked and tokenized documentation covering check-in policies, room tariffs, and resort guidelines.
02 / Indexing
FAISS L2 Vector Index
Embedding vector search computing cosine/L2 distance over indexed chunks in under 15ms.
03 / Generation
Augmented Context
Synthesizes retrieved policy excerpts into an isolated prompt for grounded, factual assistant replies.
System Capabilities
Verified Operational Modules
02 / 06
Reservation State Machine
A robust booking lifecycle wraps creation, inventory decrement, atomic overlap checks, and automated cancellation restores.
03 / 06
Optimized ORM Loading
Targeted select_related and prefetch_related optimizations eliminate N+1 queries on hot administrative booking views.
04 / 06
Role-Based Desk Access
Decorator-enforced role boundaries separate Admin capabilities from Front Desk check-in/out and housekeeping duties.
05 / 06
Auxiliary Vector RAG
A decoupled semantic retrieval layer queries FAISS vector indices to inject resort policies into localized assistant prompts.
06 / 06
ACID SQLite Transaction
Critical room allocation paths run within transaction.atomic and select_for_update blocks to preserve data integrity.
Development Milestones
Verified Capstone Timeline
2025.10.28
GIT VERIFIED
Core repository baseline established
MVT monolith initialized with models for rooms, bookings, and customer profiles.
2025.11.19
GIT VERIFIED
Full booking workflow & atomic tests completed
Availability checks, inventory signal handlers, and role-based staff operations passed verification.
2025.12.04
GIT VERIFIED
Decoupled FAISS RAG assistant integration
Vector similarity search boundary integrated for resort policy inquiries via isolated API bus.