Fetch data from Google Play, store in mySql and display data

The project is in short like this: 1. Grab some data from Google Play Store and store it in a mySql database. 2. Present the data, and view selected data in a graph Details: ====== 2 tabs: Apps tab, add app tab Apps Tab: ----------- Button "Show all" => Show all apps (default display) Drop down list "Categories" => Show only apps in the selected category - Space - List of apps, each line like this: - Checkbox (Default = false/off) - App Icon - App Name - Button "Show Stats" => Shows stats page with selected apps - Clicking on an app name, shows stats only for that app (popup) Stats Page: ------------ Show stats graph for selected apps: - Each app has its own color - Graph X-Axis = time range, Graph Y-Axis => Min=lowest number of reviews, Max=Highest number of reviews Graph is displayed using "[login to view URL]" - [login to view URL] Range Buttons: Week, Month, 3 Month, 6 Month, Year, All (=Since first stat date) Add App Tab: -------------- Show Input field + Submit button + Status field When Submit button pressed: 1. Check the input text and grab what is behind the "?id=" in the text. This is the bundle id of the app (or app_id for the database) 2. Check if app_id exist in database, if so then show message "App Already exist" in the status field. If App does NOT exist then continue 3. Check if the Developer is already in Developer database, if not add it (developer_id, name) 4. Get info from Play Store and store it in the database - Make new App in database, and fill out fields: app_id, name, appicon_link, active=true, developer_id 5. Show message "App Added Successfully" in status field Database Tables: ------------------ Developer: developer_id (string unique indexed) - taken from what's behind "?id=" in developer link on app page name (string) follow (bool) Default=false App: app_id (string unique indexed) => This is the part of the app url behind "?id=" name (string) appicon_link (string) active (bool) => Default = True developer id (int) Stats: stat_id (int autoincrement) appId (int) timestamp (int - double?) **** ???? **** date time (date/time) reviews (int) downloads (int) Category: cat_id (int autoincrement) name (string) OTHER: - Follow Publisher (new games) - I am looking for the lower end if the budget range