NTISthis.com

Evidence Guide: ICTGAM527 - 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

 

ICTGAM527 - 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 the appropriate application programming interfaces (APIs)
  2. Identify the specific APIs suitable for the game architecture and the data source provider
  3. Install the nominated APIs on game development computers
Research the appropriate application programming interfaces (APIs)

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

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

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Install the nominated APIs on game development computers

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Define and use a connection to the data source

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

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

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

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Open and close the connection to the game data source

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Configure and use the connection pooling

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

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

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

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

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

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Test and verify the use of connection pooling

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Pass embedded structured query language (SQL) to the database

  1. Define the database connection property
  2. Compose a structured query language (SQL) statement or command to be passed to the database
  3. Test, debug and execute the SQL statement
Define the database connection property

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Compose a structured query language (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 a command callable statement
  2. Define and pass the parameters to the stored procedure
  3. Test, debug and execute the database stored procedure
Call a stored procedure on the database, using a command callable statement

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Define and pass the parameters to the stored procedure

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Test, debug and execute the 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 the 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 the data from an updateable cursor into the game application domain

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Test and debug database integration code

  1. Test the database integration code
  2. Document the test results
  3. Determine the errors and exceptions, and document the 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 the database integration code

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Document the test results

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Determine the errors and exceptions, and document the 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:

 

 

 

 

 

 

 

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

  1. Research the appropriate application programming interfaces (APIs)
  2. Identify the specific APIs suitable for the game architecture and the data source provider
  3. Install the nominated APIs on game development computers
Research the appropriate application programming interfaces (APIs)

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

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

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Install the nominated APIs on game development computers

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Assessed

Teacher: ___________________________________ Date: _________

Signature: ________________________________________________

Comments:

 

 

 

 

 

 

 

 

Instructions to Assessors

Evidence Guide

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

Required Skills and Knowledge

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.