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