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

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

Question:

 

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)

Expert Answer:

Answer rating: 100% (QA)

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