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. Determine the requirements of database administration | 1.1 Identify the components of a database instance 1.2 Define and use tools to administer the database |
2. Install and configure the database system | 2.1 Verify the database software installation prerequisites 2.2 Install the database software and related services 2.3 Configure database instance, components and services 2.4 Perform data management tasks |
3. Manage database security and integrity | 3.1 Create and administer users 3.2 Create and manage the permissions to perform database operations 3.3 Create and manage roles |
4. Optimise and back up database | 4.1 Configure the database for backup and recovery operations 4.2 Create and manage database backups 4.3 Restore and perform database recovery 4.4 Tune and perform database optimisation |
5. Document the database | 5.1 Document the maintenance and tuning work performed on the database 5.2 Document the users added to system |
Evidence of the ability to:
install and configure database software, according to requirements
manage database files, integrity, users and security
create backup and restore databases
monitor database performance
document the database work, and database users added.
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 database design
summarise the features of desktop operating systems
explain the principles of relational databases
describe the functions of computer hardware and components
explain computer networking and components
explain uses of structured query language (SQL).
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 programming and software development industry, and include access to:
the database-management system software
specific requirements, including client and functionality requirements
naming standard.
Assessors must satisfy NVR/AQTF assessor requirements.