Database Programming :: Projects :: Pokémon ER Diagram
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.
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.
