Course Title: Create basic databases

Part A: Course Overview

Program: C4378 Certificate IV in Information Technology Networking

Course Title: Create basic databases

Portfolio: Vocational Education

Nominal Hours: 40

Regardless of the mode of delivery, represent a guide to the relative teaching time and student effort required to successfully achieve a particular competency/module. This may include not only scheduled classes or workplace visits but also the amount of effort required to undertake, evaluate and complete all assessment requirements, including any non-classroom activities.

Terms

Course Code

Campus

Career

School

Learning Mode

Teaching Period(s)

ISYS5693C

City Campus

TAFE

174T School of VE Engineering, Health & Science

Face-to-Face or Internet

Term2 2017,
Term1 2018,
Term2 2018,
Term1 2019,
Term2 2019

Course Contact: Trevor Stone

Course Contact Phone: +61 3 9925 4545

Course Contact Email: trevor.stone@rmit.edu.au



Course Description

This unit defines the competency required to create basic databases as prescribed in the ICT Information and Communications Technology Training Package Version 1.0.

When you undertake this unit you will develop the ability 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 entry relational database.

Pre-requisite Courses and Assumed Knowledge and Capabilities

There are no pre-requisites for this course.



National Competency Codes and Titles

National Element Code & Title:

ICTDBS403 Create basic databases

Elements:

1. Analyse the requirements for the database

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

3. Create a database on a web or database server

4. Test the database and debug


Learning Outcomes

On completion of this competency, you will be able to do the following:

  • 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 severs, incorporating some theoretical concepts
  • describe best practice communication, and accessibility, for audiences with special needs.

Also refer to the elements of this course.


Overview of Assessment

Assessment in this course is competency based.  You must  be deemed competent in all elements to successfully complete the course.

Assessment in this course will involve the following:

Tasks

Assessment 1: Online quizzes

Assessment 2: Practical tasks

Assessment 3: Assignments

These tasks assesses the following Course Learning Outcomes (CLOs):

Assessment Mapping Matrix

Elements/

Performance Criteria Covered

Assessment 1  Assessment 2  Assessment 3 
 1.1    X  X
 1.2    X  X
 1.3    X  X
 2.1  X  X  X
 2.2  X  X  X
 2.3  X  X  X
 2.4  X  X  X
 3.1  X  X  X
 3.2  X  X X
 3.3 X X X
 4.1   X X
 4.2   X X