May/June 2026 Paper 12

A computer game developer stores data about a computer game in a database. The database has three entities:

Describe the relationships between the three entities.

The database is created with four tables:

01PLAYER(PlayerID, PlayerName, DateJoined)0203CHARACTER(CharacterID, CharacterName, DateCreated, Level,04          NumberOfPoints, PlayerID)0506GROUP(GroupID, GroupName, Category)0708CHARACTER_GROUP(CharacterGroupID, CharacterID, GroupID,09                DateJoinedGroup)

The given Structured Query Language (SQL) script is written to define the table CHARACTER.

0101  CREATE TABLE CHARACTER(0202      CharacterID INT,0303      CharacterName VARCHAR,0404      DateCreated DATE,0505      TheLevel INT,0606      NumberOfPoints INT,0707      PlayerID VARCHAR,0808      PRIMARY KEY CharacterID,0909      FOREIGN KEY(PlayerID)1010  );

The SQL script contains four errors. Give the line number of each error and the corrected line.

Write an SQL script to return each player’s name and the number of characters each player has created. The result needs to include a suitable field name for the number of characters. Order the results in descending order of player ID.

Complete the description of database key terms by writing the missing words.

The (blank 1) stores data about the data in the database. The table names, field names and relationships will be stored. Two other examples of data that will be stored are (blank 2) and (blank 3). When designing a database, the (blank 4) schema is the design of the database tables, fields and relationships independent of any Database Management System (DBMS). A DBMS provides security features to protect the data. (blank 5) are used to give user accounts permission to read data, some to read and write data and others may be unable to read the data. When creating a database, a (blank 6) provides tools to create visual components, for example forms and reports.