NTISthis.com

Evidence Guide: ICTDBS403 - Create basic databases

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

 

ICTDBS403 - Create basic databases

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

Analyse the requirements for the database

  1. Determine the information that the database is required to hold
  2. Develop a written requirement report for the functionality of the database
  3. Complete the documentation, and submit it to the appropriate person for approval
Determine the information that the database is required to hold

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Develop a written requirement report for the functionality of the database

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

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

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Use data modelling to design the database to suit requirements

  1. Design an entity-relationship (ER) diagram to model the relationships between the entities and the attributes that the database will hold
  2. Develop primary and foreign keys to link the entities
  3. Develop a data dictionary
  4. 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

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Develop primary and foreign keys to link the entities

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Develop a data dictionary

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

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

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Create a database on a web or database server

  1. Use the appropriate language on a web or database server to create one or more databases
  2. Use the appropriate language on a web or database server to create tables
  3. Populate the database fields
Use the appropriate language on a web or database server to create one or more databases

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

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

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Populate the database fields

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Test the database and debug

  1. Test the database on the web or database server
  2. Ensure that the information represented matches the requirements
Test the database on the web or database server

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Ensure that the information represented matches the requirements

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

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