Unit of Competency Mapping – Information for Teachers/Assessors – Information for Learners

ICTGAM419 Mapping and Delivery Guide
Build a database to support a computer game

Version 1.0
Issue Date: April 2024


Qualification -
Unit of Competency ICTGAM419 - Build a database to support a computer game
Description
Employability Skills
Learning Outcomes and Application This unit describes the skills and knowledge required to design, and to implement, a relational database for the management of the persisted- state world of a computer game.It applies to individuals who work as game programmers or junior analyst programmers in the digital and interactive games industry, either as small independent specialists, or as part of a larger team.No licensing, legislative or certification requirements apply to this unit at the time of publication.
Duration and Setting X weeks, nominally xx hours, delivered in a classroom/online/blended learning setting.

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:

computer-aided software engineering and modelling tools

a relational or object-oriented database management system

performance testing and analysis software for selected database management system/ game architecture specifications

the game design and requirements documentation

the client or server hardware

networking infrastructure sufficient to simulate the game architecture specifications.

Assessors must satisfy NVR/AQTF assessor requirements.
Prerequisites/co-requisites
Competency Field
Development and validation strategy and guide for assessors and learners Student Learning Resources Handouts
Activities 		Slides
PPT 		Assessment 1 Assessment 2 Assessment 3 Assessment 4
Elements of Competency Performance Criteria              
Element: Verify the database model
  • Verify that the game architecture and system implementation requirements have been addressed by the proposed database architecture
  • Correlate data model entities and their attributes with the game artefacts, and the game design requirements
  • Verify that the entity relationships defined in the data model implement the game-design and game-play rules
  • Verify the estimates of the amounts of data storage required, and the data types defined by the data model
  • Document design inconsistencies
  • Review the database model and address, and correct any inconsistencies
  • Define the database test data
       
Element: Create the physical database design
  • Implement the conceptual data model design as a physical database design
  • Determine the default database file size, according to the data model storage estimates
  • Determine game data input and output workload estimates
  • Determine the reliability and performance requirements
  • Define the minimum hardware requirements to support the input and output workload and reliability or performance requirements
  • Configure the database management system in order to use minimum hardware requirements
  • Refine and confirm the database test data
       
Element: Implement the physical database prototype
  • Write structured query language (SQL) scripts to create physical database files according to the design requirements
  • Write SQL scripts to create database tables
  • Implement the primary key constraints
  • Implement the foreign key constraints
  • Define, and script, stored procedures for selecting, inserting, updating and deleting data
  • Define and script insert statements for test data
  • Execute SQL scripts and database, including test data
       
Element: Test the database and document results
  • Document the entity integrity tests, and results
  • Document the referential integrity tests, and results
  • Document the input and output performance tests, and results
  • Document the stored procedures tests, and results
       
Element: Review, evaluate and correct database performance
  • Review the test result deficiencies
  • Define, evaluate and test the deficiencies, and ensure that corrective measures are implemented
  • Implement corrections to the database
       


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. Verify the database model

1.1 Verify that the game architecture and system implementation requirements have been addressed by the proposed database architecture

1.2 Correlate data model entities and their attributes with the game artefacts, and the game design requirements

1.3 Verify that the entity relationships defined in the data model implement the game-design and game-play rules

1.4 Verify the estimates of the amounts of data storage required, and the data types defined by the data model

1.5 Document design inconsistencies

1.6 Review the database model and address, and correct any inconsistencies

1.7 Define the database test data

2. Create the physical database design

2.1 Implement the conceptual data model design as a physical database design

2.2 Determine the default database file size, according to the data model storage estimates

2.3 Determine game data input and output workload estimates

2.4 Determine the reliability and performance requirements

2.5 Define the minimum hardware requirements to support the input and output workload and reliability or performance requirements

2.6 Configure the database management system in order to use minimum hardware requirements

2.7 Refine and confirm the database test data

3. Implement the physical database prototype

3.1 Write structured query language (SQL) scripts to create physical database files according to the design requirements

3.2 Write SQL scripts to create database tables

3.3 Implement the primary key constraints

3.4 Implement the foreign key constraints

3.5 Define, and script, stored procedures for selecting, inserting, updating and deleting data

3.6 Define and script insert statements for test data

3.7 Execute SQL scripts and database, including test data

4. Test the database and document results

4.1 Document the entity integrity tests, and results

4.2 Document the referential integrity tests, and results

4.3 Document the input and output performance tests, and results

4.4 Document the stored procedures tests, and results

5. Review, evaluate and correct database performance

5.1 Review the test result deficiencies

5.2 Define, evaluate and test the deficiencies, and ensure that corrective measures are implemented

5.3 Implement corrections to the database

Evidence of the ability to:

interpret a conceptual database model

create a database from a conceptual model, that allows for the persistence of state data for a computer game

evaluate, and improve, the performance of a database built to support a computer game.

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:

identify computer hardware specifications and performance required to support database development

discuss the creation, use and testing of stored procedures

explain why input and output parameters are required

explain database stress testing and stress testing software

discuss the principles of database testing methodologies

describe object-oriented database management systems

discuss the similarities and difference between relational database management systems:

IBM DB2

Microsoft Access

Microsoft SQL (MS SQL) server

MySQL

Oracle

Postgre Structured Query Language (Postgre SQL)

discuss relational database modelling building blocks and theory, including attributes, entity relationship modelling and normalisation of database tables

discuss relationship cardinality and connectivity:

1:1

1:M

M:N

outline the features, and functions, of structured query language (SQL), including data definition language and data manipulation language

discuss the evolution of relational database management systems and their relationship to the flat file, hierarchical, and network data storage legacy of games

outline the important functions of a relational database management system within the context of a computer game

interpret data access languages, such as SQL and language-integrated query (LINQ)

interpret data application programming interfaces (APIs) including:

ADO.Net

data integrity

disaster recovery and backups

data dictionary

data storage

security requirements of the data

transforming and presenting the data

discuss the importance of data models

describe the different types of data models, including Chen and Crow’s Foot models

describe the relationship between game-play rules and the modelling of the database structure.

Submission Requirements

List each assessment task's title, type (eg project, observation/demonstration, essay, assignment, 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. Verify the database model

1.1 Verify that the game architecture and system implementation requirements have been addressed by the proposed database architecture

1.2 Correlate data model entities and their attributes with the game artefacts, and the game design requirements

1.3 Verify that the entity relationships defined in the data model implement the game-design and game-play rules

1.4 Verify the estimates of the amounts of data storage required, and the data types defined by the data model

1.5 Document design inconsistencies

1.6 Review the database model and address, and correct any inconsistencies

1.7 Define the database test data

2. Create the physical database design

2.1 Implement the conceptual data model design as a physical database design

2.2 Determine the default database file size, according to the data model storage estimates

2.3 Determine game data input and output workload estimates

2.4 Determine the reliability and performance requirements

2.5 Define the minimum hardware requirements to support the input and output workload and reliability or performance requirements

2.6 Configure the database management system in order to use minimum hardware requirements

2.7 Refine and confirm the database test data

3. Implement the physical database prototype

3.1 Write structured query language (SQL) scripts to create physical database files according to the design requirements

3.2 Write SQL scripts to create database tables

3.3 Implement the primary key constraints

3.4 Implement the foreign key constraints

3.5 Define, and script, stored procedures for selecting, inserting, updating and deleting data

3.6 Define and script insert statements for test data

3.7 Execute SQL scripts and database, including test data

4. Test the database and document results

4.1 Document the entity integrity tests, and results

4.2 Document the referential integrity tests, and results

4.3 Document the input and output performance tests, and results

4.4 Document the stored procedures tests, and results

5. Review, evaluate and correct database performance

5.1 Review the test result deficiencies

5.2 Define, evaluate and test the deficiencies, and ensure that corrective measures are implemented

5.3 Implement corrections to the database

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
Verify that the game architecture and system implementation requirements have been addressed by the proposed database architecture 
Correlate data model entities and their attributes with the game artefacts, and the game design requirements 
Verify that the entity relationships defined in the data model implement the game-design and game-play rules 
Verify the estimates of the amounts of data storage required, and the data types defined by the data model 
Document design inconsistencies 
Review the database model and address, and correct any inconsistencies 
Define the database test data 
Implement the conceptual data model design as a physical database design 
Determine the default database file size, according to the data model storage estimates 
Determine game data input and output workload estimates 
Determine the reliability and performance requirements 
Define the minimum hardware requirements to support the input and output workload and reliability or performance requirements 
Configure the database management system in order to use minimum hardware requirements 
Refine and confirm the database test data 
Write structured query language (SQL) scripts to create physical database files according to the design requirements 
Write SQL scripts to create database tables 
Implement the primary key constraints 
Implement the foreign key constraints 
Define, and script, stored procedures for selecting, inserting, updating and deleting data 
Define and script insert statements for test data 
Execute SQL scripts and database, including test data 
Document the entity integrity tests, and results 
Document the referential integrity tests, and results 
Document the input and output performance tests, and results 
Document the stored procedures tests, and results 
Review the test result deficiencies 
Define, evaluate and test the deficiencies, and ensure that corrective measures are implemented 
Implement corrections to the database 

Forms

Assessment Cover Sheet

ICTGAM419 - Build a database to support a computer 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

ICTGAM419 - Build a database to support a computer 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: