NTISthis.com

Evidence Guide: ICTDBS409 - Monitor and administer a database

Student: __________________________________________________

Signature: _________________________________________________

Tips for gathering evidence to demonstrate your skills

The important thing to remember when gathering evidence is that the more evidence the better - that is, the more evidence you gather to demonstrate your skills, the more confident an assessor can be that you have learned the skills not just at one point in time, but are continuing to apply and develop those skills (as opposed to just learning for the test!). Furthermore, one piece of evidence that you collect will not usualy demonstrate all the required criteria for a unit of competency, whereas multiple overlapping pieces of evidence will usually do the trick!

From the Wiki University

 

ICTDBS409 - Monitor and administer a database

What evidence can you provide to prove your understanding of each of the following citeria?

Start up a database

  1. Configure the system for a database start-up
  2. Monitor the database start-up and operation for irregularities
Configure the system for a database start-up

Completed
Date:

Teacher:
Evidence:

 

 

 

 

 

 

 

Monitor the database start-up and operation for irregularities

Completed
Date:

Teacher:
Evidence:

 

 

 

 

 

 

 

Manage the database

  1. Take action to ensure that a data dictionary has been compiled and that data structures are in place
  2. Maintain data integrity constraints, according to business requirements
  3. Create and design indexes, and multiple-field keys, according to business requirements
  4. Monitor the locking options chosen for the database
  5. Confirm that recent backups of the database have been stored, and that backups can be retrieved as a full working copy
  6. Monitor data storage space for ongoing viability, and resize as needed
  7. Update the data according to organisational guidelines
Take action to ensure that a data dictionary has been compiled and that data structures are in place

Completed
Date:

Teacher:
Evidence:

 

 

 

 

 

 

 

Maintain data integrity constraints, according to business requirements

Completed
Date:

Teacher:
Evidence:

 

 

 

 

 

 

 

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

Completed
Date:

Teacher:
Evidence:

 

 

 

 

 

 

 

Monitor the locking options chosen for the database

Completed
Date:

Teacher:
Evidence:

 

 

 

 

 

 

 

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

Completed
Date:

Teacher:
Evidence:

 

 

 

 

 

 

 

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

Completed
Date:

Teacher:
Evidence:

 

 

 

 

 

 

 

Update the data according to organisational guidelines

Completed
Date:

Teacher:
Evidence:

 

 

 

 

 

 

 

Manage database access

  1. Allocate or remove access privileges according to user status
  2. Monitor network server log-in log file for illegal log-in attempts, or for security breaches
  3. Manage system resources in the context of database administration
Allocate or remove access privileges according to user status

Completed
Date:

Teacher:
Evidence:

 

 

 

 

 

 

 

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

Completed
Date:

Teacher:
Evidence:

 

 

 

 

 

 

 

Manage system resources in the context of database administration

Completed
Date:

Teacher:
Evidence:

 

 

 

 

 

 

 

Document database maintenance tasks

  1. Document changes to database start-up procedures
  2. Itemise database management structures
  3. File authorisations for access changes
  4. Detail the procedures for monitoring log files
  5. Record the procedures to manage systems resources
Document changes to database start-up procedures

Completed
Date:

Teacher:
Evidence:

 

 

 

 

 

 

 

Itemise database management structures

Completed
Date:

Teacher:
Evidence:

 

 

 

 

 

 

 

File authorisations for access changes

Completed
Date:

Teacher:
Evidence:

 

 

 

 

 

 

 

Detail the procedures for monitoring log files

Completed
Date:

Teacher:
Evidence:

 

 

 

 

 

 

 

Record the procedures to manage systems resources

Completed
Date:

Teacher:
Evidence:

 

 

 

 

 

 

 

Assessed

Teacher: ___________________________________ Date: _________

Signature: ________________________________________________

Comments:

 

 

 

 

 

 

 

 

Instructions to Assessors

Evidence Guide

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

Required Skills and Knowledge

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.