ITC214 Database Implementation (8)
CSU Discipline Area: Computing (COMPU)
Duration: One session
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 Locations
No offerings have been identified for this subject in 2013.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.
Assumed Knowledge:
Enrolment restrictions:
Not available to students who have completed ITC324
Objectives:
Upon 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.
Syllabus:
The 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.
The information contained in the 2013 CSU Handbook was accurate at the date of publication: 24 April 2013. The University reserves the right to vary the information at any time without notice.