Elements and Performance Criteria
- 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
- 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
- Develop queries, forms and reports
- 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