ALASTKA is a DBMS + Java (JDBC) based tourism information system designed to store, manage, and retrieve tourism-related data across countries and cities.

What's in the name? The name ALASTKA is inspired by Alaska and Chukotka — two regions that appear far apart on flat maps but are geographically close — symbolizing how data relationships can reveal hidden connections.

• 🌎 Country-wise tourism information: Detailed data at the national level.
• 🏙️ City and tourist place management: Track specific destinations and cities.
• 🗺️ Categorization of attractions: Filter by types such as Historical, Adventure, etc.
• 🏨 Accommodation and booking system: Manage stays and user bookings.
• 📊 SQL-based data retrieval: Efficient filtering and querying.
• 💻 Menu-driven Java application: A clean, JDBC-integrated user interface.

ALASTKA-Tourism-System/
│
├── src/
│   ├── db/          # Database connection
│   ├── model/       # Entity classes (User, Person)
│   └── main/        # Main application (Menu-based)
│
├── sql/
│   ├── schema.sql   # Database structure
│   ├── data.sql     # Sample data
│   └── queries.sql  # Useful queries
│
├── Documentation/
│   └── ProjectReports.pdf  # Phase 1 and Phase 2 Project Reports
│
└── README.md

CREATE DATABASE ALASTKA;

Execute the following files in order inside your MySQL environment:

sql/schema.sql
sql/data.sql

• Add the MySQL JDBC Driver (Connector/J) to your project's build path or dependencies.
• Update your database credentials in the connection file:

// src/db/DBConnection.java
String url      = "jdbc:mysql://localhost:3306/ALASTKA";
String username = "your_username";
String password = "your_password";

Execute the main method to launch the menu-driven interface:

// Run: src/main/MainApp.java

• Relational Database Design: ER/EER Modeling
• Database Normalization: Structured up to 3rd Normal Form (3NF)
• Constraints: Proper use of Primary Key & Foreign Key constraints
• CRUD Operations: Create, Read, Update, and Delete functionalities
• Database Connectivity: Seamless integration using JDBC
• Object-Oriented Programming (OOP): Implementation of Inheritance & Polymorphism

DBMS + Java Mini Project (Academic)

This project is created for educational purposes only.