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. Undertake database management system modelling | 1.1 Review the database prototype as appropriate, to determine the acceptance criteria and performance standards 1.2 Load the test data according to the technical sequence detailed in the relevant documentation 1.3 Generate a test schedule for the database, of tasks to be performed and the results expected |
2. Monitor database performance | 2.1 Evaluate database performance against the acceptance criteria and performance standards 2.2 Identify discrepancies in the results, when the expected outcomes do not meet the acceptance criteria 2.3 Identify areas needing enhancement, and document the changes to be made 2.4 Modify the database according to project standards 2.5 Repeat performance testing until the expected results are achieved |
3. Seek client feedback and sign-off | 3.1 Present test results in a document, and provide to the client for feedback 3.2 Incorporate client change requests as appropriate 3.3 Obtain client sign-off to the monitoring process |
Evidence of the ability to:
identify technical considerations affecting the implementation of a database
analyse and monitor performance issues during the implementation of a database
modify a database to meet project and client performance requirements.
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:
describe the client business domain
list current industry-accepted hardware and software products
describe requirements of basic database design
identify required database performance standards
outline quality assurance practices
outline testing and benchmarking processes
list three or more current principles of databases.
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
the database management system (DBMS)
the target database prototype
testing and benchmarking software.
Assessors must satisfy NVR/AQTF assessor requirements.