This is archived information!
Search current Handbook for current unit information.
Advanced Database Applications Development - ITEC870
This unit will focus on the activities, issues and techniques involved in developing database applications. This subject will cover three major phases of software development process for database applications: analysis, design and implementation. The analysis and design topics will concentrate on various methods and techniques of software requirements elicitation, specifications and management.
Students will learn how to carefully analyse the business needs and efficiently perform various modelling tasks to develop appropriate business and system models. Topics covered will also include analysis and design technologies, conceptual, logical and physical data modelling using Unified Modelling Language (UML). Also included are notation conventions and normalisation.
The subject will introduce the students to appropriate Modelling tools, e.g., PowerDesigner for various modelling tasks. The subject will also provide a detailed coverage of theoretical concepts underpinning the relational database models and SQL99 standards, and how various vendors have implemented them. Other advanced database concepts like transaction management, concurrency control, locking techniques, deadlocks, indexing techniques, query optimisation, performance monitoring and tuning, security etc. will also be covered in sufficient detail.
For implementation, students will be introduced to various features of the Oracle10g database server, Oracle's implementation of SQL99 standards and the Oracle propriety procedural extension to SQL: PL/SQL. This subject also aims at providing an advanced level of knowledge and skill to design and implement server side database programming using stored procedures, triggers and packages on Oracle10g database server.
| Credit Points: | 4 |
| When Offered: | E2 - Evening; Offered in Session 2, North Ryde |
| Staff Contact(s): | Computing staff |
| Prerequisites: | |
| Corequisites: | |
| NCCW(s): | |
| Unit Designation(s): | |
| Assessed As: | Graded |
| Offered By: | Department of Computing Faculty of Science |
Timetable Information
For unit timetable information please visit the Timetables@Macquarie Website