Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need help for the following project of Android Apps Analysis: The Scenario: The Google Apps database stores many of the apps developed for android smart

Need help for the following project of Android Apps Analysis:

The Scenario:

The Google Apps database stores many of the apps developed for android smart phones and the corresponding reviews associated with the apps. The database can be created by running the following script: Create_Google.sql

The Request:

You are working for an independent third-party company that is determining for Google the current app hits and flops, as well as aggregated data for apps being developed and deployed for the Android platform.

Requirements and Information:

  1. Provide a visualization for the highest-rated apps with a user rating of at least 4.6, have at least 1000 reviews, and does not have a content rating of Everyone.
  2. Provide a visualization for the total number of apps for each of the 6 content categories.
  3. Provide a visualization for the top 3 highest rated TOOLS apps that have more than 225,000 reviews. Also, include at least 1 positive review for each of the top 3 apps in the visualization.

What to Submit:

Upload a completed lab report answering all questions and including the scripts that pulled the data and the visualizations used to effectively communicate the results

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Databases Illuminated

Authors: Catherine Ricardo

2nd Edition

1449606008, 978-1449606008

More Books

Students also viewed these Databases questions