Course Title: Design a database

Part A: Course Overview

Program: C5194

Course Title: Design a database

Portfolio: BUS

Nominal Hours: 50.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)

COSC6078C

City Campus

TAFE

650T TAFE Business

Face-to-Face or Internet or Workplace

Term2 2012

Course Contact: Chandra Nannegari

Course Contact Phone: +61 3 9925 1657

Course Contact Email: chandra.nannegari@rmit.edu.au


Course Description

This unit defines the competency required to establish client needs and technical requirements and to design a database that meets those requirements.

If you are undertaking this course in Melbourne from semester 2, 2012 onward your class will be held in a device-equipped teaching space. Each student group will have access to a laptop. It is however recommended that you have access to a mobile computing device to allow greater flexibility in terms of where you can work on campus both in and outside class times.


Pre-requisite Courses and Assumed Knowledge and Capabilities

None



National Competency Codes and Titles

National Element Code & Title:

ICAA5139B Design a database

Elements:

1. Determine database requirements

2. Develop logical data model

3. Design data structures

4. Design queries, screens and reports

5. Design access and security systems

6. Confirm database design


Learning Outcomes


Overview of Assessment

Students must demonstrate an understanding of all elements of competency to be deemed competent.

A range of assessment methods are used to assess practical skills and knowledge, for example:

• direct questioning combined with review of portfolios of evidence and third party workplace reports of on-the-job performance by the candidate
• review of authenticated documents from the workplace or training environment
• demonstration of techniques