Travel Management Database
A CLI-based travel system built with Java and SQL Server, featuring a relational schema, stored procedures, and a JDBC-connected interface.
Overview
This project simulates the backend of a travel agency, supporting the management of travelers, flights, hotels, restaurants, and activities. Users interact through a Java-based command-line interface that connects to a SQL Server database. The system executes stored procedures to perform inserts, updates, and queries—such as booking itineraries or retrieving reviews—while enforcing business logic and preventing SQL injection.
The relational database contains over a dozen normalized tables with foreign key constraints, supporting scalability and modular reuse.
Technologies
• Java CLI frontend using JDBC
• Microsoft SQL Server with SSMS
• 12+ table schema with foreign key constraints
• Modular stored procedures and sample data scripts