Description: Designed and implemented a comprehensive database system inspired by Airbnb to manage property listings, user profiles, bookings, and reviews. Leveraged Java embedded SQL with MySQL for backend development.
- Developed a database to manage property listings, user profiles, bookings, and reviews, closely mirroring the functionality of Airbnb.
- Designed an ER diagram to define entities, relationships, attributes, and primary keys.
- Created a normalized relation schema and utilized DDL statements to implement the database structure.
- Implemented functionalities like user profile creation, property booking, listing creation, and cancellations with strict access control.
- Developed a terminal-based interface to interact with the database, allowing users to perform actions such as searching listings, booking properties, and leaving reviews.
- Constructed a reporting module for generating insights, including booking counts by date range and location, listing counts by country, and host/renter rankings.
- Devised an algorithm within the "Host Toolkit" to suggest listing prices and amenities, offering extra revenue predictions for adding specific amenities.
- Collaborated in a team of two to distribute tasks, manage the project, and ensure comprehensive knowledge sharing.
- Presented a successful project demo, showcasing working queries and features while explaining the implemented algorithms.
- Tools Used: Java, MySQL, ER Modeling, SQL, Terminal Interface Design.