top of page
Black Sports Car
Class: Data Management for Data Science
Apr 25, 2022

Car Sales Recommendation

Hyewon Kwon, Mehul Aggarwal, Mohamed Elmanzalawi, Jin Hwan Sim

Project Description

The final database is designed as a vehicle matching service where users may input their desired specifications and receive car recommendations curated to their preferences. There are four relations of "USER_INFO," "VEHICLE_SPECIFICATIONS," "VEHICLE_DETAILS," and "User_Saves." User_Saves relation is the last relation to store the matched truth value while finding each given information through VEHICLE_SPECIFICATIONS and VEHICLE_DETAILS.

SQL Function

  1. Create tables

  2. Insert/Update datasets

  3. Update matching results

  4. Find major issues

  5. Searching

bottom of page