Skip to content

JolinXiang/Pokemon-Database-Project

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

8 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Pokemon Database

Executive Summary

Our database is specifically designed to meet the needs of both new and experienced players in the POKÉMON Game. To ensure new players have the best gaming experience, we created a comprehensive database to help them quickly find out the popular POKÉMON species or easy-to-use POKÉMON species. Using these easy-to-operate, high-damage POKÉMON species will reduce the difficulty level for novice players to progress quickly in the game.

For experienced players, our database includes an ability combo search feature that allows them to quickly identify new ability changes in the latest version of the POKÉMON and to view how popular streamers and top players combine their POKÉMON abilities. This feature improves the gaming experience for players who want to keep improving their POKÉMON abilities and strategies. Our database major function:

  • For new players:
  1. Quickly find out the popular use or easy-to-use POKÉMONs
  2. Quickly find out the any combos of POKÉMONs, such as POKÉMON combo, props combo and skills combo
  • For experienced players:
  1. Quickly find out the detail information of POKÉMON, props and skills
  2. Quickly identify new ability changes in the latest version of the POKÉMON
  • For all players:
  1. Check the ranking changes of Pokémon voting in previous years and see the ranking of your favorite Pokémon
  2. Quickly view how professional and top players combine their POKÉMON abilities and their performance in a competition With a focus on accessibility, usability, and relevance, our database aims to provide an ideal solution for all skill-leveled players who want a smooth and satisfying experience in the POKÉMON game.

Client Introduction

Our database is tailored specifically to suit the needs of both casual and avid Pokemon game players. The Pokemon player base is very large. In 2021, Pokemon Go alone had 71 million active users.

Current Situation

Currently, players are playing the game and learning about the interactions of different pokemons and their abilities. However, it is difficult to keep track of these interactions and best abilities to use on specific pokemon or types of pokemon. Therefore, players would benefit tremendously from having access to a relational database that they would be able to query and extract useful information pertaining to the game.

Entity Relationship Diagram(ERD)

image

Schema

image

Database Integrity Checks

SQL Code

Queries of Database Functions

SQL Code

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published