Sayeh fi Misr is a cultural exploration platform built for our Database course. It allows users to discover and interact with Egypt’s landmarks, join guided tours, share reviews and photos, earn badges and points, and redeem rewards like handmade earrings.
Have you ever imagined a world where you could explore Egypt’s museums, mosques, and streets—all from a single platform, discovering hidden gems with just a click? This Project is a part of our database course that brings this vision to life.
📑 Table of Contents
🎉 About the Project
Sayeh fi Misr is an interactive platform that enables users to:
- Search for specific locations or filter options by category and region.
- Engage with a vibrant community by posting reviews, uploading photos, and creating wish lists.
- Join guided tours and events hosted by dedicated tour guides.
- Explore dynamic features like badge systems, location ratings, and social sharing.
- Explore our shop, engage, gain points and get a free earing! 😉
Administrators and hosts play a pivotal role in managing content, organizing gatherings, and ensuring the platform remains vibrant and user-friendly.
💡 Features
User Functionalities
- Search and Browse: Discover locations by name, category, or geographic area.
- Wishlist and Visited List: Maintain a personal wish list and a list of visited locations.
- Reviews and Ratings: Write reviews, optionally include ratings, and help others explore.
- Photo Uploads: Share personal photos of visited locations.
- Badge System: Earn badges for achievements like visiting locations, attending tours, and sharing content.
- Join Gatherings: Participate in curated tours and events.
- Reporting: Report places or gatherings for potential violations.
- Social Features: Share gatherings with friends and view other users’ profiles.
- Gain Points: Gain points from visiting places, sharing reviews, and uploading photos.
- Shop: Gain specially designed handmade earrings related to each place, available by collecting points in the platform’s shop.
Host Functionalities
- Gathering Management: Organize, manage, and cancel gatherings.
- Participant Management: Manage participant lists for gatherings.
- Group Size Limits: Specify group sizes for intimate or large gatherings.
Admin Functionalities
- Dashboard: Access comprehensive admin tools and features.
- User Management: Ban, unban, or assign roles to users.
- Content Management: Add, edit, or remove places, as well as delete inappropriate reviews.
- Statistics: Access activity logs, trending places, and user engagement metrics.
- Resolve Reports: Address and resolve user-reported issues.
- Cancel Gatherings: Cancel any gatherings created by hosts.
📊 Entity-Relationship Diagram (ERD)
Below is the ER diagram illustrating the relationships between entities in the system.
🤝 Contributing
We welcome contributions to Sayeh fi Misr! Please fork the repository and submit a pull request with your proposed changes.
 |
 |
 |
 |
|---|---|---|---|
| Amr | Loay | Amira | Tasneem |
🌐 Live Version
Check out the live version of Sayeh fi Misr here but run locally for a better version:
Sayeh fi Misr
📝 License
This project is licensed under the MIT License. See the LICENSE file for details.