Mandrake Potter (Harry Potter’s son) began playing Pokémon Go last summer using

Burdened by Homework? Let us write your essays and assignments Order This Now

Mandrake Potter (Harry Potter’s son) began playing Pokémon Go last summer using two different phones. He recorded his battles using a spreadsheet. See Figure 1 for a section (Figure 1).
Date My Pokémon Number My Pokémon Name My Pokémon Type My Pokémon Enemy My enemy Type Winner Battle Duration (minutes) Device Phone’s OS
1/4/2020 12 Charmander Fire Tranquill Flying Tranquill 6 Phone 1 Android
1/14/2020 14 Litleo Fire Cleffa Fairy Litleo 11 Phone 2 IPhone
2/5/2020 1 Phione Water Seviper Poison Phione 7 Phone 2 IPhone
2/5/2020 3 Marshtomp Water Pansear Fire Marshtomp 6 Phone 2 IPhone
4/12/2020 7 Megearna Steel Cobalion Fighting Megearna 7 Phone 1 Android
5/21/2020 12 Charmander Fire Celebi Psychic Celebi 8 Phone1 Android
6/1/2020 9 Pinsir Bug Duskull Ghost Pinsir 10 Phone 2 IPhone
Figure 1
The plan is to construct a simple computer system to handle Harry’s Pokémon Battles and Pokémons. Assume that Mandrake and their opponents have only one Pokémon of any given type (i.e., nobody has two Pikachus).
This assignment has two deliverables:
1. Word document/pdf: With your knowledge of the case and listing any assumptions, develop an ERD for the system’s database. Include Tables’ names, attributes (PK & FK), and cardinalities (3NF).
2. Access file with the database: For this assignment you must submit an Access file with your design (AACDB). Your database must include data.
You can add entities/attributes you consider convenient.

Burdened by Homework? Let us write your essays and assignments Order This Now

Leave a comment