We have provided you with the creation script for the Treasure Hunters database. You should run this script in MySQL Workbench and use this database to extract the necessary information. The script is based on the following schematic: TREASURE HUNTERS RELATIONAL MODEL Player (username, firstName, lastName, gender, DOB, email, streetNo, streetName, suburb, state, postcode, creationDateTime, totalPoints) PhoneNumber (phoneNumber, username) Treasure (treasureID, description, points, webpage, type, questID) Quest (questID, questName, story, beacon, advancedQuestID) Store (storeID, storeName, openTime, closeTime) Badge (badgeID, badgeName, badgeDescription) PlayerProgress (questID, username, progress) PlayerTreasure (username, treasureID) Purchase (purchaseID, storeID, username, badgeID, purchaseDateTime, cost) FOREIGN KEYS PhoneNumber (username) is dependent on Player(username) Quest (advancedQuestID) is dependent on Quest(questID) Treasure (questID) is dependent on Quest (questID) PlayerProgress (questID) is dependent on Quest (questID) PlayerProgress (username) is dependent on Player (username) PlayerTreasure (username) is dependent on Player (username) PlayerTreasure (treasureID) is dependent on Treasure (treasureID) Purchase (storeID) is dependent on Store (storeID) Purchase (username) is dependent on Player (username) Purchase (badgeID) is dependent on Badge (badgeID) OTHER CONSTRAINTS Player (gender) must be female, male, other or prefer not to disclose. Player (state) domain is [QLD, SA, TAS, NSW, WA, NT or ACT]. Treasure (type) domain is [common, uncommon, rare, ultra-rare or elite]. Players may enter up to three phone numbers. Players must enter at least one phone number. PlayerProgress (progress) domain is [active, inactive or complete]. Player (email) is mandatory

Task 5 [2 marks] Treasure Hunters Company have two employees, Nikki and Phil, to work with the MySQL database. Working as MySQL database administrator, provide the commands required to grant or revoke access so the following security requirements are met: A. User Nikki must be able to add records to the PLAYER table (0.5 Marks) B. User Nikki must be able to remove records from the PLAYER table (0.5 Marks) C. User Phil is no longer allowed to add data to the PLAYER table (0.5 Marks) D. User Phil is no longer allowed to delete records from the PLAYER table (0.5 Marks) Assume usernames of employees Nikki and Phil are nikki and phil respectively.