cameroon gce advanced level June 2024 computer science 3
cameroon gce advanced level June 2024 computer science 3
SECTION A (Database): Football association database
Task 1 (20 marks)
The database of a certain football association is structured as shown by the tables below. 1 he primary key of
each relation is marked with an asterisk ( * ).
Playe/ j PlayerlD , ClubID, Name, Position, MatchPlayed, Goals)
Field Datatype Size
PlayerlD ( primary key) Text 6 (Example: 21 A00 I )
ClubID Text 10 ( Example BARCA001)
Name Text 30
Position Number Short integer
MatchPlayed Number Long integer
Goals Number Long integer
Cluh( ClubID , CoachID, Country, NoTitles, YearCreation)
Field Datatype Size
ClublD(primary key) Text 10 (Example BARCA00 I )
CoachID Text 10 ( Example CHEL001)
Country Text 30
NoTitles Number Short integer
YearCreation Date Day/Month/Year
CwField /c^CoachlD *, ClubID, Name, Titles Datatype , Nationality, Age) Size
CoachlD(primary key) Text 10 (Example CHEL00 I )
ClubID Text 10 ( Example BARCA001 )
Name Text 30
Titles Number Short integer
Nationality Text 20
Age Number Short Integer
In a relational Database Management System ( RDBMS) of your choice help the football association to
implement its database through the following actions:
I . Create the above tables using your RDBMS. Write the corresponding SQL code used for each table in the
spaces provided below. (6 marks)
