SQL + PYTHON
Tour & Travel Management System Relational Enterprise Architecture & SSMS Schema
Repository
Relational Database & PyODBC Architecture

Enterprise Tour & Travel System

Comprehensive relational database design, foreign-key relational integrity, and Python Tkinter GUI integration implemented with Microsoft SQL Server Management Studio.

6
Core Relational Entities
5
Foreign Key Constraints
3NF
Normalized Schema
100%
Referential Integrity
Entity Relationship Architecture (Star-Relational Schema)
Centralized Tour_Booking fact entity with foreign key relationships to normalized dimension entities
Tour_Booking (Fact) PK: booking_id (IDENTITY) FK: package_id → Tour_Package FK: customer_id → Customer FK: transport_id → Transport FK: hotel_id → Hotel FK: place_id → Tourism_Place booking_date | total_price Tour_Package PK: package_id (VARCHAR) package_name, description package_price, duration Customer PK: customer_id (VARCHAR) customer_name, email customer_phone Transport PK: transport_id (VARCHAR) transport_type, description transport_capacity Hotel PK: hotel_id (VARCHAR) hotel_name, location hotel_rating, description
Interactive SQL Table & Seed Data Explorer
Query seed records loaded directly from ProjectTTMS.sql
Interactive Booking Generator
Simulate PyODBC transactions and foreign-key relational composition

Simulated Booking Invoice

Booking ID: #104 (AUTO-INC)
Customer: Jane Doe
Status: Confirmed (3NF Validated)
Database Engine: MS SQL Server 2022
Total Package Cost: PKR 5,000