Course Title: Design databases

Part A: Course Overview

Program: C4223

Course Title: Design databases

Portfolio: BUS

Nominal Hours: 60.0

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.

Course Code

Campus

Career

School

Learning Mode

Teaching Period(s)

COSC5944C

City Campus

TAFE

650T TAFE Business

Face-to-Face or Workplace


Course Contact: Sylvia Baroutis

Course Contact Phone: +61 3 9925 5469

Course Contact Email: sylvia.baroutis@rmit.edu.au


Course Description

This unit describes the performance outcomes, skills and knowledge required to design and develop a database (including queries, forms and reports) to meet a defined need using existing data.

No licensing, legislative, regulatory or certification requirements apply to this unit at the time of endorsement.

This unit contains employability skills.

This unit applies to individuals employed in a range of work environments who create databases to store and retrieve data using commercially available database software. They may provide administrative support within an enterprise, or may be independently responsible for designing databases relevant to their own work roles.


Pre-requisite Courses and Assumed Knowledge and Capabilities

There are no pre-requisites or co-requisites required for this competency.



National Competency Codes and Titles

National Element Code & Title:

BSBITA401A Design databases

Elements:

1. Design database

2. Develop database

3. Develop queries, forms and reports

4. Test and finalise database


Learning Outcomes


Overview of Assessment

Students must demonstrate an understanding of all elements of a particular competency to be deemed competent.  Assessment methods have been designed to measure achievement of each competency in a flexible manner. Assessment will incorporate a variety of methods including: demonstration of techniques under supervised conditions and a review of a database designed, developed and tested in class.  Due to the complex nature of this competency, students may be required to demonstrate competency in any element more than once.  Students are advised that they are likely to be asked to personally demonstrate their assessment work to their teacher to ensure that the relevant competency standards are being met.  In addition, formative feedback will be provided to students throughout the course.