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

ICTDBS412 Mapping and Delivery Guide
Build a database

Version 1.0
Issue Date: April 2024


Qualification -
Unit of Competency ICTDBS412 - Build a database
Description
Employability Skills
Learning Outcomes and Application This unit describes the skills and knowledge required to build, implement, test and evaluate a database, using an established design.It applies individuals employed as database administrators and designers who are required to build databases for information storage and retrieval requirements.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

business requirements and strategy

database design documentation

database software

database programming language.

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: Confirm the database design
  • Review the database design documentation, including data structures, queries, reports and user interface
  • Compare the database access and security feature design with the organisational security plan
  • Document inconsistencies in the database and security design
       
Element: Create a prototype
  • Develop a prototype according to the database design
  • Populate database tables with suitable data, including current business data
  • Write conversion programs to import data from existing systems
  • Develop test data to assess database features
  • Assess functionality of the prototype with the client, including identifying errors in the program code, and modifying screens, and reports
  • Incorporate feedback from the client into the prototype
  • Obtain client sign-off for the prototype
       
Element: Test the database
  • Develop an implementation plan for the database
  • Install database management system software on the network
  • Populate the database tables with business data
  • Implement security and access controls
  • Test database output and security controls, and record results
       
Element: Evaluate the database
  • Review the database with the client for final approval
  • Complete database documentation
  • Identify and document user training requirements
  • Seek and secure client acceptance of 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. Confirm the database design

1.1 Review the database design documentation, including data structures, queries, reports and user interface

1.2 Compare the database access and security feature design with the organisational security plan

1.3 Document inconsistencies in the database and security design

2. Create a prototype

2.1 Develop a prototype according to the database design

2.2 Populate database tables with suitable data, including current business data

2.3 Write conversion programs to import data from existing systems

2.4 Develop test data to assess database features

2.5 Assess functionality of the prototype with the client, including identifying errors in the program code, and modifying screens, and reports

2.6 Incorporate feedback from the client into the prototype

2.7 Obtain client sign-off for the prototype

3. Test the database

3.1 Develop an implementation plan for the database

3.2 Install database management system software on the network

3.3 Populate the database tables with business data

3.4 Implement security and access controls

3.5 Test database output and security controls, and record results

4. Evaluate the database

4.1 Review the database with the client for final approval

4.2 Complete database documentation

4.3 Identify and document user training requirements

4.4 Seek and secure client acceptance of the database

Evidence of the ability to:

identify client data management and security requirements

produce a prototype data base

populate and perform tests

discuss results with client for approval

implement the data base with the client.

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:

outline the principles of data base design including :

database management system (DBMS) fundamentals particularly during the design phase

describe the functions and features of a database

describe logical data modelling

outline object-model design concepts related to:

developing data structures

development of a prototype

queries

screens

reports

explain the physical design concepts in relation to a prototype

recognise and describe run-time facilities related to implementing a live database and operation of a prototype

describe and apply structured query programming language (SQL).

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. Confirm the database design

1.1 Review the database design documentation, including data structures, queries, reports and user interface

1.2 Compare the database access and security feature design with the organisational security plan

1.3 Document inconsistencies in the database and security design

2. Create a prototype

2.1 Develop a prototype according to the database design

2.2 Populate database tables with suitable data, including current business data

2.3 Write conversion programs to import data from existing systems

2.4 Develop test data to assess database features

2.5 Assess functionality of the prototype with the client, including identifying errors in the program code, and modifying screens, and reports

2.6 Incorporate feedback from the client into the prototype

2.7 Obtain client sign-off for the prototype

3. Test the database

3.1 Develop an implementation plan for the database

3.2 Install database management system software on the network

3.3 Populate the database tables with business data

3.4 Implement security and access controls

3.5 Test database output and security controls, and record results

4. Evaluate the database

4.1 Review the database with the client for final approval

4.2 Complete database documentation

4.3 Identify and document user training requirements

4.4 Seek and secure client acceptance of 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
Review the database design documentation, including data structures, queries, reports and user interface 
Compare the database access and security feature design with the organisational security plan 
Document inconsistencies in the database and security design 
Develop a prototype according to the database design 
Populate database tables with suitable data, including current business data 
Write conversion programs to import data from existing systems 
Develop test data to assess database features 
Assess functionality of the prototype with the client, including identifying errors in the program code, and modifying screens, and reports 
Incorporate feedback from the client into the prototype 
Obtain client sign-off for the prototype 
Develop an implementation plan for the database 
Install database management system software on the network 
Populate the database tables with business data 
Implement security and access controls 
Test database output and security controls, and record results 
Review the database with the client for final approval 
Complete database documentation 
Identify and document user training requirements 
Seek and secure client acceptance of the database 

Forms

Assessment Cover Sheet

ICTDBS412 - Build a database
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

ICTDBS412 - Build a database

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: