No offerings have been identified for this subject in 2015
ITC214 Database Implementation (8)
Abstract| This subject is about implementing a relational database system for small business applications. Students will create the tables, forms, reports, queries, macros and coding necessary to complete a fully operational system. The lectures and notes will support this by covering modelling, design, testing and implementation issues. This is mainly a hands-on subject. |
|
|
+ Subject Availability Modes and Location
Continuing students should consult the SAL for current offering details prior to contacting their course coordinator: ITC214
Where differences exist between the handbook and the SAL, the SAL should be taken as containing the correct subject offering details.
|
|
Subject information| Duration | Grading System | School: |
|---|
| One session | HD/FL | School of Computing and Mathematics |
|
|
Enrolment restrictions| Not available to students who have completed ITC324 |
|
|
| Incompatible subject(s) |
|---|
| ITC324 |
|
Learning OutcomesUpon successful completion of this subject, students should:
* be able to implement relational database applications using both non-procedural and procedural techniques;
* be able to apply good design principles to produce a user-friendly system;
* be able to implement database efficiency measures;
* be able to apply good testing procedures to ensure system quality;
* be able to discuss implementation issues for a particular DBMS;
* be able to conduct prototyping. |
|
|
SyllabusThe subject will cover the following topics:
Module 1 Modelling
. Modelling and normalisation revision.
. Efficiency issues and Denormalisation.
Module 2 Design
. Data input, defaults, user friendliness, data deletion.
. Reports & Screens, Menus and Navigation.
. Test data, User Views, Security, Indexes.
Module 3 - Implementation
. Building applications with non-procedural techniques.
. Building applications with procedural techniques including embedded SQL, interfacing to GUI, transaction management and modifying the database environment.
. Implementation challenges.
Module 4 Associated Issues
. Intergration with other systems.
. Prototyping.
. Security. |
|
|
Back
The information contained in the 2015 CSU Handbook was accurate at the date of publication: 01 October 2015. The University reserves the right to vary the information at any time without notice.
