Skip to content

Build a database for a company which is stepping into the smartphone industry and developing an app store, to support similar applications as that of Android and iOS.

Notifications You must be signed in to change notification settings

AneshaaK/Mobile-App-Store-DB

Repository files navigation

Mobile-App-Store-DB

Our project’s core motive is to design a database that efficiently captures and plays with the data retrieved from the app store to help the business owners and marketing strategists to understand their customers better and formulate new business strategies based on this knowledge.

Data that could be retrieved from the App store:

  • App downloads per category
  • Count of single App downloads
  • Reviews of a particular App
  • Ratings of a particular App
  • Ad Revenue of a particular App
  • Cost of a particular App
  • Compliance clearance of a particular App

Project Milestones:

  1. Initial Study
  • Analysis & requirements
  • Objective
  • Scope
  • Boundaries
  • End Users
  1. Database Design (top-down approach)
  • Conceptual Design: define business rules and create ER model
  • DBMS Selection: MySQL RDBMS
  • Logical Design: data model independent of physical level details and create a data dictionary to store metadata
  • Physical Design:
  1. Implementation: Installation of the MySQL Relational DBMS in Windows Laptop
  • Downloaded Installer from url https://dev.mysql.com/downloads/mysql/
  • Use the Custom Setup option and select the Latest available versions for Server and Workbench
  • Standalone Server
  • Create root password
  • We have also installed POPSQL which is a GUI to MYSQL for better visualization
  1. Schema creation, Data loading & Conversion
  • Create a database
  • Create 1-side tables first (Category, Developer, User)
  • Create M-side tables (Application, review, Download)
  • Import data to each table using CSV files from MYSQL workbench (load data into 1-side followed by M-side tables)
  • Create views for end-users and stored procedures
  1. Testing And Evaluation
  • Structural testing (Test all the tables for Entity and Referential Integrity, mandatory fileds not null, Constraints, defalut values check)
  • Testing views and stored procedures

Images

Data Dictionary

DB Designs

Note:

SQL Code is

Conceptual ER Diagram Logical ER Diagram Physical ER Diagram

Visualizations from POPSQL GUI

  • REVIEW PER CATEGORY

image

  • RATING PER CATEGORY

image

  • FREE APP DOWNLOADS BASED ON CATEGORY

image

  • APP STORE IN-APP PURCHASES BASED ON CATEGORY image

Summary & Conclusion

A strong app store needs solid robust support for Developers and end-users to adapt, improvise and evolve continuously. A well-designed database helps understand the behavior of the users and the ratings provide insights that help drive the strategic vision of the company. The database built to support this app store as part of this project facilitates efficiently achieving the desired objectives, by keeping the total cost of ownership to a minimum.

Future Work

Contributors

Aneshaa Kasula, Viritha Vanama and Vishwas Kumar