- Database Setup
- Creation of some function in order to allow the creation of dynamic query from javascript
- Cleaning of the database with creation of table regarding
- Average number of bikes out by day of the week (dinstinc values of bike)
- Average number of bikes out by hour of the day and night (distinct values of bike)
- Number of bikes out by day of the year
- Rider demographics
- Creation of function that, directly from javascript allow to query on the database
- Added function that works on the data of point C
- Distribution of distance travelled by each bike
- All trips taken accross the city filtered by one day of the year
- Implementation of final queries of point C and creation of function that allow to manage data outside of the callback function
- Creation class database
- Creation of class calendar and implementation of all the relative functions
- Modification in db
- Added functions to calendar
- Added functions to class calendar
- Changed structure of some tables of the database
- Changed some queries of class database
- Updated queries regarding number of bikes, it was number of trips
- creation of all the queries regarding points A and B
- bug fixes on the application
- creation of website
- various database optimizations (views, indices, etc..)