RELATIONAL DATABASE SYSTEMS · ADVANCED MODULE

ENGINEER SQL
PRECISION

SYSTEM ARCHITECT: NYOH LEONARD KANYI

Reference Database Structure

TABLE: Club (Information regarding football organizations)

club_id (PK)club_namecountryfounded
1Real MadridSpain1902
2LiverpoolEngland1892
3Bayern MunichGermany1900

TABLE: Player (Registry of registered athletes)

player_id (PK)namepositionageclub_id (FK)
101Vinicius JrForward231
102SalahForward312
103MusialaMidfielder213

Interactive SQL Laboratory