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. Confirm the database design | 1.1 Review the database design documentation, including data structures, queries, reports and user interface 1.2 Compare the database access and security feature design with the organisational security plan 1.3 Document inconsistencies in the database and security design |
2. Create a prototype | 2.1 Develop a prototype according to the database design 2.2 Populate database tables with suitable data, including current business data 2.3 Write conversion programs to import data from existing systems 2.4 Develop test data to assess database features 2.5 Assess functionality of the prototype with the client, including identifying errors in the program code, and modifying screens, and reports 2.6 Incorporate feedback from the client into the prototype 2.7 Obtain client sign-off for the prototype |
3. Test the database | 3.1 Develop an implementation plan for the database 3.2 Install database management system software on the network 3.3 Populate the database tables with business data 3.4 Implement security and access controls 3.5 Test database output and security controls, and record results |
4. Evaluate the database | 4.1 Review the database with the client for final approval 4.2 Complete database documentation 4.3 Identify and document user training requirements 4.4 Seek and secure client acceptance of the database |
Evidence of the ability to:
identify client data management and security requirements
produce a prototype data base
populate and perform tests
discuss results with client for approval
implement the data base with the client.
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 data base design including :
database management system (DBMS) fundamentals particularly during the design phase
describe the functions and features of a database
describe logical data modelling
outline object-model design concepts related to:
developing data structures
development of a prototype
queries
screens
reports
explain the physical design concepts in relation to a prototype
recognise and describe run-time facilities related to implementing a live database and operation of a prototype
describe and apply structured query programming 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 database field of work, and include access to:
industry software packages
business requirements and strategy
database design documentation
database software
database programming language.
Assessors must satisfy NVR/AQTF assessor requirements.