Question: Create 2 tables: PLAYER ( id int ( PK ) , fname varchar ( 3 0 ) , Iname varchar ( 3 0 ) ,

Create 2 tables:
PLAYER (id int(PK), fname varchar (30), Iname varchar(30),age int ,position varchar(30) clubid int(FK), clubid is a FK to the PK of the table CLUB. (id, first name, last name,age, position in the id of the club it refers)
CLUB( clubid(PK int ), name, titles, founded) id of the club, name of the club, number of titles, and year of foundation.
Insert 10 records in PLAYER and 3 in CLUB . You choose.
After those tables are created, provide the following in a doc file:
Display all the names(fname, Iname) of the players
Display the club names sorted by the year of foundation with the number of tiles>5
Create 2 tables: PLAYER ( id int ( PK ) , fname

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 Programming Questions!