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

ICTDBS407 Mapping and Delivery Guide
Monitor physical database implementation

Version 1.0
Issue Date: March 2024


Qualification -
Unit of Competency ICTDBS407 - Monitor physical database implementation
Description
Employability Skills
Learning Outcomes and Application This unit describes the skills and knowledge required to undertake database-management system modelling and to monitor database performance.It applies to database support staff required to test and scrutinise the operation of a physical database, in order to ensure that it functions as efficiently as possible.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 database field of work, and include access to:

industry software packages

the database management system (DBMS)

the target database prototype

testing and benchmarking software.

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: Undertake database
       
Element: management system modelling
  • Review the database prototype as appropriate, to determine the acceptance criteria and performance standards
  • Load the test data according to the technical sequence detailed in the relevant documentation
  • Generate a test schedule for the database, of tasks to be performed and the results expected
       
Element: Monitor database performance
  • Evaluate database performance against the acceptance criteria and performance standards
  • Identify discrepancies in the results, when the expected outcomes do not meet the acceptance criteria
  • Identify areas needing enhancement, and document the changes to be made
  • Modify the database according to project standards
  • Repeat performance testing until the expected results are achieved
       
Element: Seek client feedback and sign-off
  • Present test results in a document, and provide to the client for feedback
  • Incorporate client change requests as appropriate
  • Obtain client sign-off to the monitoring process
       


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. Undertake database

management system modelling

1.1 Review the database prototype as appropriate, to determine the acceptance criteria and performance standards

1.2 Load the test data according to the technical sequence detailed in the relevant documentation

1.3 Generate a test schedule for the database, of tasks to be performed and the results expected

2. Monitor database performance

2.1 Evaluate database performance against the acceptance criteria and performance standards

2.2 Identify discrepancies in the results, when the expected outcomes do not meet the acceptance criteria

2.3 Identify areas needing enhancement, and document the changes to be made

2.4 Modify the database according to project standards

2.5 Repeat performance testing until the expected results are achieved

3. Seek client feedback and sign-off

3.1 Present test results in a document, and provide to the client for feedback

3.2 Incorporate client change requests as appropriate

3.3 Obtain client sign-off to the monitoring process

Evidence of the ability to:

identify technical considerations affecting the implementation of a database

analyse and monitor performance issues during the implementation of a database

modify a database to meet project and client performance requirements.

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:

describe the client business domain

list current industry-accepted hardware and software products

describe requirements of basic database design

identify required database performance standards

outline quality assurance practices

outline testing and benchmarking processes

list three or more current principles of databases.


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. Undertake database

management system modelling

1.1 Review the database prototype as appropriate, to determine the acceptance criteria and performance standards

1.2 Load the test data according to the technical sequence detailed in the relevant documentation

1.3 Generate a test schedule for the database, of tasks to be performed and the results expected

2. Monitor database performance

2.1 Evaluate database performance against the acceptance criteria and performance standards

2.2 Identify discrepancies in the results, when the expected outcomes do not meet the acceptance criteria

2.3 Identify areas needing enhancement, and document the changes to be made

2.4 Modify the database according to project standards

2.5 Repeat performance testing until the expected results are achieved

3. Seek client feedback and sign-off

3.1 Present test results in a document, and provide to the client for feedback

3.2 Incorporate client change requests as appropriate

3.3 Obtain client sign-off to the monitoring process

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
 
Review the database prototype as appropriate, to determine the acceptance criteria and performance standards 
Load the test data according to the technical sequence detailed in the relevant documentation 
Generate a test schedule for the database, of tasks to be performed and the results expected 
Evaluate database performance against the acceptance criteria and performance standards 
Identify discrepancies in the results, when the expected outcomes do not meet the acceptance criteria 
Identify areas needing enhancement, and document the changes to be made 
Modify the database according to project standards 
Repeat performance testing until the expected results are achieved 
Present test results in a document, and provide to the client for feedback 
Incorporate client change requests as appropriate 
Obtain client sign-off to the monitoring process 

Forms

Assessment Cover Sheet

ICTDBS407 - Monitor physical database implementation
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

ICTDBS407 - Monitor physical database implementation

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: