Write SQL CREATE TABLE statements to create the following tables for the game database

GAMER (USERNAME, PASSWORD, FIRSTNAME, LASTNAME, EMAIL) CHARACTER (CHARACTER_NAME, LEVEL, EXP, HP, MP, STRENGTH, INTLLIGENCE, DEXTERITY, CLASS, USERNAME) FOREIGN KEY USERNAME REFERENCES GAMER PVP_MATCH (MATCHID, WINNER_NAME, LOSER_NAME, KILL_TIME, KILL_SCORE) FOREIGN KEY WINNER_NAME REFERENCES CHARACTER FOREIGN KEY LOSER_NAME REFERENCES CHARACTER GUILD (GUILD_NAME, FOUNDING_TIME, STATUS) CHARACTER_GUILD (GUILD_NAME, CHARACTER_NAME) FOREIGN KEY CHARACTER_NAME REFERENCES CHARACTER FOREIGN KEY GUILD_NAME REFERENCES GUILD ITEM (ITEM_NAME, VALUE, STATUS, TYPE) ARMOR (ITEM_NAME, DEFENSE, TYPE) FOREIGN KEY ITEM_NAME REFERENCES ITEM ACCESSORY (ITEM_NAME, SPECIAL EFFECTS, TYPE) FOREIGN KEY ITEM_NAME REFERENCES ITEM WEAPON (ITEM_NAME, SPEED, DPS) FOREIGN KEY ITEM_NAME REFERENCES ITEM CHARACTER_ITEM (CHARACTER_NAME, ITEM_NAME) FOREIGN KEY ITEM_NAME REFERENCES ITEM FOREIGN KEY CHARACTER_NAME REFERENCES CHARACTER SKILL (SKILL_ID, NAME, MPCOST, LEVEL, DESCRIPTION) CHARACTER_SKILL (CHARACTER_NAME, SKILL_ID) FOREIGN KEY SKILL_ID REFERENCES SKILL FOREIGN KEY CHARACTER_NAME REFERENCES CHARACTER PREREQUISITE_SKILL (SKILL_ID, PREREQUISITE_SKILL_ID) FOREIGN KEY SKILL_ID REFERENCES SKILL FOREIGN KEY PREREQUISITE_SKILL_ID REFERENCES SKILL

You must actually create the selected tables in your SQL Server Manager or MS Access. Write all your SQL CREATE TABLE statements in a file named assignment6.sql