This project is a Team Assignment on Databases course at ECE AUTH

University Database Systems Project

This project implements a relational database system for a Hotel Booking platform.

The project includes:

• Full database schema design
• Data population
• SQL queries
• SQL views
• Final design documentation and analysis

The system models the core functionality of a hotel reservation platform including hotels, rooms, users, reservations, payments, promotions, and related entities.

├── HotelBookingDB_dump.sql      # Database schema + sample data
├── HotelBookingDB_views.sql     # SQL Views
├── query1.sql
├── query2.sql
├── query4.sql
├── query6.sql
├── query7.sql
├── query8.sql
├── final-design.docx            # Final project report
└── README.md

The database includes entities such as:

• Hotels
• RoomTypes
• Rooms
• Users
• Guests
• Reservations
• Payments
• Promotions
• Owners
• Amenities
• Inventory

The design follows relational database principles including:

• Primary and foreign keys
• Referential integrity
• Constraints
• Normalization

HotelBookingDB_dump.sql

Includes:

• CREATE TABLE statements
• Constraints and relationships
• INSERT statements with sample data

HotelBookingDB_views.sql

Custom views created to simplify complex queries and support reporting functionality.

Separate SQL files containing assignment queries:

• Data retrieval queries
• Aggregation queries
• Filtering and grouping
• Join operations across multiple tables

Each query demonstrates advanced SQL usage including:

• JOINs
• GROUP BY
• HAVING
• Subqueries
• Aggregate functions

The file final-design.docx includes:

• ER Diagram
• Schema design explanation
• Assumptions
• Business rules
• Design decisions
• Query explanations

This project demonstrates:

• Relational database modeling
• Entity-Relationship design
• SQL implementation
• Query development
• View creation