Help In Database Please!!!

Functional dependencies, Normalization, and SQL 1. Consider the following database, MANA. It is printed here and is also available on csmaster.sxu.edu/phpminiadmin/. It has three relations-MONSTER, REGION, and LOCATION. A summary of the requirement s is as follows: .The database keeps track of information about a video game called Secret of Mana. A large part of the game involves traveling to different regions and fighting various monsters. .Every monster has values that effect fighting, including hit points, magic power, a weakness, and a special attack. The database also stores what the player gets when beating the monster, including experience, gold, treasures, and rare treasures .Every region has a terrain type and how the player can travel there. Each terrain has its own symbol on the map The database also records which monsters can be found in which regions . MONSTER MonsterName HitPointsMagicExp Gold Weak Specia TreasureRareTreasure 20 633 540 NULL NULL Armored Man Candy Cup of Wishes 10 NULL Flier Candy Medical Herb Chocolate Royal Jam Imp Ring Candy Crawler 20 124 47 NULL Sleep 0 863 528 Undine NULL 2830 NULL Moogl 99 3540 2140 Lumina NULL 99 3090 2560 Gnome NULL 16 240 180 NULL NULL 100 Medical Herb Eggatrice 185 Spy le Chocolate Medical Herb Ghost Griffin Hand Howler Lullabuc Mushgloom Griffin Helm 190 36 628 Medical Herb 35 29 NULL Poison Medical Herb 16 GP 38 2550 3220 NULL NULL REGION LOCATION Region NameTerrainType Symbo Elinees Castle Emperors Castle Gaias Navel Haunted Forest Ice Country Kippo village Travel Foot Flammie Foot Foot Mname Armored Man Emperors Castle Armored Man Mana Fortress Dungeon Cave Forest Snow field Town Gaias Navel Underground Palace Upper Land Lofty Mountains Haunted Forest Elinees Castle Pureland Pureland Ice Pandora Gaias Navel Crawler Eggatrice crystaCannon Foot Flammie Flammie Cannon lu Matan Pandora Pureland Underground PalaceDun Upper Land Dungeon Town Dungeon Forest Eye Spy Ghost Griffin Hand Howler Lullabud Lullabud Mushgloom Pureland Flammie Foot Cannon tree lump CMPSC 321: Relational Database Theory and Design (4) Write an SQL query that lists the names of all monsters whose treasure is Candy a. 1) Write the result of the query