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. SQL help. I An responsible for programming the PLAYERS table only. The

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!