Yorkville High School Computer Science Department
Yorkville High School Computer Science Department on Facebook  Yorkville High School Computer Science Department Twitter Feed  Yorkville High School Computer Science Department on Instagram

Yorkville High School Computer Science

ASSIGNMENTS: Video4Ever - February 21, 2019 :: UI Project Design - February 25, 2019 :: Paper Prototype - March 1, 2019 >>

Database Programming :: Projects :: Pokémon ER Diagram

Rubric
Lesson
Due: Jan 23

Problem

You are going to create an ER diagram and attribute list for the game Pokémon Go. In Pokémon Go, trainers (players) wander the world in real life to encounter creatures called Pokémon and catch them. Trainers can use these Pokémon to battle the Pokémon of other trainers at gyms, which are real-life locations. Each gym has a location stored as a latitude and longitude location (ie 40.696487, -76.270967) and a name. Trainers can leave one of their Pokémon at a friendly gym to battle rival teams. A gym can store up to 6 Pokémon and each trainer gains experience for a given gym by completing tasks at a gym such as feeding berries to Pok√©mon or battling in the gym.

Pokémon Go Teams

A trainer can have up to 250 Pokémon at a time. The Pokémon each have one or two types (ie Grass, Fire, Dark), a number of hit points (HP), a weight in kilograms, a height in meters, and combat power (CP). Each Pokémon also has two moves that each have a type and a power. Types have weaknesses and strengths compared to other types. For example, Fire Pokémon are strong against Ice, Grass, Bug, and Steel Pokémon, but are weak against Water, Ground, and Rock Pokémon. Pokémon can evolve into other Pokémon. For example, a Charmander evolves into a Carmeleon that evolves into a Charizard. Pokémon can also be found in the wild at latitude and longitude locations. Each Pokémon requires a specific amount of candy to evolve. When a Pokémon evolves it gains a certain amount of HP and CP and may change out its moves.

A trainer has a certain amount of experience (XP) that determines their level. This is different from the experience they earn to level up gyms. A trainer also has Poké coins they can use to purchase items and a team, which can be Team Instinct, Team Mystic, or Team Valor. Finally, a trainer has stardust that can be used for powering up Pokémon and candy for each Pokémon type they own that can be used to evolve Pokémon.

Instructions

Complete your ER diagram using a flowchart program such as Draw.io. You can also use a flowchart program to create your attribute list, but you can also use other suitable software. Turn in your ER diagram and attribute list to Google Drive.

Yorkville High School Computer Science Department on Facebook Yorkville High School Computer Science Department Twitter Feed Yorkville High School Computer Science Department on Instagram