Tweet
Tweet

Slide 1

Slide 1 text

No content

Slide 2

Slide 2 text

https://www.pngwing.com/en/free-png-yrzeu THE PROTAGONIST

Slide 3

Slide 3 text

THE PROTAGONIST https://i0.wp.com/sourcegaming.info/wp-content/uploads/ 2019/02/Pok%C3%A9mon-Red-Title-Screen.png?ssl=1

Slide 4

Slide 4 text

THE PRODUCT OWNER

Slide 5

Slide 5 text

THE PRODUCT OWNER www.reddit.com%2Fr%2FPrequelMemes%2Fcomments%2F95xlr6%2Fprof_oak_w as_prequel_meming_from_the_start%2F&psig=AOvVaw2fgcyXA9F0ZACYt_DRGF9- &ust=1667994961610000&source=images&cd=vfe&ved=0CA0QjRxqFwoTCPjQ78_D nvsCFQAAAAAdAAAAABAI

Slide 6

Slide 6 text

THE GOAL

Slide 7

Slide 7 text

THE GOAL https://res.cloudinary.com/practicaldev/image/fetch/ s--nLj6mJg7--/ c_limit%2Cf_auto%2C fl _progressive%2Cq_auto%2C w_880/https://dev-to-uploads.s3.amazonaws.com/i/ 14najv2lahpooiy0eiev.png

Slide 8

Slide 8 text

No content

Slide 9

Slide 9 text

POKéDEX Database Normalisation in Practice Mateusz ciejj Wozniczka ‘ 8.12.22 @ VISUALITY

Slide 10

Slide 10 text

DOMAIN EXPERT :)

Slide 11

Slide 11 text

DOMAIN EXPERT :)

Slide 12

Slide 12 text

1st ENTRY NAME STATS TYPE STRONG VS WEAK VS MOVE

Slide 13

Slide 13 text

1st ENTRY NAME STATS TYPE STRONG VS WEAK VS MOVE Charmander attack: 52, defense: 43 Fire Grass Water Ember

Slide 14

Slide 14 text

FIRST FIGHT

Slide 15

Slide 15 text

FIRST FIGHT http://www.elder-geek.com/reviews/Classic/_images/hqdefault.jpg

Slide 16

Slide 16 text

2nd ENTRY NAME STATS TYPE STRONG VS WEAK VS MOVE Charmander attack: 52, defense: 43 Fire Grass Water Ember

Slide 17

Slide 17 text

2nd ENTRY NAME STATS TYPE STRONG VS WEAK VS MOVE Charmander attack: 52, defense: 43 Fire Grass Water Ember Squirtle attack: 44, defense: 48 Water Fire Grass Bubble

Slide 18

Slide 18 text

3rd ENTRY NAME STATS TYPE STRONG VS WEAK VS MOVE Charmander attack: 52, defense: 43 Fire Grass Water Ember Squirtle attack: 44, defense: 48 Water Fire Grass Bubble

Slide 19

Slide 19 text

3rd ENTRY NAME STATS TYPE STRONG VS WEAK VS MOVE Charmander attack: 52, defense: 43 Fire Grass Water Ember Squirtle attack: 44, defense: 48 Water Fire Grass Bubble Bulbasaur attack: 49, defense: 49 Grass Water Fire Whip

Slide 20

Slide 20 text

4th ENTRY NAME STATS TYPE STRONG VS WEAK VS MOVE Charmander attack: 52, defense: 43 Fire Grass Water Ember Squirtle attack: 44, defense: 48 Water Fire Grass Bubble Bulbasaur attack: 49, defense: 49 Grass Water Fire Whip

Slide 21

Slide 21 text

4th ENTRY NAME STATS TYPE STRONG VS WEAK VS MOVE Charmander attack: 52, defense: 43 Fire Grass Water Ember Squirtle attack: 44, defense: 48 Water Fire Grass Bubble Bulbasaur attack: 49, defense: 49 Grass Water Fire Whip Charmeleon att: 62, def: 58 Fire Grass Water Ember

Slide 22

Slide 22 text

No content

Slide 23

Slide 23 text

NEW BUSINESS REQUIREMENT!!! Pokémons can evolve https://bulbapedia.bulbagarden.net/wiki/ File:PkmnProfWantsToFight.png

Slide 24

Slide 24 text

NEW BUSINESS REQUIREMENT NAME Charmander Squirtle Bulbasaur Charmeleon STATS attack: 52, defense: 43 attack: 44, defense: 48 attack: 49, defense: 49 att: 62, def: 58 TYPE Fire Water Grass Fire STRONG VS Grass Fire Water Grass WEAK VS Water Grass Fire Water MOVE Ember Bubble Whip Ember Pokémons can evolve

Slide 25

Slide 25 text

NEW BUSINESS REQUIREMENT NAME Charmander Squirtle Bulbasaur Charmeleon STATS attack: 52, defense: 43 attack: 44, defense: 48 attack: 49, defense: 49 att: 62, def: 58 TYPE Fire Water Grass Fire STRONG VS Grass Fire Water Grass WEAK VS Water Grass Fire Water MOVE Ember Bubble Whip Ember NEXT FORM Charmeleon Wartortle Ivysaur Charizard Pokémons can evolve

Slide 26

Slide 26 text

NAME STATS TYPE STRONG VS WEAK VS MOVE NEXT FORM Charmander attack: 52, defense: 43 Fire Grass Water Ember Charmeleon Squirtle attack: 44, defense: 48 Water Fire Grass Bubble Wartortle Bulbasaur attack: 49, defense: 49 Grass Water Fire Whip Ivysaur Charmeleon att: 62, def: 58 Fire Grass Water Ember Charizard NEXT ENTRY

Slide 27

Slide 27 text

NAME STATS TYPE STRONG VS WEAK VS MOVE NEXT FORM Charmander attack: 52, defense: 43 Fire Grass Water Ember Charmeleon Squirtle attack: 44, defense: 48 Water Fire Grass Bubble Wartortle Bulbasaur attack: 49, defense: 49 Grass Water Fire Whip Ivysaur Charmeleon att: 62, def: 58 Fire Grass Water Ember Charizard Butterfree Att: 45, DEF: 50 Bug Grass Fire Bite NEXT ENTRY

Slide 28

Slide 28 text

https://bulbapedia.bulbagarden.net/wiki/ File:PkmnProfWantsToFight.png

Slide 29

Slide 29 text

NEW BUSINESS REQUIREMENT!!! Pokémons can have multiple moves https://bulbapedia.bulbagarden.net/wiki/ File:PkmnProfWantsToFight.png

Slide 30

Slide 30 text

NAME STATS TYPE STRONG VS WEAK VS MOVE NEXT FORM Charmander attack: 52, defense: 43 Fire Grass Water Ember Charmeleon Squirtle attack: 44, defense: 48 Water Fire Grass Bubble Wartortle Bulbasaur attack: 49, defense: 49 Grass Water Fire Whip Ivysaur Charmeleon att: 62, def: 58 Fire Grass Water Ember Charizard Butterfree Att: 45, DEF: 50 Bug Grass Fire Bite NEW BUSINESS REQUIREMENT Pokémons can have multiple moves

Slide 31

Slide 31 text

NAME STATS TYPE STRONG VS WEAK VS MOVES NEXT FORM Charmander attack: 52, defense: 43 Fire Grass Water Ember Charmeleon Squirtle attack: 44, defense: 48 Water Fire Grass Bubble Wartortle Bulbasaur attack: 49, defense: 49 Grass Water Fire Whip Ivysaur Charmeleon att: 62, def: 58 Fire Grass Water Ember Charizard Butterfree Att: 45, DEF: 50 Bug Grass Fire Bite NEW BUSINESS REQUIREMENT Pokémons can have multiple moves

Slide 32

Slide 32 text

NAME STATS TYPE STRONG VS WEAK VS MOVES NEXT FORM Charmander attack: 52, defense: 43 Fire Grass Water Ember Inferno Charmeleon Squirtle attack: 44, defense: 48 Water Fire Grass Bubble Waterjet Wartortle Bulbasaur attack: 49, defense: 49 Grass Water Fire Whip Leech Seed Ivysaur Charmeleon att: 62, def: 58 Fire Grass Water Ember Inferno Charizard Butterfree Att: 45, DEF: 50 Bug Grass Fire Bite Tackle Gust NEW BUSINESS REQUIREMENT Pokémons can have multiple moves

Slide 33

Slide 33 text

NAME STATS TYPE STRONG VS WEAK VS MOVES NEXT FORM Charmander attack: 52, defense: 43 Fire Grass Water Ember Inferno Charmeleon Squirtle attack: 44, defense: 48 Water Fire Grass Bubble Waterjet Wartortle Bulbasaur attack: 49, defense: 49 Grass Water Fire Whip Leech Seed Ivysaur Charmeleon att: 62, def: 58 Fire Grass Water Ember Inferno Charizard Butterfree Att: 45, DEF: 50 Bug Grass Fire Bite Tackle Gust NEW BUSINESS REQUIREMENT Pokémons can have multiple moves

Slide 34

Slide 34 text

PROBLEM 1 Stats are not uniform NAME STATS TYPE STRONG VS WEAK VS MOVES NEXT FORM Charmander attack: 52, defense: 43 Fire Grass Water Ember Inferno Charmeleon Squirtle attack: 44, defense: 48 Water Fire Grass Bubble Waterjet Wartortle Bulbasaur attack: 49, defense: 49 Grass Water Fire Whip Leech Seed Ivysaur Charmeleon att: 62, def: 58 Fire Grass Water Ember Inferno Charizard Butterfree Att: 45, DEF: 50 Bug Grass Fire Bite Tackle Gust

Slide 35

Slide 35 text

PROBLEMS

Slide 36

Slide 36 text

PROBLEMS 1. NON-ATOMIC VALUES CAN LEAD TO INCONSISTENCIES

Slide 37

Slide 37 text

PROBLEM 1 Stats are not uniform NAME STATS TYPE STRONG VS WEAK VS MOVES NEXT FORM Charmander attack: 52, defense: 43 Fire Grass Water Ember Inferno Charmeleon Squirtle attack: 44, defense: 48 Water Fire Grass Bubble Waterjet Wartortle Bulbasaur attack: 49, defense: 49 Grass Water Fire Whip Leech Seed Ivysaur Charmeleon att: 62, def: 58 Fire Grass Water Ember Inferno Charizard Butterfree Att: 45, DEF: 50 Bug Grass Fire Bite Tackle Gust

Slide 38

Slide 38 text

PROBLEM 1 - FIXED Stats are uniform NAME ATTACK DEFENSE TYPE STRONG VS WEAK VS MOVES NEXT FORM Charmander 52 43 Fire Grass Water Ember Inferno Charmeleon Squirtle 44 48 Water Fire Grass Bubble Waterjet Wartortle Bulbasaur 49 49 Grass Water Fire Whip Leech Seed Ivysaur Charmeleon 62 58 Fire Grass Water Ember Inferno Charizard Butterfree 45 50 Bug Grass Fire Bite Tuckle Gust

Slide 39

Slide 39 text

PROBLEM 1 - FIXED Stats are uniform NAME ATTACK DEFENSE TYPE STRONG VS WEAK VS MOVES NEXT FORM Charmander 52 43 Fire Grass Water Ember Inferno Charmeleon Squirtle 44 48 Water Fire Grass Bubble Waterjet Wartortle Bulbasaur 49 49 Grass Water Fire Whip Leech Seed Ivysaur Charmeleon 62 58 Fire Grass Water Ember Inferno Charizard Butterfree 45 50 Bug Grass Fire Bite Tuckle Gust

Slide 40

Slide 40 text

PROBLEM 2 Editing is not easy NAME ATTACK DEFENSE TYPE STRONG VS WEAK VS MOVES NEXT FORM Charmander 52 43 Fire Grass Water Ember Inferno Charmeleon Squirtle 44 48 Water Fire Grass Bubble Waterjet Wartortle Bulbasaur 49 49 Grass Water Fire Whip Leech Seed Ivysaur Charmeleon 62 58 Fire Grass Water Ember Inferno Charizard Butterfree 45 50 Bug Grass Fire Bite Tuckle Gust

Slide 41

Slide 41 text

NAME ATTACK DEFENSE TYPE STRONG VS WEAK VS MOVES NEXT FORM Charmander 52 43 Fire Grass Water Ember Inferno Charmeleon Squirtle 44 48 Water Fire Grass Bubble Waterjet Wartortle Bulbasaur 49 49 Grass Water Fire Whip Leech Seed Ivysaur Charmeleon 62 58 Fire Grass Water Ember Inferno Charizard Butterfree 45 50 Bug Grass Fire Bite Tuckle Gust PROBLEM 2 Editing is not easy

Slide 42

Slide 42 text

NAME ATTACK DEFENSE TYPE STRONG VS WEAK VS MOVES NEXT FORM Charmander 52 43 Fire Bug Water Ember Inferno Charmeleon Squirtle 44 48 Water Fire Grass Bubble Waterjet Wartortle Bulbasaur 49 49 Grass Water Fire Whip Leech Seed Ivysaur Charmeleon 62 58 Fire Grass Water Ember Inferno Charizard Butterfree 45 50 Bug Grass Fire Bite Tuckle Gust PROBLEM 2 Editing is not easy

Slide 43

Slide 43 text

NAME ATTACK DEFENSE TYPE STRONG VS WEAK VS MOVES NEXT FORM Charmander 52 43 Fire Bug Water Ember Inferno Charmeleon Squirtle 44 48 Water Fire Grass Bubble Waterjet Wartortle Bulbasaur 49 49 Grass Water Fire Whip Leech Seed Ivysaur Charmeleon 62 58 Fire Grass Water Ember Inferno Charizard Butterfree 45 50 Bug Grass Fire Bite Tuckle Gust PROBLEM 2 Editing is not easy

Slide 44

Slide 44 text

NAME ATTACK DEFENSE TYPE STRONG VS WEAK VS MOVES NEXT FORM Charmander 52 43 Fire Grass Water Ember Inferno Charmeleon Squirtle 44 48 Water Fire Grass Bubble Waterjet Wartortle Bulbasaur 49 49 Grass Water Fire Whip Leech Seed Ivysaur Charmeleon 62 58 Fire Grass Water Ember Inferno Charizard Butterfree 45 50 Bug Grass Fire Bite Tuckle Gust PROBLEM 2 Editing is not easy

Slide 45

Slide 45 text

PROBLEMS 1. NON-ATOMIC VALUES CAN LEAD TO INCONSISTENCIES

Slide 46

Slide 46 text

PROBLEMS 1. NON-ATOMIC VALUES CAN LEAD TO INCONSISTENCIES 2. SOME VALUES HAVE TO BE EDITED IN MULTIPLE PLACES

Slide 47

Slide 47 text

NEW ENTRY NAME ATTACK DEFENSE TYPE STRONG VS WEAK VS MOVES NEXT FORM Charmander 52 43 Fire Grass Water Ember Inferno Charmeleon Squirtle 44 48 Water Fire Grass Bubble Waterjet Wartortle Bulbasaur 49 49 Grass Water Fire Whip Leech Seed Ivysaur Charmeleon 62 58 Fire Grass Water Ember Inferno Charizard Butterfree 45 50 Bug Grass Fire Bite Tuckle Gust

Slide 48

Slide 48 text

NEW ENTRY NAME ATTACK DEFENSE TYPE STRONG VS WEAK VS MOVES NEXT FORM Charmander 52 43 Fire Grass Water Ember Inferno Charmeleon Squirtle 44 48 Water Fire Grass Bubble Waterjet Wartortle Bulbasaur 49 49 Grass Water Fire Whip Leech Seed Ivysaur Charmeleon 62 58 Fire Grass Water Ember Inferno Charizard Butterfree 45 50 Bug Grass Fire Bite Tuckle Gust Rock 0 100 Rock Fire Grass

Slide 49

Slide 49 text

PROBLEM 3 NAME ATTACK DEFENSE TYPE STRONG VS WEAK VS MOVES NEXT FORM Charmander 52 43 Fire Grass Water Ember Inferno Charmeleon Squirtle 44 48 Water Fire Grass Bubble Waterjet Wartortle Bulbasaur 49 49 Grass Water Fire Whip Leech Seed Ivysaur Charmeleon 62 58 Fire Grass Water Ember Inferno Charizard Butterfree 45 50 Bug Grass Fire Bite Tuckle Gust Rock 0 100 Rock Fire Grass Empty cells

Slide 50

Slide 50 text

PROBLEM 3 NAME ATTACK DEFENSE TYPE STRONG VS WEAK VS MOVES NEXT FORM Charmander 52 43 Fire Grass Water Ember Inferno Charmeleon Squirtle 44 48 Water Fire Grass Bubble Waterjet Wartortle Bulbasaur 49 49 Grass Water Fire Whip Leech Seed Ivysaur Charmeleon 62 58 Fire Grass Water Ember Inferno Charizard Butterfree 45 50 Bug Grass Fire Bite Tuckle Gust Rock 0 100 Rock Fire Grass Empty cells

Slide 51

Slide 51 text

PROBLEMS 1. NON-ATOMIC VALUES CAN LEAD TO INCONSISTENCIES 2. SOME VALUES HAVE TO BE EDITED IN MULTIPLE PLACES

Slide 52

Slide 52 text

PROBLEMS 1. NON-ATOMIC VALUES CAN LEAD TO INCONSISTENCIES 2. SOME VALUES HAVE TO BE EDITED IN MULTIPLE PLACES 3. EMPTY CELLS

Slide 53

Slide 53 text

PROBLEM 4 NAME ATTACK DEFENSE TYPE STRONG VS WEAK VS MOVES NEXT FORM Charmander 52 43 Fire Grass Water Ember Inferno Charmeleon Squirtle 44 48 Water Fire Grass Bubble Waterjet Wartortle Bulbasaur 49 49 Grass Water Fire Whip Leech Seed Ivysaur Charmeleon 62 58 Fire Grass Water Ember Inferno Charizard Butterfree 45 50 Bug Grass Fire Bite Tuckle Gust Rock 0 100 Rock Fire Grass Deleting can be problematic

Slide 54

Slide 54 text

PROBLEM 4 NAME ATTACK DEFENSE TYPE STRONG VS WEAK VS MOVES NEXT FORM Charmander 52 43 Fire Grass Water Ember Inferno Charmeleon Squirtle 44 48 Water Fire Grass Bubble Waterjet Wartortle Bulbasaur 49 49 Grass Water Fire Whip Leech Seed Ivysaur Charmeleon 62 58 Fire Grass Water Ember Inferno Charizard Butterfree 45 50 Bug Grass Fire Bite Tuckle Gust Rock 0 100 Rock Fire Grass Deleting can be problematic

Slide 55

Slide 55 text

PROBLEM 5 NAME ATTACK DEFENSE TYPE STRONG VS WEAK VS MOVES NEXT FORM Charmander 52 43 Fire Grass Water Ember Inferno Charmeleon Squirtle 44 48 Water Fire Grass Bubble Waterjet Wartortle Bulbasaur 49 49 Grass Water Fire Whip Leech Seed Ivysaur Charmeleon 62 58 Fire Grass Water Ember Inferno Charizard Butterfree 45 50 Bug Grass Fire Bite Tuckle Gust Rock Fire Grass Can’t keep info about type only

Slide 56

Slide 56 text

PROBLEMS 1. NON-ATOMIC VALUES CAN LEAD TO INCONSISTENCIES 2. SOME VALUES HAVE TO BE EDITED IN MULTIPLE PLACES 3. A LOT OF EMPTY CELLS

Slide 57

Slide 57 text

PROBLEMS 1. NON-ATOMIC VALUES CAN LEAD TO INCONSISTENCIES 2. SOME VALUES HAVE TO BE EDITED IN MULTIPLE PLACES 4. ROWS DELETION CAN LEAD TO UNWANTED DATA LOSS 3. A LOT OF EMPTY CELLS

Slide 58

Slide 58 text

PROBLEMS 5. CAN’T STORE DATA ABOUT THE TYPES ONLY 1. NON-ATOMIC VALUES CAN LEAD TO INCONSISTENCIES 2. SOME VALUES HAVE TO BE EDITED IN MULTIPLE PLACES 4. ROWS DELETION CAN LEAD TO UNWANTED DATA LOSS 3. A LOT OF EMPTY CELLS

Slide 59

Slide 59 text

https://bulbapedia.bulbagarden.net/wiki/ File:PkmnProfWantsToFight.png

Slide 60

Slide 60 text

NEW BUSINESS REQUIREMENT!!! Pokemons have ids https://bulbapedia.bulbagarden.net/wiki/ File:PkmnProfWantsToFight.png

Slide 61

Slide 61 text

NEW BUSINESS REQUIREMENT!!! Pokemons have ids https://bulbapedia.bulbagarden.net/wiki/ File:PkmnProfWantsToFight.png

Slide 62

Slide 62 text

NEXT FORM Charmeleon Wartortle Ivysaur Charizard MOVES Ember Inferno Bubble Waterjet Whip Leech Seed Ember Inferno Bite Tuckle Gust WEAK VS Water Grass Fire Water Fire Grass STRONG VS Grass Fire Water Grass Grass Fire TYPE Fire Water Grass Fire Bug Rock DEFENSE 43 48 49 58 50 100 ATTACK 52 44 49 62 45 0 NAME Charmander Squirtle Bulbasaur Charmeleon Butterfree Rock NEW BUSINESS REQUIREMENT!!! Pokemons have ids

Slide 63

Slide 63 text

NEXT FORM Charmeleon Wartortle Ivysaur Charizard MOVES Ember Inferno Bubble Waterjet Whip Leech Seed Ember Inferno Bite Tuckle Gust WEAK VS Water Grass Fire Water Fire Grass STRONG VS Grass Fire Water Grass Grass Fire TYPE Fire Water Grass Fire Bug Rock DEFENSE 43 48 49 58 50 100 ATTACK 52 44 49 62 45 0 NAME Charmander Squirtle Bulbasaur Charmeleon Butterfree Rock ID 1 2 3 4 5 6 NEW BUSINESS REQUIREMENT!!! Pokemons have ids

Slide 64

Slide 64 text

ID NAME ATTACK DEFENSE TYPE STRONG VS WEAK VS MOVES NEXT FORM 1 Charmander 52 43 Fire Grass Water Ember Inferno Charmeleon 2 Squirtle 44 48 Water Fire Grass Bubble Waterjet Wartortle 3 Bulbasaur 49 49 Grass Water Fire Whip Leech Seed Ivysaur 4 Charmeleon 62 58 Fire Grass Water Ember Inferno Charizard 5 Butterfree 45 50 Bug Grass Fire Bite Tuckle Gust 6 Rock 0 100 Rock Fire Grass IMPROVEMENT IDEA Use ID instead of NAME

Slide 65

Slide 65 text

ID NAME ATTACK DEFENSE TYPE STRONG VS WEAK VS MOVES NEXT FORM ID 1 Charmander 52 43 Fire Grass Water Ember Inferno Charmeleon 2 Squirtle 44 48 Water Fire Grass Bubble Waterjet Wartortle 3 Bulbasaur 49 49 Grass Water Fire Whip Leech Seed Ivysaur 4 Charmeleon 62 58 Fire Grass Water Ember Inferno Charizard 5 Butterfree 45 50 Bug Grass Fire Bite Tuckle Gust 6 Rock 0 100 Rock Fire Grass IMPROVEMENT IDEA Use ID instead of NAME

Slide 66

Slide 66 text

ID NAME ATTACK DEFENSE TYPE STRONG VS WEAK VS MOVES NEXT FORM ID 1 Charmander 52 43 Fire Grass Water Ember Inferno 4 2 Squirtle 44 48 Water Fire Grass Bubble Waterjet 7 3 Bulbasaur 49 49 Grass Water Fire Whip Leech Seed 10 4 Charmeleon 62 58 Fire Grass Water Ember Inferno 12 5 Butterfree 45 50 Bug Grass Fire Bite Tuckle Gust 6 Rock 0 100 Rock Fire Grass IMPROVEMENT IDEA Use ID instead of NAME

Slide 67

Slide 67 text

ID NAME ATTACK DEFENSE TYPE STRONG VS WEAK VS MOVES NEXT FORM ID 1 Charmander 52 43 Fire Grass Water Ember Inferno 4 2 Squirtle 44 48 Water Fire Grass Bubble Waterjet 7 3 Bulbasaur 49 49 Grass Water Fire Whip Leech Seed 10 4 Charmeleon 62 58 Fire Grass Water Ember Inferno 12 5 Butterfree 45 50 Bug Grass Fire Bite Tuckle Gust 6 Rock 0 100 Rock Fire Grass IMPROVEMENT IDEA Use ID instead of NAME

Slide 68

Slide 68 text

https://bulbapedia.bulbagarden.net/wiki/ File:PkmnProfWantsToFight.png

Slide 69

Slide 69 text

NEW BUSINESS REQUIREMENT!!! Moves also have types https://bulbapedia.bulbagarden.net/wiki/ File:PkmnProfWantsToFight.png

Slide 70

Slide 70 text

NEW BUSINESS REQUIREMENT Moves also have types ID NAME ATTACK DEFENSE TYPE STRONG VS WEAK VS MOVES NEXT FORM ID 1 Charmander 52 43 Fire Grass Water Ember Inferno 4 2 Squirtle 44 48 Water Fire Grass Bubble Waterjet 7 3 Bulbasaur 49 49 Grass Water Fire Whip Leech Seed 10 4 Charmeleon 62 58 Fire Grass Water Ember Inferno 12 5 Butterfree 45 50 Bug Grass Fire Bite Tuckle Gust 6 Rock 0 100 Rock Fire Grass

Slide 71

Slide 71 text

No content

Slide 72

Slide 72 text

WHAT? TABLE IS EVOLVING!!!

Slide 73

Slide 73 text

TABLE EVOLUTION EVOLUTIONARY STAGE 1 ID NAME ATTACK DEFENSE TYPE STRONG VS WEAK VS MOVES NEXT FORM ID 1 Charmander 52 43 Fire Grass Water Ember Inferno 4 2 Squirtle 44 48 Water Fire Grass Bubble Waterjet 7 3 Bulbasaur 49 49 Grass Water Fire Whip Leech Seed 10 4 Charmeleon 62 58 Fire Grass Water Ember Inferno 12 5 Butterfree 45 50 Bug Grass Fire Bite Tuckle Gust 6 Rock 0 100 Rock Fire Grass

Slide 74

Slide 74 text

TABLE EVOLUTION EVOLUTIONARY STAGE 1 ID NAME ATTACK DEFENSE TYPE STRONG VS WEAK VS MOVE NEXT FORM ID 1 Charmander 52 43 Fire Grass Water Ember 4 1 Charmander 52 43 Fire Grass Water Inferno 4 2 Squirtle 44 48 Water Fire Grass Bubble 7 2 Squirtle 44 48 Water Fire Grass Waterjet 7 3 Bulbasaur 49 49 Grass Water Fire Whip 10 3 Bulbasaur 49 49 Grass Water Fire Leech Seed 10 4 Charmeleon 62 58 Fire Grass Water Ember 12 4 Charmeleon 62 58 Fire Grass Water Inferno 12 5 Butterfree 45 50 Bug Grass Fire Bite 5 Butterfree 45 50 Bug Grass Fire Tuckle 5 Butterfree 45 50 Bug Grass Fire Gust 6 Rock 0 100 Rock Fire Grass

Slide 75

Slide 75 text

TABLE EVOLUTION EVOLUTIONARY STAGE 1 ID NAME ATTACK DEFENSE TYPE STRONG VS WEAK VS MOVE NEXT FORM ID 1 Charmander 52 43 Fire Grass Water Ember 4 1 Charmander 52 43 Fire Grass Water Inferno 4 2 Squirtle 44 48 Water Fire Grass Bubble 7 2 Squirtle 44 48 Water Fire Grass Waterjet 7 3 Bulbasaur 49 49 Grass Water Fire Whip 10 3 Bulbasaur 49 49 Grass Water Fire Leech Seed 10 4 Charmeleon 62 58 Fire Grass Water Ember 12 4 Charmeleon 62 58 Fire Grass Water Inferno 12 5 Butterfree 45 50 Bug Grass Fire Bite 5 Butterfree 45 50 Bug Grass Fire Tuckle 5 Butterfree 45 50 Bug Grass Fire Gust 6 Rock 0 100 Rock Fire Grass

Slide 76

Slide 76 text

TABLE EVOLUTION EVOLUTIONARY STAGE 1 ID NAME ATTACK DEFENSE TYPE STRONG VS WEAK VS MOVE MOVE TYPE NEXT FORM ID 1 Charmander 52 43 Fire Grass Water Ember 4 1 Charmander 52 43 Fire Grass Water Inferno 4 2 Squirtle 44 48 Water Fire Grass Bubble 7 2 Squirtle 44 48 Water Fire Grass Waterjet 7 3 Bulbasaur 49 49 Grass Water Fire Whip 10 3 Bulbasaur 49 49 Grass Water Fire Leech Seed 10 4 Charmeleon 62 58 Fire Grass Water Ember 12 4 Charmeleon 62 58 Fire Grass Water Inferno 12 5 Butterfree 45 50 Bug Grass Fire Bite 5 Butterfree 45 50 Bug Grass Fire Tuckle 5 Butterfree 45 50 Bug Grass Fire Gust 6 Rock 0 100 Rock Fire Grass

Slide 77

Slide 77 text

TABLE EVOLUTION EVOLUTIONARY STAGE 1 ID NAME ATTACK DEFENSE TYPE STRONG VS WEAK VS MOVE MOVE TYPE NEXT FORM ID 1 Charmander 52 43 Fire Grass Water Ember Fire 4 1 Charmander 52 43 Fire Grass Water Inferno Fire 4 2 Squirtle 44 48 Water Fire Grass Bubble Water 7 2 Squirtle 44 48 Water Fire Grass Waterjet Water 7 3 Bulbasaur 49 49 Grass Water Fire Whip Normal 10 3 Bulbasaur 49 49 Grass Water Fire Leech Seed Grass 10 4 Charmeleon 62 58 Fire Grass Water Ember Fire 12 4 Charmeleon 62 58 Fire Grass Water Inferno Fire 12 5 Butterfree 45 50 Bug Grass Fire Bite Normal 5 Butterfree 45 50 Bug Grass Fire Tuckle Normal 5 Butterfree 45 50 Bug Grass Fire Gust Normal 6 Rock 0 100 Rock Fire Grass

Slide 78

Slide 78 text

TABLE EVOLUTION EVOLUTIONARY STAGE 1 ID NAME ATTACK DEFENSE TYPE STRONG VS WEAK VS MOVE MOVE TYPE NEXT FORM ID 1 Charmander 52 43 Fire Grass Water Ember Fire 4 1 Charmander 52 43 Fire Grass Water Inferno Fire 4 2 Squirtle 44 48 Water Fire Grass Bubble Water 7 2 Squirtle 44 48 Water Fire Grass Waterjet Water 7 3 Bulbasaur 49 49 Grass Water Fire Whip Normal 10 3 Bulbasaur 49 49 Grass Water Fire Leech Seed Grass 10 4 Charmeleon 62 58 Fire Grass Water Ember Fire 12 4 Charmeleon 62 58 Fire Grass Water Inferno Fire 12 5 Butterfree 45 50 Bug Grass Fire Bite Normal 5 Butterfree 45 50 Bug Grass Fire Tuckle Normal 5 Butterfree 45 50 Bug Grass Fire Gust Normal 6 Rock 0 100 Rock Fire Grass

Slide 79

Slide 79 text

PROBLEMS 5. CAN’T STORE DATA ABOUT THE TYPES ONLY 1. NON-ATOMIC VALUES CAN LEAD TO INCONSISTENCIES 2. SOME VALUES HAVE TO BE EDITED IN MULTIPLE PLACES 4. ROWS DELETION CAN LEAD TO UNWANTED DATA LOSS 3. A LOT OF EMPTY CELLS

Slide 80

Slide 80 text

PROBLEMS 5. CAN’T STORE DATA ABOUT THE TYPES ONLY 1. NON-ATOMIC VALUES CAN LEAD TO INCONSISTENCIES 2. SOME VALUES HAVE TO BE EDITED IN MULTIPLE PLACES 4. ROWS DELETION CAN LEAD TO UNWANTED DATA LOSS 3. A LOT OF EMPTY CELLS

Slide 81

Slide 81 text

PROBLEMS 5. CAN’T STORE DATA ABOUT THE TYPES ONLY 1. NON-ATOMIC VALUES CAN LEAD TO INCONSISTENCIES 2. SOME VALUES HAVE TO BE EDITED IN MULTIPLE PLACES 4. ROWS DELETION CAN LEAD TO UNWANTED DATA LOSS 3. A LOT OF EMPTY CELLS 6. A LOT OF DUPLICATE DATA

Slide 82

Slide 82 text

No content

Slide 83

Slide 83 text

WHAT? TABLE IS EVOLVING!!!

Slide 84

Slide 84 text

TABLE EVOLUTION EVOLUTIONARY STAGE 2 ID NAME ATTACK DEFENSE TYPE STRONG VS WEAK VS MOVE MOVE TYPE NEXT FORM ID 1 Charmander 52 43 Fire Grass Water Ember Fire 4 1 Charmander 52 43 Fire Grass Water Inferno Fire 4 2 Squirtle 44 48 Water Fire Grass Bubble Water 7 2 Squirtle 44 48 Water Fire Grass Waterjet Water 7 3 Bulbasaur 49 49 Grass Water Fire Whip Normal 10 3 Bulbasaur 49 49 Grass Water Fire Leech Seed Grass 10 4 Charmeleon 62 58 Fire Grass Water Ember Fire 12 4 Charmeleon 62 58 Fire Grass Water Inferno Fire 12 5 Butterfree 45 50 Bug Grass Fire Bite Normal 5 Butterfree 45 50 Bug Grass Fire Tuckle Normal 5 Butterfree 45 50 Bug Grass Fire Gust Normal 6 Rock 0 100 Rock Fire Grass

Slide 85

Slide 85 text

TABLE EVOLUTION EVOLUTIONARY STAGE 2 ID NAME ATTACK DEFENSE TYPE STRONG VS WEAK VS MOVE MOVE TYPE NEXT FORM ID 1 Charmander 52 43 Fire Grass Water Ember Fire 4 1 Charmander 52 43 Fire Grass Water Inferno Fire 4 2 Squirtle 44 48 Water Fire Grass Bubble Water 7 2 Squirtle 44 48 Water Fire Grass Waterjet Water 7 3 Bulbasaur 49 49 Grass Water Fire Whip Normal 10 3 Bulbasaur 49 49 Grass Water Fire Leech Seed Grass 10 4 Charmeleon 62 58 Fire Grass Water Ember Fire 12 4 Charmeleon 62 58 Fire Grass Water Inferno Fire 12 5 Butterfree 45 50 Bug Grass Fire Bite Normal 5 Butterfree 45 50 Bug Grass Fire Tuckle Normal 5 Butterfree 45 50 Bug Grass Fire Gust Normal 6 Rock 0 100 Rock Fire Grass

Slide 86

Slide 86 text

TABLE EVOLUTION EVOLUTIONARY STAGE 2 MOVE MOVE TYPE Ember Fire Inferno Fire Bubble Water Waterjet Water Whip Normal Leech Seed Grass Ember Fire Inferno Fire Bite Normal Tuckle Normal Gust Normal

Slide 87

Slide 87 text

TABLE EVOLUTION EVOLUTIONARY STAGE 2 MOVE MOVE TYPE Ember Fire Inferno Fire Bubble Water Waterjet Water Whip Normal Leech Seed Grass Ember Fire Inferno Fire Bite Normal Tuckle Normal Gust Normal

Slide 88

Slide 88 text

TABLE EVOLUTION EVOLUTIONARY STAGE 2 MOVE MOVE TYPE Ember Fire Inferno Fire Bubble Water Waterjet Water Whip Normal Leech Seed Grass Bite Normal Tuckle Normal Gust Normal

Slide 89

Slide 89 text

TABLE EVOLUTION EVOLUTIONARY STAGE 2 MOVES ID NAME TYPE 1 Ember Fire 2 Inferno Fire 3 Bubble Water 4 Waterjet Water 5 Whip Normal 6 Leech Seed Grass 7 Bite Normal 8 Tuckle Normal 9 Gust Normal

Slide 90

Slide 90 text

TABLE EVOLUTION EVOLUTIONARY STAGE 2 ID NAME ATTACK DEFENSE TYPE STRONG VS WEAK VS MOVE MOVE TYPE NEXT FORM ID 1 Charmander 52 43 Fire Grass Water Ember Fire 4 1 Charmander 52 43 Fire Grass Water Inferno Fire 4 2 Squirtle 44 48 Water Fire Grass Bubble Water 7 2 Squirtle 44 48 Water Fire Grass Waterjet Water 7 3 Bulbasaur 49 49 Grass Water Fire Whip Normal 10 3 Bulbasaur 49 49 Grass Water Fire Leech Seed Grass 10 4 Charmeleon 62 58 Fire Grass Water Ember Fire 12 4 Charmeleon 62 58 Fire Grass Water Inferno Fire 12 5 Butterfree 45 50 Bug Grass Fire Bite Normal 5 Butterfree 45 50 Bug Grass Fire Tuckle Normal 5 Butterfree 45 50 Bug Grass Fire Gust Normal 6 Rock 0 100 Rock Fire Grass

Slide 91

Slide 91 text

TABLE EVOLUTION EVOLUTIONARY STAGE 2 ID NAME ATTACK DEFENSE TYPE STRONG VS WEAK VS MOVE MOVE TYPE NEXT FORM ID 1 Charmander 52 43 Fire Grass Water Ember Fire 4 1 Charmander 52 43 Fire Grass Water Inferno Fire 4 2 Squirtle 44 48 Water Fire Grass Bubble Water 7 2 Squirtle 44 48 Water Fire Grass Waterjet Water 7 3 Bulbasaur 49 49 Grass Water Fire Whip Normal 10 3 Bulbasaur 49 49 Grass Water Fire Leech Seed Grass 10 4 Charmeleon 62 58 Fire Grass Water Ember Fire 12 4 Charmeleon 62 58 Fire Grass Water Inferno Fire 12 5 Butterfree 45 50 Bug Grass Fire Bite Normal 5 Butterfree 45 50 Bug Grass Fire Tuckle Normal 5 Butterfree 45 50 Bug Grass Fire Gust Normal 6 Rock 0 100 Rock Fire Grass

Slide 92

Slide 92 text

TABLE EVOLUTION EVOLUTIONARY STAGE 2 ID NAME ATTACK DEFENSE TYPE STRONG VS WEAK VS MOVE MOVE TYPE NEXT FORM ID 1 Charmander 52 43 Fire Grass Water Ember Fire 4 1 Charmander 52 43 Fire Grass Water Inferno Fire 4 2 Squirtle 44 48 Water Fire Grass Bubble Water 7 2 Squirtle 44 48 Water Fire Grass Waterjet Water 7 3 Bulbasaur 49 49 Grass Water Fire Whip Normal 10 3 Bulbasaur 49 49 Grass Water Fire Leech Seed Grass 10 4 Charmeleon 62 58 Fire Grass Water Ember Fire 12 4 Charmeleon 62 58 Fire Grass Water Inferno Fire 12 5 Butterfree 45 50 Bug Grass Fire Bite Normal 5 Butterfree 45 50 Bug Grass Fire Tuckle Normal 5 Butterfree 45 50 Bug Grass Fire Gust Normal 6 Rock 0 100 Rock Fire Grass

Slide 93

Slide 93 text

TABLE EVOLUTION EVOLUTIONARY STAGE 2 POKEMONS ID NAME ATTACK DEFENSE TYPE STRONG VS WEAK VS NEXT FORM ID 1 Charmander 52 43 Fire Grass Water 4 2 Squirtle 44 48 Water Fire Grass 7 3 Bulbasaur 49 49 Grass Water Fire 10 4 Charmeleon 62 58 Fire Grass Water 12 5 Butterfree 45 50 Bug Grass Fire 6 Rock 0 100 Rock Fire Grass

Slide 94

Slide 94 text

TABLE EVOLUTION EVOLUTIONARY STAGE 2 ID NAME ATTACK DEFENSE TYPE STRONG VS WEAK VS MOVE MOVE TYPE NEXT FORM ID 1 Charmander 52 43 Fire Grass Water Ember Fire 4 1 Charmander 52 43 Fire Grass Water Inferno Fire 4 2 Squirtle 44 48 Water Fire Grass Bubble Water 7 2 Squirtle 44 48 Water Fire Grass Waterjet Water 7 3 Bulbasaur 49 49 Grass Water Fire Whip Normal 10 3 Bulbasaur 49 49 Grass Water Fire Leech Seed Grass 10 4 Charmeleon 62 58 Fire Grass Water Ember Fire 12 4 Charmeleon 62 58 Fire Grass Water Inferno Fire 12 5 Butterfree 45 50 Bug Grass Fire Bite Normal 5 Butterfree 45 50 Bug Grass Fire Tuckle Normal 5 Butterfree 45 50 Bug Grass Fire Gust Normal 6 Rock 0 100 Rock Fire Grass

Slide 95

Slide 95 text

TABLE EVOLUTION EVOLUTIONARY STAGE 2 ID MOVE 1 Ember 1 Inferno 2 Bubble 2 Waterjet 3 Whip 3 Leech Seed 4 Ember 4 Inferno 5 Bite 5 Tuckle 5 Gust 6

Slide 96

Slide 96 text

TABLE EVOLUTION EVOLUTIONARY STAGE 2 ID MOVE 1 Ember 1 Inferno 2 Bubble 2 Waterjet 3 Whip 3 Leech Seed 4 Ember 4 Inferno 5 Bite 5 Tuckle 5 Gust 6

Slide 97

Slide 97 text

TABLE EVOLUTION EVOLUTIONARY STAGE 2 POKEMON ID MOVE ID 1 1 1 2 2 3 2 4 3 5 3 6 4 1 4 2 5 7 5 8 5 9 6

Slide 98

Slide 98 text

TABLE EVOLUTION EVOLUTIONARY STAGE 2 POKEMON MOVES POKEMON ID MOVE ID 1 1 1 2 2 3 2 4 3 5 3 6 4 1 4 2 5 7 5 8 5 9 6

Slide 99

Slide 99 text

No content

Slide 100

Slide 100 text

POKEMON MOVES POKEMON ID MOVE ID 1 1 1 2 2 3 2 4 3 5 3 6 4 1 4 2 5 7 5 8 5 9 6 POKEMONS ID NAME ATTACK DEFENSE TYPE STRONG VS WEAK VS NEXT FORM ID 1 Charmander 52 43 Fire Grass Water 4 2 Squirtle 44 48 Water Fire Grass 7 3 Bulbasaur 49 49 Grass Water Fire 10 4 Charmeleon 62 58 Fire Grass Water 12 5 Butterfree 45 50 Bug Grass Fire 6 Rock 0 100 Rock Fire Grass MOVES ID NAME TYPE 1 Ember Fire 2 Inferno Fire 3 Bubble Water 4 Waterjet Water 5 Whip Normal 6 Leech Seed Grass 7 Bite Normal 8 Tuckle Normal 9 Gust Normal

Slide 101

Slide 101 text

PROBLEMS 5. CAN’T STORE DATA ABOUT THE TYPES ONLY 1. NON-ATOMIC VALUES CAN LEAD TO INCONSISTENCIES 2. SOME VALUES HAVE TO BE EDITED IN MULTIPLE PLACES 4. ROWS DELETION CAN LEAD TO UNWANTED DATA LOSS 3. A LOT OF EMPTY CELLS 6. A LOT OF DUPLICATE DATA

Slide 102

Slide 102 text

PROBLEMS 5. CAN’T STORE DATA ABOUT THE TYPES ONLY 1. NON-ATOMIC VALUES CAN LEAD TO INCONSISTENCIES 2. SOME VALUES HAVE TO BE EDITED IN MULTIPLE PLACES 4. ROWS DELETION CAN LEAD TO UNWANTED DATA LOSS 3. A LOT OF EMPTY CELLS 6. A LOT OF DUPLICATE DATA

Slide 103

Slide 103 text

PROBLEMS 5. CAN’T STORE DATA ABOUT THE TYPES ONLY 1. NON-ATOMIC VALUES CAN LEAD TO INCONSISTENCIES 2. SOME VALUES HAVE TO BE EDITED IN MULTIPLE PLACES 4. ROWS DELETION CAN LEAD TO UNWANTED DATA LOSS 3. A LOT OF EMPTY CELLS 6. A LOT OF DUPLICATE DATA

Slide 104

Slide 104 text

No content

Slide 105

Slide 105 text

WHAT? TABLE IS EVOLVING!!!

Slide 106

Slide 106 text

POKEMONS ID NAME ATTACK DEFENSE TYPE STRONG VS WEAK VS NEXT FORM ID 1 Charmander 52 43 Fire Grass Water 4 2 Squirtle 44 48 Water Fire Grass 7 3 Bulbasaur 49 49 Grass Water Fire 10 4 Charmeleon 62 58 Fire Grass Water 12 5 Butterfree 45 50 Bug Grass Fire 6 Rock 0 100 Rock Fire Grass TABLE EVOLUTION EVOLUTIONARY STAGE 3

Slide 107

Slide 107 text

POKEMONS ID NAME ATTACK DEFENSE TYPE STRONG VS WEAK VS NEXT FORM ID 1 Charmander 52 43 Fire Grass Water 4 2 Squirtle 44 48 Water Fire Grass 7 3 Bulbasaur 49 49 Grass Water Fire 10 4 Charmeleon 62 58 Fire Grass Water 12 5 Butterfree 45 50 Bug Grass Fire 6 Rock 0 100 Rock Fire Grass TABLE EVOLUTION EVOLUTIONARY STAGE 3

Slide 108

Slide 108 text

POKEMONS ID NAME ATTACK DEFENSE TYPE STRONG VS WEAK VS NEXT FORM ID 1 Charmander 52 43 Fire Grass Water 4 2 Squirtle 44 48 Water Fire Grass 7 3 Bulbasaur 49 49 Grass Water Fire 10 4 Charmeleon 62 58 Fire Grass Water 12 5 Butterfree 45 50 Bug Grass Fire 6 Rock 0 100 Rock Fire Grass TABLE EVOLUTION EVOLUTIONARY STAGE 3

Slide 109

Slide 109 text

POKEMONS TYPE STRONG VS WEAK VS Fire Grass Water Water Fire Grass Grass Water Fire Fire Grass Water Bug Grass Fire Rock Fire Grass TABLE EVOLUTION EVOLUTIONARY STAGE 3

Slide 110

Slide 110 text

TYPE STRONG VS WEAK VS Fire Grass Water Water Fire Grass Grass Water Fire Bug Grass Fire Rock Fire Grass TABLE EVOLUTION EVOLUTIONARY STAGE 3

Slide 111

Slide 111 text

TABLE EVOLUTION EVOLUTIONARY STAGE 3 TYPES ID NAME STRONG VS WEAK VS 1 Fire 3 2 2 Water 1 2 3 Grass 2 1 4 Bug 3 1 5 Rock 1 3

Slide 112

Slide 112 text

POKEMONS ID NAME ATTACK DEFENSE TYPE STRONG VS WEAK VS NEXT FORM ID 1 Charmander 52 43 Fire Grass Water 4 2 Squirtle 44 48 Water Fire Grass 7 3 Bulbasaur 49 49 Grass Water Fire 10 4 Charmeleon 62 58 Fire Grass Water 12 5 Butterfree 45 50 Bug Grass Fire 6 Rock 0 100 Rock Fire Grass TABLE EVOLUTION EVOLUTIONARY STAGE 3

Slide 113

Slide 113 text

POKEMONS ID NAME ATTACK DEFENSE TYPE STRONG VS WEAK VS NEXT FORM ID 1 Charmander 52 43 Fire Grass Water 4 2 Squirtle 44 48 Water Fire Grass 7 3 Bulbasaur 49 49 Grass Water Fire 10 4 Charmeleon 62 58 Fire Grass Water 12 5 Butterfree 45 50 Bug Grass Fire 6 Rock 0 100 Rock Fire Grass TABLE EVOLUTION EVOLUTIONARY STAGE 3

Slide 114

Slide 114 text

POKEMONS ID NAME ATTACK DEFENSE TYPE ID STRONG VS WEAK VS NEXT FORM ID 1 Charmander 52 43 1 Grass Water 4 2 Squirtle 44 48 2 Fire Grass 7 3 Bulbasaur 49 49 3 Water Fire 10 4 Charmeleon 62 58 1 Grass Water 12 5 Butterfree 45 50 4 Grass Fire 6 Rock 0 100 5 Fire Grass TABLE EVOLUTION EVOLUTIONARY STAGE 3

Slide 115

Slide 115 text

POKEMONS ID NAME ATTACK DEFENSE TYPE ID NEXT FORM ID 1 Charmander 52 43 1 4 2 Squirtle 44 48 2 7 3 Bulbasaur 49 49 3 10 4 Charmeleon 62 58 1 12 5 Butterfree 45 50 4 6 Rock 0 100 5 TABLE EVOLUTION EVOLUTIONARY STAGE 3

Slide 116

Slide 116 text

No content

Slide 117

Slide 117 text

POKEMON MOVES POKEMON ID MOVE ID 1 1 1 2 2 3 2 4 3 5 3 6 4 1 4 2 5 7 5 8 5 9 6 MOVES ID NAME TYPE ID 1 Ember 1 2 Inferno 1 3 Bubble 2 4 Waterjet 2 5 Whip 6 6 Leech Seed 3 7 Bite 6 8 Tuckle 6 9 Gust 6 POKEMONS ID NAME ATTACK DEFENSE TYPE ID NEXT FORM ID 1 Charmander 52 43 1 4 2 Squirtle 44 48 2 7 3 Bulbasaur 49 49 3 10 4 Charmeleon 62 58 1 12 5 Butterfree 45 50 4 6 Rock 0 100 5 TYPES ID NAME STRONG VS WEAK VS 1 Fire 3 2 2 Water 1 2 3 Grass 2 1 4 Bug 3 1 5 Rock 1 3

Slide 118

Slide 118 text

PROBLEMS 5. CAN’T STORE DATA ABOUT THE TYPES ONLY 1. NON-ATOMIC VALUES CAN LEAD TO INCONSISTENCIES 2. SOME VALUES HAVE TO BE EDITED IN MULTIPLE PLACES 4. ROWS DELETION CAN LEAD TO UNWANTED DATA LOSS 3. A LOT OF EMPTY CELLS 6. A LOT OF DUPLICATE DATA

Slide 119

Slide 119 text

PROBLEMS 5. CAN’T STORE DATA ABOUT THE TYPES ONLY 1. NON-ATOMIC VALUES CAN LEAD TO INCONSISTENCIES 2. SOME VALUES HAVE TO BE EDITED IN MULTIPLE PLACES 4. ROWS DELETION CAN LEAD TO UNWANTED DATA LOSS 3. A LOT OF EMPTY CELLS 6. A LOT OF DUPLICATE DATA

Slide 120

Slide 120 text

PROBLEMS 5. CAN’T STORE DATA ABOUT THE TYPES ONLY 1. NON-ATOMIC VALUES CAN LEAD TO INCONSISTENCIES 2. SOME VALUES HAVE TO BE EDITED IN MULTIPLE PLACES 4. ROWS DELETION CAN LEAD TO UNWANTED DATA LOSS 3. A LOT OF EMPTY CELLS 6. A LOT OF DUPLICATE DATA

Slide 121

Slide 121 text

PROBLEMS 5. CAN’T STORE DATA ABOUT THE TYPES ONLY 1. NON-ATOMIC VALUES CAN LEAD TO INCONSISTENCIES 2. SOME VALUES HAVE TO BE EDITED IN MULTIPLE PLACES 4. ROWS DELETION CAN LEAD TO UNWANTED DATA LOSS 3. A LOT OF EMPTY CELLS 6. A LOT OF DUPLICATE DATA

Slide 122

Slide 122 text

POKEMON MOVES POKEMON ID MOVE ID 1 1 1 2 2 3 2 4 3 5 3 6 4 1 4 2 5 7 5 8 5 9 6 MOVES ID NAME TYPE ID 1 Ember 1 2 Inferno 1 3 Bubble 2 4 Waterjet 2 5 Whip 6 6 Leech Seed 3 7 Bite 6 8 Tuckle 6 9 Gust 6 POKEMONS ID NAME ATTACK DEFENSE TYPE ID NEXT FORM ID 1 Charmander 52 43 1 4 2 Squirtle 44 48 2 7 3 Bulbasaur 49 49 3 10 4 Charmeleon 62 58 1 12 5 Butterfree 45 50 4 6 Rock 0 100 5 TYPES ID NAME STRONG VS WEAK VS 1 Fire 3 2 2 Water 1 2 3 Grass 2 1 4 Bug 3 1 5 Rock 1 3

Slide 123

Slide 123 text

POKEMON MOVES POKEMON ID MOVE ID 1 1 1 2 2 3 2 4 3 5 3 6 4 1 4 2 5 7 5 8 5 9 6 MOVES ID NAME TYPE ID 1 Ember 1 2 Inferno 1 3 Bubble 2 4 Waterjet 2 5 Whip 6 6 Leech Seed 3 7 Bite 6 8 Tuckle 6 9 Gust 6 POKEMONS ID NAME ATTACK DEFENSE TYPE ID NEXT FORM ID 1 Charmander 52 43 1 4 2 Squirtle 44 48 2 7 3 Bulbasaur 49 49 3 10 4 Charmeleon 62 58 1 12 5 Butterfree 45 50 4 6 Rock 0 100 5 TYPES ID NAME STRONG VS WEAK VS 1 Fire 3 2 2 Water 1 2 3 Grass 2 1 4 Bug 3 1 5 Rock 1 3

Slide 124

Slide 124 text

POKEMON MOVES POKEMON ID MOVE ID 1 1 1 2 2 3 2 4 3 5 3 6 4 1 4 2 5 7 5 8 5 9 6 MOVES ID NAME TYPE ID 1 Ember 1 2 Inferno 1 3 Bubble 2 4 Waterjet 2 5 Whip 6 6 Leech Seed 3 7 Bite 6 8 Tuckle 6 9 Gust 6 POKEMONS ID NAME ATTACK DEFENSE TYPE ID NEXT FORM ID 1 Charmander 52 43 1 4 2 Squirtle 44 48 2 7 3 Bulbasaur 49 49 3 10 4 Charmeleon 62 58 1 12 5 Butterfree 45 50 4 6 Rock 0 100 5 TYPES ID NAME STRONG VS WEAK VS 1 Fire 3 2 2 Water 1 2 3 Grass 2 1 4 Bug 3 1 5 Rock 1 3

Slide 125

Slide 125 text

POKEMON MOVES POKEMON ID MOVE ID 1 1 1 2 2 3 2 4 3 5 3 6 4 1 4 2 5 7 5 8 5 9 6 MOVES ID NAME TYPE ID 1 Ember 1 2 Inferno 1 3 Bubble 2 4 Waterjet 2 5 Whip 6 6 Leech Seed 3 7 Bite 6 8 Tuckle 6 9 Gust 6 POKEMONS ID NAME ATTACK DEFENSE TYPE ID NEXT FORM ID 1 Charmander 52 43 1 4 2 Squirtle 44 48 2 7 3 Bulbasaur 49 49 3 10 4 Charmeleon 62 58 1 12 5 Butterfree 45 50 4 6 Rock 0 100 5 TYPES ID NAME STRONG VS WEAK VS 1 Fire 3 2 2 Water 1 2 3 Grass 2 1 4 Bug 3 1 5 Rock 1 3

Slide 126

Slide 126 text

POKEMON MOVES POKEMON ID MOVE ID 1 1 1 2 2 3 2 4 3 5 3 6 4 1 4 2 5 7 5 8 5 9 6 MOVES ID NAME TYPE ID 1 Ember 1 2 Inferno 1 3 Bubble 2 4 Waterjet 2 5 Whip 6 6 Leech Seed 3 7 Bite 6 8 Tuckle 6 9 Gust 6 POKEMONS ID NAME ATTACK DEFENSE TYPE ID NEXT FORM ID 1 Charmander 52 43 1 4 2 Squirtle 44 48 2 7 3 Bulbasaur 49 49 3 10 4 Charmeleon 62 58 1 12 5 Butterfree 45 50 4 6 Rock 0 100 5 TYPES ID NAME STRONG VS WEAK VS 1 Fire 3 2 2 Water 1 2 3 Grass 2 1 4 Bug 3 1 5 Rock 1 3

Slide 127

Slide 127 text

POKEMON MOVES POKEMON ID MOVE ID 1 1 1 2 2 3 2 4 3 5 3 6 4 1 4 2 5 7 5 8 5 9 6 MOVES ID NAME TYPE ID 1 Ember 1 2 Inferno 1 3 Bubble 2 4 Waterjet 2 5 Whip 6 6 Leech Seed 3 7 Bite 6 8 Tuckle 6 9 Gust 6 POKEMONS ID NAME ATTACK DEFENSE TYPE ID NEXT FORM ID 1 Charmander 52 43 1 4 2 Squirtle 44 48 2 7 3 Bulbasaur 49 49 3 10 4 Charmeleon 62 58 1 12 5 Butterfree 45 50 4 6 Rock 0 100 5 TYPES ID NAME STRONG VS WEAK VS 1 Fire 3 2 2 Water 1 2 3 Grass 2 1 4 Bug 3 1 5 Rock 1 3

Slide 128

Slide 128 text

POKEMON MOVES POKEMON ID MOVE ID 1 1 1 2 2 3 2 4 3 5 3 6 4 1 4 2 5 7 5 8 5 9 6 MOVES ID NAME TYPE ID 1 Ember 1 2 Inferno 1 3 Bubble 2 4 Waterjet 2 5 Whip 6 6 Leech Seed 3 7 Bite 6 8 Tuckle 6 9 Gust 6 POKEMONS ID NAME ATTACK DEFENSE TYPE ID NEXT FORM ID 1 Charmander 52 43 1 4 2 Squirtle 44 48 2 7 3 Bulbasaur 49 49 3 10 4 Charmeleon 62 58 1 12 5 Butterfree 45 50 4 6 Rock 0 100 5 TYPES ID NAME STRONG VS WEAK VS 1 Fire 3 2 2 Water 1 2 3 Grass 2 1 4 Bug 3 1 5 Rock 1 3

Slide 129

Slide 129 text

POKEMON MOVES POKEMON ID MOVE ID 1 1 1 2 2 3 2 4 3 5 3 6 4 1 4 2 5 7 5 8 5 9 6 MOVES ID NAME TYPE ID 1 Ember 1 2 Inferno 1 3 Bubble 2 4 Waterjet 2 5 Whip 6 6 Leech Seed 3 7 Bite 6 8 Tuckle 6 9 Gust 6 POKEMONS ID NAME ATTACK DEFENSE TYPE ID NEXT FORM ID 1 Charmander 52 43 1 4 2 Squirtle 44 48 2 7 3 Bulbasaur 49 49 3 10 4 Charmeleon 62 58 1 12 5 Butterfree 45 50 4 6 Rock 0 100 5 TYPES ID NAME STRONG VS WEAK VS 1 Fire 3 2 2 Water 1 2 3 Grass 2 1 4 Bug 3 1 5 Rock 1 3

Slide 130

Slide 130 text

PROBLEMS

Slide 131

Slide 131 text

PROBLEMS 1. READING IS COMPLEX

Slide 132

Slide 132 text

SUMMARY

Slide 133

Slide 133 text

SUMMARY PROBLEMS -> ANOMALIES

Slide 134

Slide 134 text

SUMMARY EVOLUTION TIERS -> NORMAL FORMS PROBLEMS -> ANOMALIES

Slide 135

Slide 135 text

SUMMARY EVOLUTION TIERS -> NORMAL FORMS PROBLEMS -> ANOMALIES HIGHER FORM -> LOWER REDUNDANCY

Slide 136

Slide 136 text

SUMMARY EVOLUTION TIERS -> NORMAL FORMS PROBLEMS -> ANOMALIES HIGHER FORM -> LOWER REDUNDANCY HIGHER FORM -> HIGHER DATA INTEGRITY

Slide 137

Slide 137 text

SUMMARY EVOLUTION TIERS -> NORMAL FORMS PROBLEMS -> ANOMALIES HIGHER FORM -> LOWER REDUNDANCY HIGHER FORM -> LONGER READ HIGHER FORM -> HIGHER DATA INTEGRITY

Slide 138

Slide 138 text

No content

Slide 139

Slide 139 text

QUESTIONS?