Simple Yelp Website
Portfolio | | Links: Github | Report | Demo Video
I developed a multi-page website called Simple Yelp, which has basic functionality of Yelp, allowing users to evaluate restaurants and businesses based on detailed reviews. The application uses a standard client-server architecture, with a MySQL database hosted on AWS RDS. The server, powered by NodeJS and Express, constructs routes to query the database, while the frontend, built with ReactJS, facilitates smooth user interactions and renders pages in the browser. The platform leverages open-source data from Yelp, including over 7 million records in the review table. To ensure data integrity, I decomposed the data into Third Normal Form (3NF). I also optimized complex queries, such as those for featured reviews and nearby businesses based on user geo-locations, significantly improving performance through indexing. The full code, report, and a demo video are available on GitHub.
