University of Technology, Sydney

Staff directory | Webmail | Maps | Newsroom | What's on

31253 Database Programming

Warning: The information on this page is indicative. The subject outline for a particular session, location and mode of offering is the authoritative source of all information about the subject for that offering. Required texts, recommended texts and references in particular are likely to change. Students will be provided with a subject outline once they enrol in the subject.

Subject handbook information prior to 2018 is available in the Archives.

UTS: Information Technology: Software
Credit points: 6 cp

Subject level:

Undergraduate

Result type: Grade and marks

Requisite(s): 31271 Database Fundamentals OR 31061 Database Principles OR 31474 Database Fundamentals OR 31487 Database Management Systems
Anti-requisite(s): 31099 Distributed Database Programming and Administration

Recommended studies:

It is assumed that students are familiar with basic database concepts; familiarity with the SQL language is mandatory and previous experience with at least one higher-level programming language is required.

Description

This subject teaches students how to design, develop and evaluate database programming and administration solutions to meet pre-defined quality characteristics of functionality (suitability, security), usability (operability), efficiency (time behaviour, resource utilisation), and maintainability (changeability, testability). Database programming and administration solutions are implemented using Oracle 11G, SQL*Plus and PL/SQL. Concepts, theories and technologies underlying the methods and techniques are introduced and explained as required. Students apply all that they have learnt to develop a small application to solve a database problem.

Subject learning objectives (SLOs)

Upon successful completion of this subject students should be able to:

1. Be able to describe the benefits of Database Programming
2. Understand programming constructs available in PL/SQL.
3. Understand how triggers, stored procedures and stored functions and database packages operate.
4. Understand the current development methodology in modern database systems
5. Describe the use of supplied packages in the Oracle database
6. Have a basic understanding of the roles and responsibilities of a database administrator

Course intended learning outcomes (CILOs)

This subject also contributes specifically to the development of the following Course Intended Learning Outcomes (CILOs):

  • Needs, context and systems - Engineering and IT take place within the larger context of society and the environment, which encompasses social, economic and sustainability needs. (A.0)
  • Identify, interpret and analyse stakeholder needs. (A.1)
  • Apply systems thinking to understand complex system behaviour including interactions between components and with other systems (social, cultural, legislative, environmental, business etc.) (A.5)
  • Identify and apply relevant problem solving methodologies (B.1)
  • Apply decision-making methodologies to evaluate solutions for efficiency, effectiveness and sustainability (B.4)

Teaching and learning strategies

Each week there will be a 2 hour lecture and a 1 hour tutorial/lab. Lab sessions will be used to support the lectures with illustrative examples and exercise.

Content (topics)

  1. Introduction to Database Programming, revision of SQL and an introduction to SQL*Plus, iSQL*Plus and the development tool SQL Developer
  2. PL/SQL language fundamentals, variables and built in functions
  3. Database procedures, functions, triggers and packages
  4. Error and exception handling
  5. File input/output from the database
  6. Dynamic SQL.
  7. Introduction and awareness of performance tuning
  8. Database administration

Assessment

Assessment task 1: Assignment 1

Objective(s):

This assessment task addresses the following subject learning objectives (SLOs):

1, 2, 3, 4 and 5

This assessment task contributes to the development of the following course intended learning outcomes (CILOs):

A.0, A.1, B.1 and B.4

Type: Exercises
Groupwork: Individual
Weight: 50%
Criteria linkages:
Criteria Weight (%) SLOs CILOs
Correctness of interpretation of data and subsequent solution 30 1 A.1
Development of a robust solution in a programming environement 40 2 B.1
Appropriate use of existing database packages 10 3 B.4
Appropriate use of database functionality 10 4 A.0
Understanding of Oracle Database syntax 10 5 A.1
SLOs: subject learning objectives
CILOs: course intended learning outcomes

Assessment task 2: Final Examination

Objective(s):

This assessment task addresses the following subject learning objectives (SLOs):

1, 2, 3, 4, 5 and 6

This assessment task contributes to the development of the following course intended learning outcomes (CILOs):

A.0, A.1, A.5, B.1 and B.4

Type: Examination
Groupwork: Individual
Weight: 50%
Criteria linkages:
Criteria Weight (%) SLOs CILOs
Correctness of interpretation of data and subsequent solution 15 1 A.1
Development of a robust solution in a programming environment 25 2 B.1
Appropriate use of existing database packages 15 3 B.4
Appropriate use of database functionality 20 4 A.0
Understanding of Oracle Database syntax 15 5 A.1
Understand database administration requirements 10 6 A.5
SLOs: subject learning objectives
CILOs: course intended learning outcomes

Minimum requirements

Students must attain 50% or greater of the total exam score to qualify for a pass in this subject. Accordingly, exam scores below 50% will result in a fail with a final grade of X.

Required texts

Prescribed Text 978-0-596-51446-4
Oracle PL/SQL Programming (5th Edition) ISBN 978-0-596-51446-4
by Steven Feuerstein with Bill Pribyl
Published by O'Reilly and Associates Inc.

References

Other References

  1. OTN - Oracles On Line Help System
  2. Oracle PL/SQL by Example (Third Edition) ISBN 0-13-117261-1
By Benjamin Rosenzweig and Elena Silvestrova Published by Prentice Hall