Download PDF

Course Outline

ICT320 Database Programming

Course Coordinator:Andrew Lang (alang1@usc.edu.au) School:School of Science, Technology and Engineering

2025Trimester 3

UniSC Adelaide

 Blended learning Most of your course is on campus but you may be able to do some components of this course online.

Please go to unisc.edu.au for up to date information on the
teaching sessions and campuses where this course is usually offered.

What is this course about?

Description

This course provides you with advanced database concepts including advanced SQL and industrial database application domains. The course expands on topics in ICT211, adds advanced SQL concepts and develops practical database programming skills. It begins with a review of the database environment, adding indexes and optimisation. The second part of the course focuses on applying the skills to real world applications including integrating databases with applications, big data, and graphing and geo-spatial databases.

How will this course be delivered?

Activity Hours Beginning Week Frequency
Blended learning
Learning materials – Pre-recorded concept videos and associated activity 1hr Week 1 12 times
Tutorial/Workshop 1 – In-class tutorial 2hrs Week 1 12 times

Course Topics

Review – Data models and ER modeling

SQL review

Advanced SQL – procedures, functions, triggers, views

Advanced SQL – performance tuning and query optimisation

Distributed database management systems

Introduction to Big data and NoSQL

Key-value databases – Redis

Graphing databases – Neo4j

Document databases – MongoDB

What level is this course?

300 Level (Graduate)

Demonstrating coherence and breadth or depth of knowledge and skills. Independent application of knowledge and skills in unfamiliar contexts. Meeting professional requirements and AQF descriptors for the degree. May require pre-requisites where discipline specific introductory or developing knowledge or skills is necessary. Normally undertaken in the third or fourth full-time study year of an undergraduate program.

What is the unit value of this course?

12 units

How does this course contribute to my learning?

Course Learning Outcomes On successful completion of this course, you should be able to... Graduate Qualities Completing these tasks successfully will contribute to you becoming...
1 Creation of systems. Creative and critical thinker
2 Apply initiative to solving problems competently in the discipline. Creative and critical thinker
Empowered
3 Apply written communication skills to specific problems. Knowledgeable
Engaged
4 Apply discipline specific knowledge and skills to problems. Knowledgeable
Creative and critical thinker
5 Understand sustainability issues within the discipline. Sustainability-focussed

Am I eligible to enrol in this course?

Refer to the UniSC Glossary of terms for definitions of “pre-requisites, co-requisites and anti-requisites”.

Pre-requisites

ICT211 and ICT112

Co-requisites

Not applicable

Anti-requisites

Not applicable

Specific assumed prior knowledge and skills (where applicable)

Not applicable

Microcredential Information

Not applicable

How am I going to be assessed?

Grading Scale

Standard Grading (GRD)

High Distinction (HD), Distinction (DN), Credit (CR), Pass (PS), Fail (FL).

Details of early feedback on progress

Early feedback will be provided in the weekly workshops.

Assessment tasks

Delivery mode Task No. Assessment Product Individual or Group Weighting % What is the duration / length? When should I submit? Where should I submit it?
All 1 Examination - not Centrally Scheduled Individual 10% 
60 minutes
 Week 5 Online Test (Quiz)
All 2 Artefact - Technical and Scientific, and Written Piece Individual 40% 
1000 words
 Week 9 Online Assignment Submission with plagiarism check
All 3 Artefact - Technical and Scientific, and Written Piece Individual 50% 
1500-2000 words
 Week 12 Online Assignment Submission with plagiarism check
All - Assessment Task 1:Database Exam
Goal: 
Demonstrate understanding of databases
Product: Examination - not Centrally Scheduled
Authorship Statement:
Format: 
An examination will be held in week 5. This is an individual assessment
Criteria:
No. Learning Outcome assessed
1 
Demonstrated understanding of databasesrelevant to the weekly content covered.
 2 4
Generic Skills: 
Problem solving, Applying technologies
All - Assessment Task 2:Database Programming
Goal: 
Application of database programming skills to solve complex data management challenges, ensuring efficient retrieval of information for a given case/scenario.
Product: Artefact - Technical and Scientific, and Written Piece
Authorship Statement:
Format: 
Written report and database code/file.
Criteria:
No. Learning Outcome assessed
1 
Demonstrate knowledge and application of database skills.
 2 4
Generic Skills: 
Communication, Problem solving, Applying technologies
All - Assessment Task 3:Written report and database code/file.
Goal: 
Insightful analysis of the given problem 
Design completeness and accuracy 
Correctness and completeness of the implementation of code
Effective written communication and report presentation
Product: Artefact - Technical and Scientific, and Written Piece
Authorship Statement:
Format: 
Written report and database code/file.
Criteria:
No. Learning Outcome assessed
1 
Critically analyse data requirements and construct an optimised database schema that exemplifies data integrity and efficiency.
 1 5
2 
Evaluate data retrieval needs and implement advanced queries
 2 4
3 
Apply written communication skills through the use of concise documentation and coherent report writing to address the given problem
 3
Generic Skills: 
Communication, Problem solving, Applying technologies, Information literacy

Directed study hours

A 12-unit course will have total of 150 learning hours which will include directed study hours (including online if required), self-directed learning and completion of assessable tasks. Student workload is calculated at 12.5 learning hours per one unit.

What resources do I need to undertake this course?

Please note: Course information, including specific information of recommended readings, learning activities, resources, weekly readings, etc. are available on the course Canvas site– Please log in as soon as possible.

Prescribed text(s) or course reader

You need regular access to the resource(s) below. Many texts are available as ebooks through the Library at no additional cost.

Required? Author Year Title Edition Publisher
Required Carlos Coronel,Steven Morris 2018 Database Systems: Design, Implementation, & Management n/a Cengage Learning

Specific requirements

Not applicable

How are risks managed in this course?

Health and safety risks for this course have been assessed as low. It is your responsibility to review course material, search online, discuss with lecturers and peers and understand the health and safety risks associated with your specific course of study and to familiarise yourself with the University’s general health and safety principles by reviewing the online induction training for students, and following the instructions of the University staff.

What administrative information is relevant to this course?

Assessment: Academic Integrity

Academic integrity is the ethical standard of university participation. It ensures that students graduate as a result of proving they are competent in their discipline. This is integral in maintaining the value of academic qualifications. Each industry has expectations and standards of the skills and knowledge within that discipline and these are reflected in assessment.

Academic integrity means that you do not engage in any activity that is considered to be academic fraud; including plagiarism, collusion or outsourcing any part of any assessment item to any other person. You are expected to be honest and ethical by completing all work yourself and indicating in your work which ideas and information were developed by you and which were taken from others. You cannot provide your assessment work to others. You are also expected to provide evidence of wide and critical reading, usually by using appropriate academic references.

In order to minimise incidents of academic fraud, this course may require that some of its assessment tasks, when submitted to Canvas, are electronically checked through Turnitin. This software allows for text comparisons to be made between your submitted assessment item and all other work to which Turnitin has access.

Assessment: Additional Requirements

Eligibility for Supplementary Assessment

Your eligibility for supplementary assessment in a course is dependent of the following conditions applying:
(a) The final mark is in the percentage range 47% to 49.4%; and
(b) The course is graded using the Standard Grading scale

Assessment: Submission penalties

Late submissions may be penalised up to and including the following maximum percentage of the assessment task’s identified value, with weekdays and weekends included in the calculation of days late:
(a) One day: deduct 5%;
(b) Two days: deduct 10%;
(c) Three days: deduct 20%;
(d) Four days: deduct 40%;
(e) Five days: deduct 60%;
(f) Six days: deduct 80%;
(g) Seven days: A result of zero is awarded for the assessment task.

The following penalties will apply for a late submission for an online examination:
Less than 15 minutes: No penalty
From 15 minutes to 30 minutes: 20% penalty
More than 30 minutes: 100% penalty

Links to relevant University policy and procedures

For more information on Academic Learning & Teaching categories including:

  • Assessment: Courses and Coursework Programs
  • Review of Assessment and Final Grades
  • Supplementary Assessment
  • Central Examinations
  • Deferred Examinations
  • Student Conduct
  • Students with a Disability

For more information, visit https://www.usc.edu.au/explore/policies-and-procedures#academic-learning-and-teaching

Student Charter

UniSC is committed to excellence in teaching, research and engagement in an environment that is inclusive, inspiring, safe and respectful. The Student Charter sets out what students can expect from the University, and what in turn is expected of students, to achieve these outcomes.

General Enquiries

  • In person:
    • UniSC Sunshine Coast - Student Central, Ground Floor, Building C, 90 Sippy Downs Drive, Sippy Downs
    • UniSC Moreton Bay - Service Centre, Ground Floor, Foundation Building, Gympie Road, Petrie
    • UniSC SouthBank - Student Central, Building A4 (SW1), 52 Merivale Street, South Brisbane
    • UniSC Gympie - Student Central, 71 Cartwright Road, Gympie
    • UniSC Fraser Coast - Student Central, Student Central, Building A, 161 Old Maryborough Rd, Hervey Bay
    • UniSC Caboolture - Student Central, Level 1 Building J, Cnr Manley and Tallon Street, Caboolture
  • Tel:+61 7 5430 2890
  • Email:studentcentral@usc.edu.au
Download PDF