Structured Data

Undergraduate

Course page banner
Mode icon
Mode
Mode
Your studies will be on-campus, and may include some online delivery
On campus
area/catalogue icon
Area/Catalogue
COMP 1003
Course ID icon
Course ID
200071
Campus icon
Campus
Mawson Lakes, Adelaide City Campus East
Level of study
Level of study
Undergraduate
Unit value icon
Unit value
6
Course owner
Course owner
School of Comp Sc & IT
Course coordinator
Course coordinator
David Cowdrey
Course level icon
Course level
1
Work Integrated Learning course
Work Integrated Learning course
No
Study abroad and student exchange icon
Inbound study abroad and exchange
Inbound study abroad and exchange
The fee you pay will depend on the number and type of courses you study.
Yes
University-wide elective icon
University-wide elective course
Yes
Single course enrollment
Single course enrolment
Yes

Course overview

The course will equip students with the knowledge and skills required to implement and work with structured data in relational database systems. Through theoretical exploration and practical application, students will learn to capture data accurately, write queries to extract information, and the basics of managing data security. The topics covered will provide students with a solid foundation for real-world data management in business.

  • Introduction to Relational Databases
  • Database Design and Modelling
  • Data Definition Language (DDL) and Data Manipulation Language (DML)
  • Queries
  • Data Manipulation Language (Part 1)
  • Data Manipulation Language (Part 2)
  • Views and Common Table Expressions
  • Stored Procedures
  • Indexes
  • Control Data Language

Course learning outcomes

  • Explain how data is stored and retrieved from a relational database and the advantages of using the relational model
  • Design a relational database given a set of data and usage requirements
  • Design and implement database queries to retrieve specified data from a relational database
  • Explain how a query interacts with data within a relational database system and the impact design can have on management, retrieval and efficiency
  • Demonstrate approaches to securing data access within a database
  • Select for efficiency between alternative query options

Prerequisite(s)

N/A

Corequisite(s)

N/A

Antirequisite(s)

  • Must not have completed INFS1025 Data Driven Web Technologies at the University of South Australia OR must not have completed INFT1032 UO Data Driven Web Technologies at the University of South Australia OR must not have completed COMPSCI2207 Web & Database Computing at the University of Adelaide

Availability

Enrol by date
Enrol by date
Fri 05/03/2027
Census date Icon
Census date
Fri 26/03/2027
Last day to W
Last day to W
Fri 09/04/2027
Last day to WF
Last day to WF
Fri 07/05/2027

Class details

Mawson Lakes

Group 1

Class number
Class number 27171
Section
Section FR02
Size
Size 125
Available
Available 119
Dates Days Time Campus Location Instructor
22 Feb - 12 Apr Monday 3:10pm - 5pm Mawson Lakes The Mawson Centre, MC1-02
3 May - 24 May Monday 3:10pm - 5pm Mawson Lakes The Mawson Centre, MC1-02
Notes:
Please note that a number of places in this class have been reserved for students enrolled in the Bachelor of Software Engineering (Apprenticeship) program.
Class number
Class number 27172
Section
Section FR01
Size
Size 135
Available
Available 133
Dates Days Time Campus Location Instructor
22 Feb - 12 Apr Monday 11:10am - 1pm Mawson Lakes Building F, F1-25
3 May - 24 May Monday 11:10am - 1pm Mawson Lakes Building F, F1-25
Class number
Class number 27132
Section
Section PR04
Size
Size 60
Available
Available 60
Dates Days Time Campus Location Instructor
24 Feb - 14 Apr Wednesday 4:10pm - 6pm Mawson Lakes Building F, F1-18
5 May - 26 May Wednesday 4:10pm - 6pm Mawson Lakes Building F, F1-18
23 Feb - 13 Apr Tuesday 10:10am - 12pm Mawson Lakes Building F, F1-18
4 May - 25 May Tuesday 10:10am - 12pm Mawson Lakes Building F, F1-18
Class number
Class number 27133
Section
Section PR03
Size
Size 60
Available
Available 56
Dates Days Time Campus Location Instructor
24 Feb - 14 Apr Wednesday 8:10am - 10am Mawson Lakes Building F, F1-18
5 May - 26 May Wednesday 8:10am - 10am Mawson Lakes Building F, F1-18
23 Feb - 13 Apr Tuesday 8:10am - 10am Mawson Lakes Building F, F1-18
4 May - 25 May Tuesday 8:10am - 10am Mawson Lakes Building F, F1-18
Class number
Class number 27134
Section
Section PR02
Size
Size 80
Available
Available 76
Dates Days Time Campus Location Instructor
24 Feb - 14 Apr Wednesday 10:10am - 12pm Mawson Lakes Building F, F1-16
5 May - 26 May Wednesday 10:10am - 12pm Mawson Lakes Building F, F1-16
22 Feb - 12 Apr Monday 1:10pm - 3pm Mawson Lakes Building F, F1-16
3 May - 24 May Monday 1:10pm - 3pm Mawson Lakes Building F, F1-16
Class number
Class number 27135
Section
Section PR01
Size
Size 80
Available
Available 80
Dates Days Time Campus Location Instructor
24 Feb - 14 Apr Wednesday 2:10pm - 4pm Mawson Lakes Building F, F1-16
5 May - 26 May Wednesday 2:10pm - 4pm Mawson Lakes Building F, F1-16
23 Feb - 13 Apr Tuesday 12:10pm - 2pm Mawson Lakes Building F, F1-16
4 May - 25 May Tuesday 12:10pm - 2pm Mawson Lakes Building F, F1-16
Notes:
Please note that a number of places in this class have been reserved for students enrolled in the Bachelor of Software Engineering (Apprenticeship) program.

Adelaide City Campus East

Group 1

Class number
Class number 27143
Section
Section FR02
Size
Size 270
Available
Available 265
Dates Days Time Campus Location Instructor
22 Feb - 12 Apr Monday 3:10pm - 5pm Adelaide City Campus East Helen Mayo North, N103
3 May - 24 May Monday 3:10pm - 5pm Adelaide City Campus East Helen Mayo North, N103
Class number
Class number 27144
Section
Section FR01
Size
Size 270
Available
Available 252
Dates Days Time Campus Location Instructor
22 Feb - 12 Apr Monday 11:10am - 1pm Adelaide City Campus East Helen Mayo North, N103
3 May - 24 May Monday 11:10am - 1pm Adelaide City Campus East Helen Mayo North, N103
Class number
Class number 27136
Section
Section PR07
Size
Size 63
Available
Available 52
Dates Days Time Campus Location Instructor
25 Feb - 15 Apr Thursday 4:10pm - 6pm Adelaide City Campus East Engin and Maths Sciences, 108
6 May - 27 May Thursday 4:10pm - 6pm Adelaide City Campus East Engin and Maths Sciences, 108
23 Feb - 13 Apr Tuesday 5:10pm - 7pm Adelaide City Campus East Ingkarni Wardli, G.22
4 May - 25 May Tuesday 5:10pm - 7pm Adelaide City Campus East Ingkarni Wardli, G.22
Class number
Class number 27137
Section
Section PR06
Size
Size 63
Available
Available 62
Dates Days Time Campus Location Instructor
25 Feb - 15 Apr Thursday 11:10am - 1pm Adelaide City Campus East Ingkarni Wardli, B.23
6 May - 27 May Thursday 11:10am - 1pm Adelaide City Campus East Ingkarni Wardli, B.23
23 Feb - 13 Apr Tuesday 4:10pm - 6pm Adelaide City Campus East Ingkarni Wardli, 2.34
4 May - 25 May Tuesday 4:10pm - 6pm Adelaide City Campus East Ingkarni Wardli, 2.34
Class number
Class number 27138
Section
Section PR05
Size
Size 80
Available
Available 80
Dates Days Time Campus Location Instructor
26 Feb - 16 Apr Friday 12:10pm - 2pm Adelaide City Campus East Engin and Maths Sciences, 108
7 May - 28 May Friday 12:10pm - 2pm Adelaide City Campus East Engin and Maths Sciences, 108
25 Feb - 15 Apr Thursday 8:10am - 10am Adelaide City Campus East Engin and Maths Sciences, 108
6 May - 27 May Thursday 8:10am - 10am Adelaide City Campus East Engin and Maths Sciences, 108
Class number
Class number 27139
Section
Section PR04
Size
Size 68
Available
Available 68
Dates Days Time Campus Location Instructor
25 Feb - 15 Apr Thursday 9:10am - 11am Adelaide City Campus East Ingkarni Wardli, B.23
6 May - 27 May Thursday 9:10am - 11am Adelaide City Campus East Ingkarni Wardli, B.23
23 Feb - 13 Apr Tuesday 10:10am - 12pm Adelaide City Campus East Ingkarni Wardli, B.23
4 May - 25 May Tuesday 10:10am - 12pm Adelaide City Campus East Ingkarni Wardli, B.23
Class number
Class number 27140
Section
Section PR03
Size
Size 70
Available
Available 68
Dates Days Time Campus Location Instructor
24 Feb - 14 Apr Wednesday 5:10pm - 7pm Adelaide City Campus East Ingkarni Wardli, G.22
5 May - 26 May Wednesday 5:10pm - 7pm Adelaide City Campus East Ingkarni Wardli, G.22
23 Feb - 13 Apr Tuesday 12:10pm - 2pm Adelaide City Campus East Ingkarni Wardli, G.22
4 May - 25 May Tuesday 12:10pm - 2pm Adelaide City Campus East Ingkarni Wardli, G.22
Class number
Class number 27141
Section
Section PR02
Size
Size 70
Available
Available 68
Dates Days Time Campus Location Instructor
25 Feb - 15 Apr Thursday 12:10pm - 2pm Adelaide City Campus East Ingkarni Wardli, G.22
6 May - 27 May Thursday 12:10pm - 2pm Adelaide City Campus East Ingkarni Wardli, G.22
24 Feb - 14 Apr Wednesday 12:10pm - 2pm Adelaide City Campus East Ingkarni Wardli, G.22
5 May - 26 May Wednesday 12:10pm - 2pm Adelaide City Campus East Ingkarni Wardli, G.22
Class number
Class number 27142
Section
Section PR01
Size
Size 80
Available
Available 77
Dates Days Time Campus Location Instructor
25 Feb - 15 Apr Thursday 12:10pm - 2pm Adelaide City Campus East Engin and Maths Sciences, 108
6 May - 27 May Thursday 12:10pm - 2pm Adelaide City Campus East Engin and Maths Sciences, 108
24 Feb - 14 Apr Wednesday 12:10pm - 2pm Adelaide City Campus East Engin and Maths Sciences, 108
5 May - 26 May Wednesday 12:10pm - 2pm Adelaide City Campus East Engin and Maths Sciences, 108
Class number
Class number 28095
Section
Section PR08
Size
Size 46
Available
Available 42
Dates Days Time Campus Location Instructor
24 Feb - 14 Apr Wednesday 2:10pm - 4pm Adelaide City Campus East Ingkarni Wardli, B.16
5 May - 26 May Wednesday 2:10pm - 4pm Adelaide City Campus East Ingkarni Wardli, B.16
23 Feb - 13 Apr Tuesday 2:10pm - 4pm Adelaide City Campus East Ingkarni Wardli, G.22
4 May - 25 May Tuesday 2:10pm - 4pm Adelaide City Campus East Ingkarni Wardli, G.22

Enrol by date
Enrol by date
Fri 13/08/2027
Census date Icon
Census date
Fri 03/09/2027
Last day to W
Last day to W
Fri 17/09/2027
Last day to WF
Last day to WF
Fri 15/10/2027

Class details

Mawson Lakes

Group 1

Class number
Class number 61907
Section
Section PR01
Size
Size 40
Available
Available 40
Dates Days Time Campus Location Instructor
5 Aug - 23 Sep Thursday 3:10pm - 5pm Mawson Lakes Building F, F1-20/22
14 Oct - 4 Nov Thursday 3:10pm - 5pm Mawson Lakes Building F, F1-20/22
4 Aug - 22 Sep Wednesday 9:10am - 11am Mawson Lakes Building F, F1-20/22
13 Oct - 3 Nov Wednesday 9:10am - 11am Mawson Lakes Building F, F1-20/22
Class number
Class number 62237
Section
Section FR01
Size
Size 40
Available
Available 40
Dates Days Time Campus Location Instructor
2 Aug - 20 Sep Monday 11:10am - 1pm Mawson Lakes Building P, P1-14
11 Oct - 1 Nov Monday 11:10am - 1pm Mawson Lakes Building P, P1-14

Adelaide City Campus East

Group 1

Class number
Class number 62234
Section
Section PR03
Size
Size 55
Available
Available 54
Dates Days Time Campus Location Instructor
4 Aug - 22 Sep Wednesday 11:10am - 1pm Adelaide City Campus East Ingkarni Wardli, B.23
13 Oct - 3 Nov Wednesday 11:10am - 1pm Adelaide City Campus East Ingkarni Wardli, B.23
3 Aug - 21 Sep Tuesday 9:10am - 11am Adelaide City Campus East Ingkarni Wardli, B.23
12 Oct - 2 Nov Tuesday 9:10am - 11am Adelaide City Campus East Ingkarni Wardli, B.23
Class number
Class number 62235
Section
Section PR02
Size
Size 55
Available
Available 54
Dates Days Time Campus Location Instructor
3 Aug - 21 Sep Tuesday 4:10pm - 6pm Adelaide City Campus East Ingkarni Wardli, 2.34
12 Oct - 2 Nov Tuesday 4:10pm - 6pm Adelaide City Campus East Ingkarni Wardli, 2.34
2 Aug - 20 Sep Monday 3:10pm - 5pm Adelaide City Campus East Ingkarni Wardli, B.23
11 Oct - 1 Nov Monday 3:10pm - 5pm Adelaide City Campus East Ingkarni Wardli, B.23
Class number
Class number 62236
Section
Section PR01
Size
Size 55
Available
Available 54
Dates Days Time Campus Location Instructor
3 Aug - 21 Sep Tuesday 9:10am - 11am Adelaide City Campus East Ingkarni Wardli, 2.34
12 Oct - 2 Nov Tuesday 9:10am - 11am Adelaide City Campus East Ingkarni Wardli, 2.34
2 Aug - 20 Sep Monday 1:10pm - 3pm Adelaide City Campus East Ingkarni Wardli, G.22
11 Oct - 1 Nov Monday 1:10pm - 3pm Adelaide City Campus East Ingkarni Wardli, G.22
Class number
Class number 62238
Section
Section FR01
Size
Size 165
Available
Available 162
Dates Days Time Campus Location Instructor
2 Aug - 20 Sep Monday 11:10am - 1pm Adelaide City Campus East Basil Hetzel, H2-02
11 Oct - 1 Nov Monday 11:10am - 1pm Adelaide City Campus East Basil Hetzel, H2-02

Fee calculator

To display course fees for 2027, select your status and program below:

Study Abroad student tuition fees are available here.

Only some Postgraduate Coursework programs are available as Commonwealth Supported. Please check your program for specific fee information.

If you are studying in a Professional Pathway Psychology, Clinical Psychology or Social Work program, please refer to the Student Contributions amounts published here.

The Student Contribution amount displayed below is for students commencing a new program from 2021 onwards. If you are continuing in a program you commenced prior to 1 January 2021, or are commencing an Honours degree relating to an undergraduate degree you commenced prior to 1 January 2021, you may be charged a different Student Contribution amount from the amount displayed below. Please check the Student Contribution bands for continuing students here. If you are an international student, or a domestic student studying in a full fee paying place, and are continuing study that you commenced in 2025 or earlier, your fees will be available here before enrolments open for 2026.