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.
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.