Google Links

Follow the links below to find material targeted to the unit's elements, performance criteria, required skills and knowledge

Elements and Performance Criteria

1. Design database
   • Review organisational and task requirements to confirm scope and functionality of database design, including data redundancy
   • Develop a logical data model to identify and classify data into types
   • Select appropriate software according to organisational and task requirements and required scope and functionality of database
   • Confirm database design with appropriate person
2. Develop database
   • Set field attributes according to data type and link databases by a common field in accordance with software procedures
   • Identify primary key to uniquely identify data
   • Identify foreign keys to establish associations between data
   • Use software functions and formulae to meet organisational and task requirements
   • Create password and access system according to organisational and task requirements
3. Develop queries, forms and reports
   • Develop queries as required by organisational and task requirements
   • Develop input screens or forms to access required data
   • Develop reports according to organisational and task requirements
4. Test and finalise database
   • Populate database with sample dataset for testing
   • Assess and document effectiveness of data relationships, query forms and reports
   • Address any errors in database design
   • Name and store database in accordance with organisational requirements and exit the application without data loss or damage
   • Confirm database readiness with appropriate person