Course Title: Build a database
Part A: Course Overview
Program: C5148
Course Title: Build a database
Portfolio: BUS
Nominal Hours: 30.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) |
COSC5759C |
City Campus |
TAFE |
650T TAFE Business |
Face-to-Face or Internet |
Course Contact: Chandra Nannegari
Course Contact Phone: 9925 1657
Course Contact Email: chandra.nannegari@rmit.edu.au
Course Description
This course will provide students with a basic knowledge of choosing the appropriate RDBMS to implement a conceptual model.
Initially students will develop a prototype and populate it with data. The course will also provide skills in creating required screens, reports and queries, as required by the database design.
Firstly the implementation plan will be designed and the data conversion process will be carried out. Next the post implementation review will be conducted, and the system documentation will be completed.
Further, knowledge of security systems is provided to prevent unauthorised access to database application.
A programming language in a database environment may be used to produce simple programs in order to access or modify the tables.
Pre-requisite Courses and Assumed Knowledge and Capabilities
Model Preferred Solutions with national code - ICAITAD046A and RMIT course code - COSC 5731C is a pre-requisite. This course has Nil Co-Requisites.
National Competency Codes and Titles
National Element Code & Title: |
ICAITB170A Build a database |
Elements: |
Access and security systems are developed |
Data structures, queries, screens and reports are developed |
|
Database design is confirmed |
|
Database prototype is created and tested |
|
The live system is implemented |
Learning Outcomes
See details under elements of competency.
Overview of Assessment
Assessment may incorporate a variety of methods including technical requirements documentation, homework and in class exercises, written tests, practical problem solving exercises and practical tests. Students are advised that they maybe be asked to personally demonstrate their assessment work to their teacher to ensure that the relevant competency standards are being met.