Assessor Resource

ICTGAM527
Integrate database with online game

Assessment tool

Version 1.0
Issue Date: March 2024


This unit describes the skills and knowledge required to integrate a database with an online game, where the relationship between the game server and the database server is also considered a client-server relationship on a local area network.

It applies to individuals with high-level technical and problem solving skills working as programmers, analyst programmers and game programmers responsible for the development of code to connect a computer game to a database.

No licensing, legislative or certification requirements apply to this unit at the time of publication.

You may want to include more information here about the target group and the purpose of the assessments (eg formative, summative, recognition)



Evidence Required

List the assessment methods to be used and the context and resources required for assessment. Copy and paste the relevant sections from the evidence guide below and then re-write these in plain English.

ELEMENT

PERFORMANCE CRITERIA

Elements describe the essential outcomes.

Performance criteria describe the performance needed to demonstrate achievement of the element.

1. Install application programming interfaces (APIs) suitable to the game’s data source provider

1.1 Research the appropriate application programming interfaces (APIs)

1.2 Identify the specific APIs suitable for the game architecture and the data source provider

1.3 Install the nominated APIs on game development computers

2. Define and use a connection to the data source

2.1 Define the game data source connection parameters

2.2 Store the connection parameters in an external text-based configuration file

2.3 Open and close the connection to the game data source

3. Configure and use the connection pooling

3.1 Configure connection pooling in the database management system

3.2 Define the connection pool parameters for minimum connections, maximum connections, and idle connections

3.3 Minimise the use of database resources through the use of connection pooling

3.4 Test and verify the use of connection pooling

4. Pass embedded structured query language (SQL) to the database

4.1 Define the database connection property

4.2 Compose a structured query language (SQL) statement or command to be passed to the database

4.3 Test, debug and execute the SQL statement

5. Execute a stored procedure on a database

5.1 Call a stored procedure on the database, using a command callable statement

5.2 Define and pass the parameters to the stored procedure

5.3 Test, debug and execute the database stored procedure

6. Modify database data

6.1 Retrieve multi-row multi-column result sets from the database into the game application domain

6.2 Insert new records into the database

6.3 Update existing database records

6.4 Delete existing database records

7. Integrate data from the database with the game application domain

7.1 Integrate data from a forward-only and read-only cursor into the game application domain

7.2 Incorporate the data from an updateable cursor into the game application domain

8. Test and debug database integration code

8.1 Test the database integration code

8.2 Document the test results

8.3 Determine the errors and exceptions, and document the solutions

8.4 Debug all errors and exceptions

8.5 Assess all data modifications in the database, and document any errors

8.6 Correct all causes to data modification errors

Evidence of the ability to:

determine and install application programming interfaces (API) for games development

define and add database functionality to an online game

integrate, test and modify the database data provided by game-play input and document all errors and solutions.

Note: If a specific volume or frequency is not stated, then evidence must be provided at least once.

To complete the unit requirements safely and effectively, the individual must:

provide a detailed explanation of relational database theory, including how:

to create and test stored procedures

to create ‘embedded’ structured query language (SQL) and to assign parameters in the code for filtering

tables are related, and how relationships between tables are implemented

SQL is used to retrieve data from multiple tables

inserts to tables in parent/child relationships can be implemented using artificial (auto-generated) primary key values

to implement cascading updates and deletes

summarise the principles of game development

explain the principles of integrated development environments, including:

data access APIs and associated classes, required for the integration of a database with an online game

online help and documentation required for research and debugging code

user authentication and authorisation management

outline the methodologies and techniques required for effective and well-factored object-oriented program (OOP) code, including:

class implementation

control of logic flow

use of collections and lists

use of OOP concepts, such as inheritance, encapsulation and overloading

describe the implications of web development on games integration.

Gather evidence to demonstrate consistent performance in conditions that are safe and replicate the workplace. Noise levels, production flow, interruptions and time variances must be typical of those experienced in the game development field of work, and include access to:

the game design specification and requirements documentation

a game server

a database server

integrated development environment software and hardware

browsers for browser-based games or game consoles for console-based games.

Assessors must satisfy NVR/AQTF assessor requirements.


Submission Requirements

List each assessment task's title, type (eg project, observation/demonstration, essay, assingnment, checklist) and due date here

Assessment task 1: [title]      Due date:

(add new lines for each of the assessment tasks)


Assessment Tasks

Copy and paste from the following data to produce each assessment task. Write these in plain English and spell out how, when and where the task is to be carried out, under what conditions, and what resources are needed. Include guidelines about how well the candidate has to perform a task for it to be judged satisfactory.

ELEMENT

PERFORMANCE CRITERIA

Elements describe the essential outcomes.

Performance criteria describe the performance needed to demonstrate achievement of the element.

1. Install application programming interfaces (APIs) suitable to the game’s data source provider

1.1 Research the appropriate application programming interfaces (APIs)

1.2 Identify the specific APIs suitable for the game architecture and the data source provider

1.3 Install the nominated APIs on game development computers

2. Define and use a connection to the data source

2.1 Define the game data source connection parameters

2.2 Store the connection parameters in an external text-based configuration file

2.3 Open and close the connection to the game data source

3. Configure and use the connection pooling

3.1 Configure connection pooling in the database management system

3.2 Define the connection pool parameters for minimum connections, maximum connections, and idle connections

3.3 Minimise the use of database resources through the use of connection pooling

3.4 Test and verify the use of connection pooling

4. Pass embedded structured query language (SQL) to the database

4.1 Define the database connection property

4.2 Compose a structured query language (SQL) statement or command to be passed to the database

4.3 Test, debug and execute the SQL statement

5. Execute a stored procedure on a database

5.1 Call a stored procedure on the database, using a command callable statement

5.2 Define and pass the parameters to the stored procedure

5.3 Test, debug and execute the database stored procedure

6. Modify database data

6.1 Retrieve multi-row multi-column result sets from the database into the game application domain

6.2 Insert new records into the database

6.3 Update existing database records

6.4 Delete existing database records

7. Integrate data from the database with the game application domain

7.1 Integrate data from a forward-only and read-only cursor into the game application domain

7.2 Incorporate the data from an updateable cursor into the game application domain

8. Test and debug database integration code

8.1 Test the database integration code

8.2 Document the test results

8.3 Determine the errors and exceptions, and document the solutions

8.4 Debug all errors and exceptions

8.5 Assess all data modifications in the database, and document any errors

8.6 Correct all causes to data modification errors

Evidence of the ability to:

determine and install application programming interfaces (API) for games development

define and add database functionality to an online game

integrate, test and modify the database data provided by game-play input and document all errors and solutions.

Note: If a specific volume or frequency is not stated, then evidence must be provided at least once.

To complete the unit requirements safely and effectively, the individual must:

provide a detailed explanation of relational database theory, including how:

to create and test stored procedures

to create ‘embedded’ structured query language (SQL) and to assign parameters in the code for filtering

tables are related, and how relationships between tables are implemented

SQL is used to retrieve data from multiple tables

inserts to tables in parent/child relationships can be implemented using artificial (auto-generated) primary key values

to implement cascading updates and deletes

summarise the principles of game development

explain the principles of integrated development environments, including:

data access APIs and associated classes, required for the integration of a database with an online game

online help and documentation required for research and debugging code

user authentication and authorisation management

outline the methodologies and techniques required for effective and well-factored object-oriented program (OOP) code, including:

class implementation

control of logic flow

use of collections and lists

use of OOP concepts, such as inheritance, encapsulation and overloading

describe the implications of web development on games integration.

Gather evidence to demonstrate consistent performance in conditions that are safe and replicate the workplace. Noise levels, production flow, interruptions and time variances must be typical of those experienced in the game development field of work, and include access to:

the game design specification and requirements documentation

a game server

a database server

integrated development environment software and hardware

browsers for browser-based games or game consoles for console-based games.

Assessors must satisfy NVR/AQTF assessor requirements.

Copy and paste from the following performance criteria to create an observation checklist for each task. When you have finished writing your assessment tool every one of these must have been addressed, preferably several times in a variety of contexts. To ensure this occurs download the assessment matrix for the unit; enter each assessment task as a column header and place check marks against each performance criteria that task addresses.

Observation Checklist

Tasks to be observed according to workplace/college/TAFE policy and procedures, relevant legislation and Codes of Practice Yes No Comments/feedback
Research the appropriate application programming interfaces (APIs) 
Identify the specific APIs suitable for the game architecture and the data source provider 
Install the nominated APIs on game development computers 
Define the game data source connection parameters 
Store the connection parameters in an external text-based configuration file 
Open and close the connection to the game data source 
Configure connection pooling in the database management system 
Define the connection pool parameters for minimum connections, maximum connections, and idle connections 
Minimise the use of database resources through the use of connection pooling 
Test and verify the use of connection pooling 
Define the database connection property 
Compose a structured query language (SQL) statement or command to be passed to the database 
Test, debug and execute the SQL statement 
Call a stored procedure on the database, using a command callable statement 
Define and pass the parameters to the stored procedure 
Test, debug and execute the database stored procedure 
Retrieve multi-row multi-column result sets from the database into the game application domain 
Insert new records into the database 
Update existing database records 
Delete existing database records 
Integrate data from a forward-only and read-only cursor into the game application domain 
Incorporate the data from an updateable cursor into the game application domain 
Test the database integration code 
Document the test results 
Determine the errors and exceptions, and document the solutions 
Debug all errors and exceptions 
Assess all data modifications in the database, and document any errors 
Correct all causes to data modification errors 
Research the appropriate application programming interfaces (APIs) 
Identify the specific APIs suitable for the game architecture and the data source provider 
Install the nominated APIs on game development computers 

Forms

Assessment Cover Sheet

ICTGAM527 - Integrate database with online game
Assessment task 1: [title]

Student name:

Student ID:

I declare that the assessment tasks submitted for this unit are my own work.

Student signature:

Result: Competent Not yet competent

Feedback to student

 

 

 

 

 

 

 

 

Assessor name:

Signature:

Date:


Assessment Record Sheet

ICTGAM527 - Integrate database with online game

Student name:

Student ID:

Assessment task 1: [title] Result: Competent Not yet competent

(add lines for each task)

Feedback to student:

 

 

 

 

 

 

 

 

Overall assessment result: Competent Not yet competent

Assessor name:

Signature:

Date:

Student signature:

Date: