4.1 What is the term given to the GameID field in the tblGamesPlayed table? 4.1.2 How many games will each player be able to play per day based on the construction of the database? Choose the answer from the options (A–C) provided below - NSC Information Technology - Question 4 - 2017 - Paper 2

The correct answer is C: Any number of games per day. The design of the database allows players to participate in multiple games within a single day.

The message indicates that PlayerID F566 cannot be deleted because it is related to entries in the tblGamesPlayed table. Since the PlayerID serves as a primary key in tblPlayers, it cannot be removed while records still reference it in tblGamesPlayed.

To delete PlayerID F566 from the tblPlayers table successfully, all related records containing PlayerID F566 in the tblGamesPlayed table must first be deleted. Once those records are removed, the player can be safely deleted from tblPlayers.

The SQL statement to display all details of the games played between 12:00 and 15:00 would be:

SELECT * FROM tblGamesPlayed WHERE TimePlayed >= '12:00:00' AND TimePlayed <= '15:00:00';

The SQL statement to update the scores would be:

UPDATE tblGamesPlayed SET Score = Score * 1.15 WHERE GameID = 'G103';

The SQL statement:

SELECT GameID, MAX(Score) as Maximum
FROM tblGamesPlayed
GROUP BY GameID
ORDER BY Max(Score) DESC;

will output the GameID along with the highest score achieved for each game in descending order. This allows for quick identification of the best-performing game.

The SQL statement:

SELECT GameNumber, Left(PName,1) & Left(PSurname,1) & "-" AS Reference
FROM tblPlayers, tblGamesPlayed
WHERE tblPlayers.PlayerID = tblGamesPlayed.PlayerID;

will produce a result that combines the initials of the Player's name and surname followed by a hyphen, along with the GameNumber corresponding to their played game.

1. Including an ID number ensures that each player has a unique identifier, which prevents confusion in record-keeping.
2. A date of birth field can help in determining player eligibility for certain age-specific competitions and may also serve as a secondary identifier.

1. Use prepared statements or parameterized queries to ensure that all user inputs are treated safely, avoiding the execution of unauthorized SQL commands.
2. Validate and sanitize all input data before it is processed by the database to prevent malicious entries.