JumaJuma19/zanzibar-ai
Créateur:
Jum
Hôte:
AI tourism project for Zanzibar
# MyZanzibar AI – Milestone 2
### github repo link: github.com
## Project Overview
MyZanzibar AI is a tourism database system designed for Zanzibar tourism management and future AI-powered recommendation systems.
The project stores and manages:
* Hotels
* Restaurants
* Activities
* Users
* Reviews
* Trip plans
* Locations
This database supports future development of:
* Recommendation systems
* Retrieval-Augmented Generation (RAG)
* Tourism analytics
* AI chatbot integration
---
# Technologies Used
* PostgreSQL
* SQL
* pgAdmin
* Python (for synthetic data generation)
---
# Database Tables
The system contains the following tables:
1. users
2. locations
3. hotels
4. restaurants
5. activities
6. trip_plans
7. reviews
---
# Dataset Description
The dataset contains realistic tourism-related data for Zanzibar, including:
* Hotel information
* Restaurant details
* Tourist activities
* User reviews
* Travel plans
* Location information
The data was synthetically generated to simulate real tourism behavior.
---
# Row Counts
Approximate dataset size:
| Table | Rows |
| ----------- | -------- |
| Users | 100 |
| Hotels | 300 |
| Restaurants | 300 |
| Activities | 300 |
| Reviews | 300 |
| Locations | 14 |
---
# Features Implemented
## JOIN Queries
* Hotels with locations
* Reviews with users and hotels
## Aggregation Queries
* Average hotel ratings
* Activity counts by category
## Subqueries
* Hotels above average price
* Users with reviews
## Common Table Expressions (CTE)
* Top-rated hotels
* User review summaries
## Window Functions
* Hotel price ranking
* Row numbering by location
---
# Database Schema
The schema includes:
* Primary Keys
* Foreign Keys
* Relational constraints
* Normalized structure
Main relationships:
* Hotels belong to locations
* Reviews belong to users
* Activities belong to locations
* Trip plans belong to users
---
# How …