Suppose we have the following table defined in our database: CREATE TABLE SOCCER

Question

Suppose we have the following table defined in our database: CREATE TABLE SOCCER TEAM TEAM NO TEAM NAME TEAM CITY YEAR-OF-ORIGIN int(8) PRIMARY varchar(32), varchar (64), int(4) KEY Given this table, suppose we wanted to create a second table called SOCCER PLAYER with three fields: SOCCER PLAYER NO, an integer field which is the primary key: SOCCER PLAYER NAME, a variable-length character field (max 40); and SOCCER TEAM_NO, a foreign key to the primary key of SOCCER TEAM. Construct the SQL statement required to create this table

Explanation / Answer

create table SOCCER_PLAYER

(

PLAYER_NO int(10) primary key,

PLAYER_NAME varchar(40),

TEAM_NO int(8),

Constraint FK_Key foreign key(TEAM_NO) references SOCCER_TEAM

);

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.