NTISthis.com

Evidence Guide: ICAGAM527A - Integrate database with online game

Student: __________________________________________________

Signature: _________________________________________________

Tips for gathering evidence to demonstrate your skills

The important thing to remember when gathering evidence is that the more evidence the better - that is, the more evidence you gather to demonstrate your skills, the more confident an assessor can be that you have learned the skills not just at one point in time, but are continuing to apply and develop those skills (as opposed to just learning for the test!). Furthermore, one piece of evidence that you collect will not usualy demonstrate all the required criteria for a unit of competency, whereas multiple overlapping pieces of evidence will usually do the trick!

From the Wiki University

 

ICAGAM527A - Integrate database with online game

What evidence can you provide to prove your understanding of each of the following citeria?

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

  1. Research appropriate APIs
  2. Identify specific APIs as suitable for the game architecture and data source provider
  3. Install nominated APIs on game development computers
Research appropriate APIs

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

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

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Install nominated APIs on game development computers

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Define and use a connection to the data source

  1. Define game data source connection parameters
  2. Store connection parameters in external text-based configuration file
  3. Open and close connection to the game data source
Define game data source connection parameters

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Store connection parameters in external text-based configuration file

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Open and close connection to the game data source

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Configure and use connection pooling

  1. Configure connection pooling in the database management system
  2. Define connection pool parameters for minimum connections, maximum connections and idle connections
  3. Minimise use of database resources through the use of connection pooling
  4. Test and verify use of connection pooling
Configure connection pooling in the database management system

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

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

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Minimise use of database resources through the use of connection pooling

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Test and verify use of connection pooling

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Pass embedded structured query language (SQL) to the database

  1. Define database connection property
  2. Compose SQL statement or command to be passed to the database
  3. Test, debug and execute the SQL statement
Define database connection property

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Compose SQL statement or command to be passed to the database

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Test, debug and execute the SQL statement

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Execute a stored procedure on a database

  1. Call a stored procedure on the database using command callable statement
  2. Define and pass parameters to the stored procedure
  3. Test, debug and execute database stored procedure
Call a stored procedure on the database using command callable statement

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Define and pass parameters to the stored procedure

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Test, debug and execute database stored procedure

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Modify database data

  1. Retrieve multi-row multi-column result sets from the database into the game application domain
  2. Insert new records into the database
  3. Update existing database records
  4. Delete existing database records
Retrieve multi-row multi-column result sets from the database into the game application domain

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Insert new records into the database

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Update existing database records

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Delete existing database records

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Integrate data from the database with the game application domain

  1. Integrate data from a forward-only and read-only cursor into the game application domain
  2. Incorporate data from an updateable cursor into the game application domain
Integrate data from a forward-only and read-only cursor into the game application domain

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Incorporate data from an updateable cursor into the game application domain

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Test and debug database integration code

  1. Test database integration code
  2. Document test results
  3. Determine errors and exceptions and document solutions
  4. Debug all errors and exceptions
  5. Assess all data modifications in the database and document any errors
  6. Correct all causes to data modification errors
Test database integration code

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Document test results

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Determine errors and exceptions and document solutions

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Debug all errors and exceptions

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Assess all data modifications in the database and document any errors

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Correct all causes to data modification errors

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Assessed

Teacher: ___________________________________ Date: _________

Signature: ________________________________________________

Comments:

 

 

 

 

 

 

 

 

Instructions to Assessors

Evidence Guide

The evidence guide provides advice on assessment and must be read in conjunction with the performance criteria, required skills and knowledge, range statement and the Assessment Guidelines for the Training Package.

Overview of assessment

Critical aspects for assessment and evidence required to demonstrate competency in this unit

Evidence of the ability to:

add database functionality to an online game

display and modify the database data provided by game-play input.

Context of and specific resources for assessment

Assessment must ensure access to:

game design specification and requirements documentation

game server

database server

integrated development environment software and hardware

browsers for browser-based games

game consoles for console-based games

appropriate learning and assessment support when required

modified equipment for people with special needs.

Method of assessment

A range of assessment methods should be used to assess practical skills and knowledge. The following examples are appropriate for this unit:

evaluation of an online game that can access, display and update game state data stored in a database

verbal and written questioning to assess the knowledge associated with the integration of a database with an online game.

Guidance information for assessment

Holistic assessment with other units relevant to the industry sector, workplace and job role is recommended, where appropriate.

Assessment processes and techniques must be culturally appropriate, and suitable to the communication skill level, language, literacy and numeracy capacity of the candidate and the work being performed.

Indigenous people and other people from a non-English speaking background may need additional support.

In cases where practical assessment is used it should be combined with targeted questioning to assess required knowledge.

Required Skills and Knowledge

Required skills

analytical skills to:

analyse game application domain and game architecture and determine appropriate APIs as prescribed by the selected proprietary or database industry standards

determine appropriate connection pooling implementation requirements

determine appropriate development environments for the game architecture and database integration functionality

communication skills to:

describe and evaluate data access and data modification architectures with game designers and game architects

negotiate game data requirements with project managers, game designers and game architects

propose data access and modify functionality to meet the needs of the online game

initiative and enterprise skills to:

assess proposed database integration architectures within the context of existing game development technologies, development infrastructure and game industry standards

recommend solutions to difficulties or flaws identified with the integration of the database and the online game

learning skills to:

acquire the skills and knowledge required to integrate a database with an online game

ensure the use of leading edge industry developments and industry standards

literacy skills to:

delineate existing game architecture documentation

document database integration specifications for an online game

interpret and understand industry standards, game architecture standards, and database standards

planning and organisational skills:

organise resources, documentation and infrastructure elements required for the integration of a database with an online game

plan the effective integration of a database with an online game

problem-solving skills to:

debug code, identify code bugs and resolve all code exceptions

identify and implement solutions to problems with the integration of a database with an online game

identify problems with SQL and stored procedures and implement solutions

research skills to:

enhance knowledge of industry standards and trends related to the integration of a database with an online game

identify and locate sources of information that provide solutions to technical problems

identify sources of information and documentation required to plan and implement the integration of a database with an online game

technical skills to:

implement complex code algorithms required for the integration of a database with an online game

implement exception handling routines in code

improve the efficiency of code by refactoring

use an integrated development environment to build database integration code

write code to integrate a database with an online game.

Required knowledge

relational database theory, including:

how to create and test stored procedures

how to create ‘embedded’ SQL and assign parameters in code for filtering

how and why tables are related and how relationships between tables are implemented

how SQL is used to retrieve data from multiple tables

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

how to implement cascading updates and deletes

game development

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

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

web development.

Range Statement

The range statement relates to the unit of competency as a whole. It allows for different work environments and situations that may affect performance. Bold italicised wording, if used in the performance criteria, is detailed below. Essential operating conditions that may be present with training and assessment (depending on the work situation, needs of the candidate, accessibility of the item, and local industry and regional contexts) may also be included.

Data source provider may include:

DB2

Infomix

Ingres

Microsoft Access

Microsoft SQL (MS SQL) server

Mini SQL (mSQL)

MySQL

Oracle

Sybase.

External text-based configuration file may include:

any text-based file format that will not require re-compilation if properties of the connection to the database change

in ASP.Net, framework the web configuration (web.config) file and machine configuration (machine.config) file

files formatted as eXtensible markup language (XML) files or documents

traditional ASCII-based text files with file extension of .ini.

Parameters may include:

data type property appropriate to the data source provider

direction property defining either input or output

value property derived from the actual game play.

Forward-only and read-only cursor may include:

data-reader object

forward-only record set

Java forward-only result set.

Updateable cursor may include:

data-set object

record-set object

result-set object.