Unit of Competency Mapping – Information for Teachers/Assessors – Information for Learners

ICTDBS403 Mapping and Delivery Guide
Create basic databases

Version 1.0
Issue Date: April 2024


Qualification -
Unit of Competency ICTDBS403 - Create basic databases
Description
Employability Skills
Learning Outcomes and Application This unit describes the skills and knowledge required to design, develop and test a database in order to meet a specification.It applies to individuals who may be either database, or web designers, required to create a simple database to store information for an online application, using a simple entity relational database.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.

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:

equipment, materials and industry software packages

database and database management system

the internet and web browser software

software for creating entity-relationship (ER) diagrams

software development environment

the server.

Assessors must satisfy NVR/AQTF assessor requirements.
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: Analyse the requirements for the database
  • Determine the information that the database is required to hold
  • Develop a written requirement report for the functionality of the database
  • Complete the documentation, and submit it to the appropriate person for approval
       
Element: Use data modelling to design the database to suit requirements
  • Design an entity-relationship (ER) diagram to model the relationships between the entities and the attributes that the database will hold
  • Develop primary and foreign keys to link the entities
  • Develop a data dictionary
  • Complete the documentation, and submit it to the appropriate person for approval
       
Element: Create a database on a web or database server
  • Use the appropriate language on a web or database server to create one or more databases
  • Use the appropriate language on a web or database server to create tables
  • Populate the database fields
       
Element: Test the database and debug
  • Test the database on the web or database server
  • Ensure that the information represented matches the requirements
       


Evidence Required

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. Analyse the requirements for the database

1.1 Determine the information that the database is required to hold

1.2 Develop a written requirement report for the functionality of the database

1.3 Complete the documentation, and submit it to the appropriate person for approval

2. Use data modelling to design the database to suit requirements

2.1 Design an entity-relationship (ER) diagram to model the relationships between the entities and the attributes that the database will hold

2.2 Develop primary and foreign keys to link the entities

2.3 Develop a data dictionary

2.4 Complete the documentation, and submit it to the appropriate person for approval

3. Create a database on a web or database server

3.1 Use the appropriate language on a web or database server to create one or more databases

3.2 Use the appropriate language on a web or database server to create tables

3.3 Populate the database fields

4. Test the database and debug

4.1 Test the database on the web or database server

4.2 Ensure that the information represented matches the requirements

Evidence of the ability to:

research client requirements for a database solution

design a database that meets client requirements

create a database on a web hosting service or server to meet client requirements by a due date

test and debug 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:

outline the principles of open platforms, including browsers and databases

list the processes associated with the creation of entities, attributes, and in populating fields, using both software solutions and script- based input

describe data-modelling techniques to design a database

outline the steps in database design, modelling and implementation

describe the internet operation related to web servers and clients

identify the naming conventions appropriate to database design

identify security restrictions on servers, incorporating some theoretical concepts

describe best practice communication, and accessibility, for audiences with special needs.

Submission Requirements

List each assessment task's title, type (eg project, observation/demonstration, essay, assignment, checklist) and due date here

Assessment task 1: [title]      Due date:

(add new lines for each of the assessment tasks)

Assessment Tasks

Copy and paste from the following data to produce each assessment task. Write these in plain English and spell out how, when and where the task is to be carried out, under what conditions, and what resources are needed. Include guidelines about how well the candidate has to perform a task for it to be judged satisfactory.

ELEMENT

PERFORMANCE CRITERIA

Elements describe the essential outcomes.

Performance criteria describe the performance needed to demonstrate achievement of the element.

1. Analyse the requirements for the database

1.1 Determine the information that the database is required to hold

1.2 Develop a written requirement report for the functionality of the database

1.3 Complete the documentation, and submit it to the appropriate person for approval

2. Use data modelling to design the database to suit requirements

2.1 Design an entity-relationship (ER) diagram to model the relationships between the entities and the attributes that the database will hold

2.2 Develop primary and foreign keys to link the entities

2.3 Develop a data dictionary

2.4 Complete the documentation, and submit it to the appropriate person for approval

3. Create a database on a web or database server

3.1 Use the appropriate language on a web or database server to create one or more databases

3.2 Use the appropriate language on a web or database server to create tables

3.3 Populate the database fields

4. Test the database and debug

4.1 Test the database on the web or database server

4.2 Ensure that the information represented matches the requirements

Copy and paste from the following performance criteria to create an observation checklist for each task. When you have finished writing your assessment tool every one of these must have been addressed, preferably several times in a variety of contexts. To ensure this occurs download the assessment matrix for the unit; enter each assessment task as a column header and place check marks against each performance criteria that task addresses.

Observation Checklist

Tasks to be observed according to workplace/college/TAFE policy and procedures, relevant legislation and Codes of Practice Yes No Comments/feedback
Determine the information that the database is required to hold 
Develop a written requirement report for the functionality of the database 
Complete the documentation, and submit it to the appropriate person for approval 
Design an entity-relationship (ER) diagram to model the relationships between the entities and the attributes that the database will hold 
Develop primary and foreign keys to link the entities 
Develop a data dictionary 
Complete the documentation, and submit it to the appropriate person for approval 
Use the appropriate language on a web or database server to create one or more databases 
Use the appropriate language on a web or database server to create tables 
Populate the database fields 
Test the database on the web or database server 
Ensure that the information represented matches the requirements 

Forms

Assessment Cover Sheet

ICTDBS403 - Create basic databases
Assessment task 1: [title]

Student name:

Student ID:

I declare that the assessment tasks submitted for this unit are my own work.

Student signature:

Result: Competent Not yet competent

Feedback to student

 

 

 

 

 

 

 

 

Assessor name:

Signature:

Date:

Assessment Record Sheet

ICTDBS403 - Create basic databases

Student name:

Student ID:

Assessment task 1: [title] Result: Competent Not yet competent

(add lines for each task)

Feedback to student:

 

 

 

 

 

 

 

 

Overall assessment result: Competent Not yet competent

Assessor name:

Signature:

Date:

Student signature:

Date: