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

ICTDBS409 Mapping and Delivery Guide
Monitor and administer a database

Version 1.0
Issue Date: April 2024


Qualification -
Unit of Competency ICTDBS409 - Monitor and administer a database
Description
Employability Skills
Learning Outcomes and Application This unit describes the skills and knowledge required to manage databases including start up, operation, testing, monitoring and maintenance, in accordance with organisational requirements.It applies to individuals employed as database support staff who are required to maintain a database, monitor its performance and access, as well as to administer its security.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

a live database, preferably on a local area network (LAN) on which there is a server that offers log-in functionality.

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: Start up a database
  • Configure the system for a database start-up
  • Monitor the database start-up and operation for irregularities
       
Element: Manage the database
  • Take action to ensure that a data dictionary has been compiled and that data structures are in place
  • Maintain data integrity constraints, according to business requirements
  • Create and design indexes, and multiple-field keys, according to business requirements
  • Monitor the locking options chosen for the database
  • Confirm that recent backups of the database have been stored, and that backups can be retrieved as a full working copy
  • Monitor data storage space for ongoing viability, and resize as needed
  • Update the data according to organisational guidelines
       
Element: Manage database access
  • Allocate or remove access privileges according to user status
  • Monitor network server log-in log file for illegal log-in attempts, or for security breaches
  • Manage system resources in the context of database administration
       
Element: Document database maintenance tasks
  • Document changes to database start-up procedures
  • Itemise database management structures
  • File authorisations for access changes
  • Detail the procedures for monitoring log files
  • Record the procedures to manage systems resources
       


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. Start up a database

1.1 Configure the system for a database start-up

1.2 Monitor the database start-up and operation for irregularities

2. Manage the database

2.1 Take action to ensure that a data dictionary has been compiled and that data structures are in place

2.2 Maintain data integrity constraints, according to business requirements

2.3 Create and design indexes, and multiple-field keys, according to business requirements

2.4 Monitor the locking options chosen for the database

2.5 Confirm that recent backups of the database have been stored, and that backups can be retrieved as a full working copy

2.6 Monitor data storage space for ongoing viability, and resize as needed

2.7 Update the data according to organisational guidelines

3. Manage database access

3.1 Allocate or remove access privileges according to user status

3.2 Monitor network server log-in log file for illegal log-in attempts, or for security breaches

3.3 Manage system resources in the context of database administration

4. Document database maintenance tasks

4.1 Document changes to database start-up procedures

4.2 Itemise database management structures

4.3 File authorisations for access changes

4.4 Detail the procedures for monitoring log files

4.5 Record the procedures to manage systems resources

Evidence of the ability to:

configure a database start-up

confirm data integrity

monitor data storage requirements for database

update data

update database access.

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 backup and recovery methodologies

explain the architectural design of relational databases

explain the concept of database security

outline the process involved in the selection and use of appropriate database management tools

explain the principles of structured query language (SQL)

outline the tasks involved in database administration

outline the tuning methodologies.

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. Start up a database

1.1 Configure the system for a database start-up

1.2 Monitor the database start-up and operation for irregularities

2. Manage the database

2.1 Take action to ensure that a data dictionary has been compiled and that data structures are in place

2.2 Maintain data integrity constraints, according to business requirements

2.3 Create and design indexes, and multiple-field keys, according to business requirements

2.4 Monitor the locking options chosen for the database

2.5 Confirm that recent backups of the database have been stored, and that backups can be retrieved as a full working copy

2.6 Monitor data storage space for ongoing viability, and resize as needed

2.7 Update the data according to organisational guidelines

3. Manage database access

3.1 Allocate or remove access privileges according to user status

3.2 Monitor network server log-in log file for illegal log-in attempts, or for security breaches

3.3 Manage system resources in the context of database administration

4. Document database maintenance tasks

4.1 Document changes to database start-up procedures

4.2 Itemise database management structures

4.3 File authorisations for access changes

4.4 Detail the procedures for monitoring log files

4.5 Record the procedures to manage systems resources

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
Configure the system for a database start-up 
Monitor the database start-up and operation for irregularities 
Take action to ensure that a data dictionary has been compiled and that data structures are in place 
Maintain data integrity constraints, according to business requirements 
Create and design indexes, and multiple-field keys, according to business requirements 
Monitor the locking options chosen for the database 
Confirm that recent backups of the database have been stored, and that backups can be retrieved as a full working copy 
Monitor data storage space for ongoing viability, and resize as needed 
Update the data according to organisational guidelines 
Allocate or remove access privileges according to user status 
Monitor network server log-in log file for illegal log-in attempts, or for security breaches 
Manage system resources in the context of database administration 
Document changes to database start-up procedures 
Itemise database management structures 
File authorisations for access changes 
Detail the procedures for monitoring log files 
Record the procedures to manage systems resources 

Forms

Assessment Cover Sheet

ICTDBS409 - Monitor and administer 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

ICTDBS409 - Monitor and administer 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: