Loot
|
Name |
Grade |
Dropped |
Category |
|
Iron Sword |
Iron |
Goblin |
Weapon |
|
Steel Claymore |
Steel |
Ogre |
Weapon |
|
Wood Staff |
Wood |
Skeleton |
Weapon |
|
Iron Shield |
Iron |
Zombie |
Shield |
|
Wood Helmet |
Silver |
Knight |
Armor |
|
Gold Chestplate |
Gold |
Ogre |
Armor |
|
Steel Buckler |
Steel |
Knight |
Shield |
Type
|
Grade |
Defense |
Damage |
Durability |
|
Iron |
20 |
10 |
50 |
|
Steel |
25 |
20 |
80 |
|
Wood |
10 |
5 |
40 |
|
Gold |
40 |
35 |
60 |
Mob
|
Mob |
Life |
Loot1 |
Loot2 |
Loot3 |
|
Goblin |
50 |
Iron Sword |
Potion |
Gold |
|
Ogre |
70 |
Steel Claymore |
Gold Chestplate |
Food |
|
Skeleton |
40 |
Wood Staff |
Bones |
Skull |
|
Knight |
90 |
Silver Helmet |
Steel Buckler |
Gold |
|
Zombie |
50 |
Iron Shield |
Food |
Potion |
1st Normal Form – No repeated Columns, Each cell is Single Valued, Consistent type for each column
2nd Normal Form – Each key is relevant to the data it is supporting, split data into 3 separate tables to make each key relevant
3rd Normal Form – Each attribute only depends on the primary key and not any other attribute in the table