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)
COSC5331C	City Campus	TAFE	650T TAFE Business	Face-to-Face or Workplace	Term2 2009, Term1 2011, Term2 2011

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.

Pre-requisite Courses and Assumed Knowledge and Capabilities

None

National Competency Codes and Titles

National Element Code & Title:	ICAA5139A 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

Assessment tasks will consist of a portfolio of in-class exercises, a project with associated documentation, and a combined theory and practical test.

You will be provided with feedback throughout the course to check your progress.

You are advised that you are likely to be asked to personally demonstrate your assessment work to your teacher to ensure that the relevant competency standards are being met.