Question: Create 2 tables: PLAYER ( id int ( PK ) , fname varchar ( 3 0 ) , Iname varchar ( 3 0 ) ,
Create tables:
PLAYER id intPK fname varchar Iname varcharage int position varchar clubid intFK 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 clubidPK int name, titles, founded id of the club, name of the club, number of titles, and year of foundation.
Insert records in PLAYER and in CLUB You choose.
After those tables are created, provide the following in a doc file:
Display all the namesfname Iname of the players
Display the club names sorted by the year of foundation with the number of tiles
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
