4Pets - Pet-friendly hotel Database

Pet owners take their pets as friends and family members. As pet lovers, people would like to bring their pets when traveling. The goal of this project is to build up a website to help pet lovers find pet-friendly hotels by city and state. 

The database was designed using UML model, where each table has a name, a primary key(underlined), and a relationship with another table. The relationship is labeled with a name and the type (0..1, 1..1, 0..*, or 1..*). When we design the database, we also consider the data type of each element.

We retrieved more than 1000 instances of hotel data by subscribing to TripAdvisor API search service. The raw data is placed in an .txt file and imported to Google Cloud Platform using Google Colab with Python. We then wrote the api Python files for Django and connected to the Django REST API page by adding our IP address in GCP connection. The frontend is implemented with React, and the server communication is achieved with axios. 

In a group of three, I was involved in every step of the implementation of this project. I focused more on the frontend end side than the backend, but I also contributed to the implementation of the backend server

This project showcased the knowledge of SQL, NoSQL(Django), Python, React.js, GCP, and REST API.