Unit of Competency Mapping – Information for Teachers/Assessors – Information for Learners
ICTDBS502 Mapping and Delivery Guide
Design a database
Version 1.0
Issue Date: June 2024
Qualification | - |
Unit of Competency | ICTDBS502 - Design a database |
---|---|---|---|
Description | |||
Employability Skills | |||
Learning Outcomes and Application | This unit describes the skills and knowledge required to establish client needs and technical requirements and to design a database that meets those requirements.It applies to individuals employed as database administrators and designers who are required to design databases.No licensing, legislative or certification requirements apply to this unit at the time of publication. | ||
Duration and Setting | X weeks, nominally xx hours, delivered in a classroom/online/blended learning setting. |
||
Prerequisites/co-requisites | |||
Competency Field |
Development and validation strategy and guide for assessors and learners | Student Learning Resources | Handouts Activities |
Slides PPT |
Assessment 1 | Assessment 2 | Assessment 3 | Assessment 4 | |
---|---|---|---|---|---|---|---|---|
Elements of Competency | Performance Criteria | |||||||
Element: Determine database requirements |
| |||||||
Element: Develop a logical data model |
| |||||||
Element: Design the data structures |
| |||||||
Element: Design queries, screens and reports |
| |||||||
Element: Design access and security systems |
| |||||||
Element: Confirm the database design |
|