NTISthis.com

Evidence Guide: ICTDBS412 - Build a database

Student: __________________________________________________

Signature: _________________________________________________

Tips for gathering evidence to demonstrate your skills

The important thing to remember when gathering evidence is that the more evidence the better - that is, the more evidence you gather to demonstrate your skills, the more confident an assessor can be that you have learned the skills not just at one point in time, but are continuing to apply and develop those skills (as opposed to just learning for the test!). Furthermore, one piece of evidence that you collect will not usualy demonstrate all the required criteria for a unit of competency, whereas multiple overlapping pieces of evidence will usually do the trick!

From the Wiki University

 

ICTDBS412 - Build a database

What evidence can you provide to prove your understanding of each of the following citeria?

Confirm the database design

  1. Review the database design documentation, including data structures, queries, reports and user interface
  2. Compare the database access and security feature design with the organisational security plan
  3. Document inconsistencies in the database and security design
Review the database design documentation, including data structures, queries, reports and user interface

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Compare the database access and security feature design with the organisational security plan

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Document inconsistencies in the database and security design

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Create a prototype

  1. Develop a prototype according to the database design
  2. Populate database tables with suitable data, including current business data
  3. Write conversion programs to import data from existing systems
  4. Develop test data to assess database features
  5. Assess functionality of the prototype with the client, including identifying errors in the program code, and modifying screens, and reports
  6. Incorporate feedback from the client into the prototype
  7. Obtain client sign-off for the prototype
Develop a prototype according to the database design

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Populate database tables with suitable data, including current business data

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Write conversion programs to import data from existing systems

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Develop test data to assess database features

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Assess functionality of the prototype with the client, including identifying errors in the program code, and modifying screens, and reports

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Incorporate feedback from the client into the prototype

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Obtain client sign-off for the prototype

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Test the database

  1. Develop an implementation plan for the database
  2. Install database management system software on the network
  3. Populate the database tables with business data
  4. Implement security and access controls
  5. Test database output and security controls, and record results
Develop an implementation plan for the database

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Install database management system software on the network

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Populate the database tables with business data

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Implement security and access controls

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Test database output and security controls, and record results

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Evaluate the database

  1. Review the database with the client for final approval
  2. Complete database documentation
  3. Identify and document user training requirements
  4. Seek and secure client acceptance of the database
Review the database with the client for final approval

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Complete database documentation

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Identify and document user training requirements

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Seek and secure client acceptance of the database

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Assessed

Teacher: ___________________________________ Date: _________

Signature: ________________________________________________

Comments:

 

 

 

 

 

 

 

 

Instructions to Assessors

Evidence Guide

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

Required Skills and Knowledge

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).