Auto Research Website: HTML5, Database, Web Scraping

Overview v12 Research is a B2C site/iPhone/Android App where users can log-in and check used car pricing for popular Makes and Models. This is not a site/app to purchase a car but rather a site to make the buyer better informed by presenting them with relevant information. The alpha/prototype will be an HTML5 website that will be built using data for a specific Make - Ferrari. Sites (initial) [login to view URL] [login to view URL] Database Attributes Make: Ferrari Model: Model Year: Mileage: Exterior Color: Interior Color: Cylinders: Transmission: Body Type: For Sale By: Drive Type: Engine Description: Vin # Options (i.e. Yellow Brake Callipers, Yellow Tachometer, Daytona Seats) Link to Online Listing: Price: Image: (if we can pull in image to database) Reporting Initial reporting functionality will show the user: Average Price Average Price (by exterior color) Average Price (by interior color) Average Price (by Model Year) Median Price Median Price (by exterior color) Median Price (by interior color) Median Price (by Model Year) If time allows, we can chart this data over time What needs to be built: 1. Database schema with additional thinking about what can/should be added (keeping in mind the future vision of tracking any/all cars) 2. Scraping script of the sites listed above with the ability to add additional sites as we move past Alpha/Prototype 3. Setup of HTML5 site (simple site) that allows the user to enter Make/Model (per above) and receive a report. Should be very basic for Alpha/Prototype. Logo will be provided. 4. Setup of AWS or similar cloud database in order to keep tracking the sites for scraping of data. 5. Ability to manually input car data to database thru easy form and/or CSV file Notes No user log-in/account setup system needs to be created for this prototype/alpha. Any user who goes to this site has the ability to query the search engine. Limited traffic to this site, will be promoted to [login to view URL] and limited network to test.