Question: SQL help. I An responsible for programming the PLAYERS table only. The data will be taken from a website. I am confused what does this
SQL help. I An responsible for programming the PLAYERS table only. The data will be taken from a website. I am confused what does this means and What am I supposed to program in SQL. How do I apply primary key and the foreign keys and use joins subqueries or joins to get data as required.
Comps Players ID INT Name VARCHAR(45) Username VARCHAR(225) Age INT Role VARCHAR(255) teamName_ID INT topHero ID INT isPro VARCHAR(225) ID INT ID INT Name VARCHAR (225) Role VARCHAR(225) primaryFireDmg INT winRate INT Hero1 ID INT Hero2-ID INT Hero3 ID INT Hero4-ID INT Hero5_ID INT Hero6_ID INT Maps ID INT Name VARCHAR (225) Type VARCHAR(225) winRateAtt INT winRateDef INT numBigHealth INT numSmallHealth INT Matches ID INT Date DATE winTeam_ID VARCHAR(225) winComp ID INT lossTeam_ID VARCHAR(225) lossComp-ID INT Venue VARCHAR(225) Indexes bestTypeMap_ID INT Maps ID INT Heroes_ID INT Indexes Indexes overbuffLink VARCHAR(225) Heroes ID INT Teams ID INT Indexes Teams ID INT Name VARCHAR(225) Country VARCHAR(225) Rank INT numWins INT Teams ID INT Comps ID INT Indexes Indexes
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
