Academic Database Design Project - A comprehensive database design and implementation for an Airbnb-like platform, developed as part of the Database Design course at IU International University.
This project implements a complete database solution for a vacation rental platform similar to Airbnb, covering all phases from conceptual design to implementation. The database supports complex business operations including property management, booking systems, user interactions, and financial transactions.
| Phase | Description | Status |
|---|---|---|
| Phase 1 | ER Model Design (25 entities) | ✅ Completed (2025-10-05) |
| Phase 2 | Database Implementation (27 entities) | ✅ Completed (2025-10-15) |
| Phase 3 | Final Documentation & Submission | ✅ Completed (2025-10-27) |
- Users: Hosts, guests, administrators with verification systems
- Properties: Listings with detailed descriptions, amenities, and rules
- Bookings: Reservation management with status tracking
- Reviews: Rating and feedback systems
- Payments: Financial transaction processing
- Location: Geographic data and address management
- Communication: Messaging and notification systems
- Triple Relationships: 3 complex many-to-many-to-many relationships
- Recursive Relationships: 1 self-referencing relationship
- Database System: MySQL 8.0+ (implemented)
- ER Notation: IEEE notation (Crow's foot)
- SQL Standard: ANSI SQL:2016 compliance
- Normalization: 3NF/BCNF achieved
- Documentation: APA 7th Edition with IU modifications
- Constraints: 89+ business rule constraints
- Performance: Strategic indexing and optimization
docs/
├── PROJECT_OVERVIEW.md # Complete project status and achievements
├── TECHNICAL_DOCUMENTATION.md # Technical specifications and architecture
├── README.md # Documentation index and navigation
├── assignment/ # Original assignment documents
├── guidelines/ # Technical standards and best practices
├── submission/ # Submission requirements and checklists
├── quality/ # Evaluation criteria and standards
├── references/ # Citation guidelines and academic sources
├── changelog/ # Project version history
└── feedback/ # Phase feedback and responses
- Project Overview - Complete project status and achievements
- Technical Documentation - Technical specifications and architecture
- Installation Guide - Quick installation and setup instructions
- Documentation Index - Navigation guide for all documentation
- Naming:
snake_casefor tables and columns - Keys:
table_name_idfor primary keys - Constraints: Descriptive names with business logic
- Formatting: Consistent indentation and structure
- Comments: Comprehensive documentation for complex queries
- ✅ All SQL executes without errors
- ✅ Comprehensive constraint validation
- ✅ Realistic sample data
- ✅ Performance optimization
- ✅ Professional documentation
| Category | Weight | Focus Areas |
|---|---|---|
| Content Quality | 40% | Technical accuracy, completeness, real-world applicability |
| Methodology | 20% | Design process, documentation, justification |
| Formal Requirements | 20% | Formatting, citations, professional presentation |
| Innovation | 10% | Creative solutions, advanced features |
| Literature Research | 10% | Academic sources, proper citations |
- MySQL 8.0+ (or compatible database system)
- SQL client (DBeaver, MySQL Workbench, or command line)
- Text editor with SQL syntax highlighting
airbnb-clone-database/
├── docs/ # Comprehensive documentation
├── sql/ # SQL scripts and implementations
├── diagrams/ # ER diagrams and schemas
├── reports/ # Final academic reports
│ ├── phase1/ # Phase 1 deliverables (completed)
│ ├── phase2/ # Phase 2 deliverables (completed)
│ └── phase3/ # Phase 3 deliverables (completed)
├── data/ # Sample data files
└── Vincenti-Nikolas_9211929_DLBDSPBDM01_FINAL_SUBMISSION/ # Final submission package
- Style: APA 7th Edition with IU modifications
- Format: (Author, Year, p. XX) for in-text citations
- Sources: Academic sources only, no course materials
- Quality: Peer-reviewed journals and authoritative sources
- Reports:
LASTNAME_Firstname_DDMMYYYY_PhaseX.pdf - SQL Files:
LASTNAME_Firstname_DDMMYYYY.sql - Diagrams:
descriptive_name_vX.drawio
- Project structure and documentation framework
- Technical standards and guidelines
- Evaluation criteria and quality standards
- Phase 1: ER Model implementation (25 entities, 3 triple relationships, 1 recursive relationship)
- Phase 2: Database implementation (27 entities, 89+ constraints, bulletproof installation)
- Phase 3: Final documentation and submission
- Streamlined documentation (essential files only)
- Quality assurance framework
- Version control and change management
For questions about this academic project:
- Review the comprehensive documentation in
/docs/ - Check the Quality Standards for evaluation criteria
- Refer to Technical Standards for implementation guidelines
This project is developed for academic purposes as part of the Database Design course at IU International University. All work follows academic integrity standards and proper citation practices.
Note: This is an academic project for educational purposes. All database designs, implementations, and documentation follow university standards and academic integrity guidelines.