Table: Football Name Touchdowns John Thomas 55 Dave Roberts 43 Charles Lowe 22 Brian Jones 30...

 

Transcribed Image Text:

Table: Football Name Touchdowns John Thomas 55 Dave Roberts 43 Charles Lowe 22 Brian Jones 30 Table Basketball Name Daniel Wayne Ron Stanley Peter Giles 11 Brandon Miles 6 12 32 Field Goals 35 40 25 31 Points Scored Interceptions/ Years Played Fumbles 12 5 14 18 3 15 7 10 8 4 7 5 Years Played Division Eastern Eastern Western Southern Division Northern Western Southern Western 4. How might I add a primary key constraint for the above 2 tables? (show actual code below) Table: Football Name Touchdowns John Thomas 55 Dave Roberts 43 Charles Lowe 22 Brian Jones 30 Table Basketball Name Daniel Wayne Ron Stanley Peter Giles 11 Brandon Miles 6 12 32 Field Goals 35 40 25 31 Points Scored Interceptions/ Years Played Fumbles 12 5 14 18 3 15 7 10 8 4 7 5 Years Played Division Eastern Eastern Western Southern Division Northern Western Southern Western 4. How might I add a primary key constraint for the above 2 tables? (show actual code below)

Answer rating: 100% (QA)

We can add a primary key constraint using SQL syntax ... View the full answer