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