Database Management unit (KXO206)

Shanghai Ocean University

Introduction

This unit takes student database skills beyond an elementary knowledge of the SQL (Structured Query Language) database language to a level where they can undertake significant database systems development using both SQL and Oracle's procedural extension to SQL, PL/SQL. This unit seeks to develop knowledge and skills in: The SQL*Plus programming environment Developing and debugging SQL scripts Developing and debugging PL/SQL scripts Generating formatted reports using the appropriate SQL*Plus environment variables

Summary

Unit name	Database Management
Unit code	KXO206
Credit points	12.5
College/School	Sciences and Engineering School of Information and Communication Technology
Discipline	Information & Communication Technology
Coordinator	Doctor Sumbal Maqsood
Available as an elective?	No
Delivered By	Third Party(ies): Shanghai Ocean University AEIN Institute
Level	Intermediate

Availability

Location	Study period	Attendance options		Available to
Shanghai Ocean University	Shanghai Semester 2

Note

Enrolment in units available at ECA Melbourne, Hong Kong Universal Ed, and Shanghai Ocean University is only available to eligible students studying at those corresponding locations.

Please check that your computer meets the minimum System Requirements if you are attending via Distance/Off-Campus.

Units are offered in attending mode unless otherwise indicated (that is attendance is required at the campus identified). A unit identified as offered by distance, that is there is no requirement for attendance, is identified with a nominal enrolment campus. A unit offered to both attending students and by distance from the same campus is identified as having both modes of study.

Key Dates

Study Period	Start date	Census date	WW date	End date
Shanghai Semester 2	1/3/2026	6/4/2026	18/4/2026	4/6/2026

* The Final WW Date is the final date from which you can withdraw from the unit without academic penalty, however you will still incur a financial liability (refer to How do I withdraw from a unit? for more information).

Unit census dates currently displaying for 2026 are indicative and subject to change. Finalised census dates for 2026 will be available from the 1st October 2025. Note census date cutoff is 11.59pm AEST (AEDT during October to March).

About Census Dates

Learning Outcomes

• Apply SQL and related technologies to access and maintain a relational database
• Use SQL, PL/SQL and related technologies in creating a relational database
• Explore issues involved in database design, implementation and management

Fee Information

Field of Education	Commencing Student Contribution 1,3	Grandfathered Student Contribution 1,3	Approved Pathway Course Student Contribution 2,3	Domestic Full Fee 4
020307	$1,192.00	$1,192.00	not applicable	$2,919.00

¹ Please refer to more information on student contribution amounts.
² Please refer to more information on eligibility and Approved Pathway courses.
³ Please refer to more information on eligibility for HECS-HELP.
⁴ Please refer to more information on eligibility for FEE-HELP.

If you have any questions in relation to the fees, please contact UniConnect or more information is available on StudyAssist.

Please note: international students should refer to What is an indicative Fee? to get an indicative course cost.

Requisites

Prerequisites

KXO131 or KIT102

Teaching

Teaching Pattern	Teaching is grouped into 13 modules, including weekly lectures, workshops and independent learning activities.
Assessment	Weekly Quizzes (15%)|Database Maintenance Report (25%)|In-Workshop SQL Test (25%)|Database Creation Report (35%)
Timetable	View the lecture timetable | View the full unit timetable

Textbooks

Required	Casteel, J. (2015) Oracle 12c, SQL, Third Edition. Cengage. Boston MA. ISBN: 9781305251038

The University reserves the right to amend or remove courses and unit availabilities, as appropriate.