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

ICTDBS401 Mapping and Delivery Guide
Identify physical database requirements

Version 1.0
Issue Date: April 2024


Qualification -
Unit of Competency ICTDBS401 - Identify physical database requirements
Description
Employability Skills
Learning Outcomes and Application This unit describes the skills and knowledge required to identify the scope, and the physical and security requirements of a database.It applies to individuals employed as database administrators who are required to plan a database to a user’s 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:

special purpose materials and industry software packages

user business requirements

technical documentation defining the architecture platform

operating system specifications

database supplier technical specifications and manuals

data samples

the database package.

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: Identify the database scope
  • Review the requirements of the user, and the current system’s architecture
  • Determine database size from the requirements and the technical specifications
  • Document the database design, and scope, of the project
  • Evaluate several database management systems against the requirements, and make the appropriate selection
       
Element: Identify the database requirements
  • Review the technical specifications for the database
  • Identify the database tables and relationships
  • Identify the database data dictionary, table attributes and keys
  • Determine the database reports based on the acceptance criteria and requirements
       
Element: Identify the security requirements
  • Review the system security plan
  • Clarify and confirm that the database management system, and user security, aligns with the system security plan
  • Identify, evaluate and record database performance, recovery and audit trail needs
       
Element: Seek client feedback and approval
  • Present database scope, technical requirements and security documentation to the user for feedback
  • Review user feedback and adjust the database documentation, as required
  • Present database documentation to the user for final approval
       


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. Identify the database scope

1.1 Review the requirements of the user, and the current system’s architecture

1.2 Determine database size from the requirements and the technical specifications

1.3 Document the database design, and scope, of the project

1.4 Evaluate several database management systems against the requirements, and make the appropriate selection

2. Identify the database requirements

2.1 Review the technical specifications for the database

2.2 Identify the database tables and relationships

2.3 Identify the database data dictionary, table attributes and keys

2.4 Determine the database reports based on the acceptance criteria and requirements

3.Identify the security requirements

3.1 Review the system security plan

3.2 Clarify and confirm that the database management system, and user security, aligns with the system security plan

3.3 Identify, evaluate and record database performance, recovery and audit trail needs

4. Seek client feedback and approval

4.1 Present database scope, technical requirements and security documentation to the user for feedback

4.2 Review user feedback and adjust the database documentation, as required

4.3 Present database documentation to the user for final approval

Evidence of the ability to:

analyse client requirements

identify the technical considerations affecting the physical design of a database

document the database requirements

review the security plan for the database.

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:

explain the principles of databases and database design

outline the general features, and capabilities, of current industry-accepted hardware and software products

explain the quality assurance practices that apply to database design

identify the client’s business domain

describe database requirements appropriate for client’s business.

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. Identify the database scope

1.1 Review the requirements of the user, and the current system’s architecture

1.2 Determine database size from the requirements and the technical specifications

1.3 Document the database design, and scope, of the project

1.4 Evaluate several database management systems against the requirements, and make the appropriate selection

2. Identify the database requirements

2.1 Review the technical specifications for the database

2.2 Identify the database tables and relationships

2.3 Identify the database data dictionary, table attributes and keys

2.4 Determine the database reports based on the acceptance criteria and requirements

3.Identify the security requirements

3.1 Review the system security plan

3.2 Clarify and confirm that the database management system, and user security, aligns with the system security plan

3.3 Identify, evaluate and record database performance, recovery and audit trail needs

4. Seek client feedback and approval

4.1 Present database scope, technical requirements and security documentation to the user for feedback

4.2 Review user feedback and adjust the database documentation, as required

4.3 Present database documentation to the user for final approval

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 requirements of the user, and the current system’s architecture 
Determine database size from the requirements and the technical specifications 
Document the database design, and scope, of the project 
Evaluate several database management systems against the requirements, and make the appropriate selection 
Review the technical specifications for the database 
Identify the database tables and relationships 
Identify the database data dictionary, table attributes and keys 
Determine the database reports based on the acceptance criteria and requirements 
Review the system security plan 
Clarify and confirm that the database management system, and user security, aligns with the system security plan 
Identify, evaluate and record database performance, recovery and audit trail needs 
Present database scope, technical requirements and security documentation to the user for feedback 
Review user feedback and adjust the database documentation, as required 
Present database documentation to the user for final approval 

Forms

Assessment Cover Sheet

ICTDBS401 - Identify physical database requirements
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

ICTDBS401 - Identify physical database requirements

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: