SophiaPretty

(5)

$14/per page/Negotiable

About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all
Teaching Since: Jul 2017
Last Sign in: 305 Weeks Ago, 1 Day Ago
Questions Answered: 15833
Tutorials Posted: 15827

Education

  • MBA,PHD, Juris Doctor
    Strayer,Devery,Harvard University
    Mar-1995 - Mar-2002

Experience

  • Manager Planning
    WalMart
    Mar-2001 - Feb-2009

Category > Computer Science Posted 09 Nov 2017 My Price 10.00

statements to create the following tables for the game database

I do not know what i have to do or what program to use.

 

Assignment 6

 

 

1.      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

2.      You must actually create the selected tables in your Oracle Account. Write all your SQL CREATE TABLE statements in a file named assignment5.sql

 

3.      By due date, submit the assignment6.sql through moodle. The TA will simply run your script in his account. If there is error, you lose points. If it compiles and runs, you win J  

 

Attachments:

Answers

SophiaPretty
(5)
Status NEW Posted 09 Nov 2017 12:11 PM My Price 10.00

----------- He-----------llo----------- Si-----------r/M-----------ada-----------m -----------Tha-----------nk -----------you----------- fo-----------r y-----------our----------- in-----------ter-----------est----------- an-----------d b-----------uyi-----------ng -----------my -----------pos-----------ted----------- so-----------lut-----------ion-----------. P-----------lea-----------se -----------pin-----------g m-----------e o-----------n c-----------hat----------- I -----------am -----------onl-----------ine----------- or----------- in-----------box----------- me----------- a -----------mes-----------sag-----------e I----------- wi-----------ll -----------be -----------qui-----------ckl-----------y

Not Rated(0)