Structured Data

Undergraduate | 2026

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
Bernard Evans
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
Discipline group A
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

Availability

Census date Icon
Census date
Fri 27/03/2026
Enrol by date
Enrol by date
Fri 13/03/2026
Last day to W
Last day to W
Fri 10/04/2026
Last day to WF
Last day to WF
Fri 08/05/2026

Class details

Mawson Lakes

Class number
Class number 24777
Section
Section FR01
Size
Size 158
Available
Available 158
Dates Days Time Campus Location Instructor
23 Feb - 13 Apr Monday 11:10am - 1pm Mawson Lakes Building F, F1-25
4 May - 1 Jun Monday 11:10am - 1pm Mawson Lakes Building F, F1-25
Notes:
Please note some spaces in this class have been reserved for Bachelor of Software Engineering (Apprenticeship) students.
Class number
Class number 24778
Section
Section FR02
Size
Size 158
Available
Available 158
Dates Days Time Campus Location Instructor
23 Feb - 13 Apr Monday 2:10pm - 4pm Mawson Lakes Building F, F1-25
4 May - 1 Jun Monday 2:10pm - 4pm Mawson Lakes Building F, F1-25
Class number
Class number 24779
Section
Section PR01
Size
Size 20
Available
Available 20
Dates Days Time Campus Location Instructor
25 Feb - 15 Apr Wednesday 9:10am - 11am Mawson Lakes Building P, P1-12
27 Feb - 17 Apr Friday 11:10am - 1pm Mawson Lakes Building P, P1-12
6 May - 3 Jun Wednesday 9:10am - 11am Mawson Lakes Building P, P1-12
8 May - 5 Jun Friday 11:10am - 1pm Mawson Lakes Building P, P1-12
Class number
Class number 24780
Section
Section PR02
Size
Size 20
Available
Available 20
Dates Days Time Campus Location Instructor
25 Feb - 15 Apr Wednesday 4:10pm - 6pm Mawson Lakes Building P, P1-12
27 Feb - 17 Apr Friday 2:10pm - 4pm Mawson Lakes Building P, P1-12
6 May - 3 Jun Wednesday 4:10pm - 6pm Mawson Lakes Building P, P1-12
8 May - 5 Jun Friday 2:10pm - 4pm Mawson Lakes Building P, P1-12
Class number
Class number 24781
Section
Section PR03
Size
Size 20
Available
Available 20
Dates Days Time Campus Location Instructor
26 Feb - 16 Apr Thursday 11:10am - 1pm Mawson Lakes Building P, P1-15
27 Feb - 17 Apr Friday 4:10pm - 6pm Mawson Lakes Building F, F1-13
7 May - 4 Jun Thursday 11:10am - 1pm Mawson Lakes Building P, P1-15
8 May - 5 Jun Friday 4:10pm - 6pm Mawson Lakes Building F, F1-13
Class number
Class number 24782
Section
Section PR04
Size
Size 20
Available
Available 20
Dates Days Time Campus Location Instructor
24 Feb - 14 Apr Tuesday 2:10pm - 4pm Mawson Lakes Building P, P1-12
24 Feb - 14 Apr Tuesday 4:10pm - 6pm Mawson Lakes Building P, P1-15
5 May - 2 Jun Tuesday 2:10pm - 4pm Mawson Lakes Building P, P1-12
5 May - 2 Jun Tuesday 4:10pm - 6pm Mawson Lakes Building P, P1-15
Class number
Class number 24783
Section
Section PR05
Size
Size 20
Available
Available 20
Dates Days Time Campus Location Instructor
24 Feb - 14 Apr Tuesday 11:10am - 1pm Mawson Lakes Building P, P1-15
27 Feb - 17 Apr Friday 9:10am - 11am Mawson Lakes Building F, F1-17
5 May - 2 Jun Tuesday 11:10am - 1pm Mawson Lakes Building P, P1-15
8 May - 5 Jun Friday 9:10am - 11am Mawson Lakes Building F, F1-17
Class number
Class number 24784
Section
Section PR06
Size
Size 20
Available
Available 20
Dates Days Time Campus Location Instructor
24 Feb - 14 Apr Tuesday 11:10am - 1pm Mawson Lakes Building P, P1-12
25 Feb - 15 Apr Wednesday 11:10am - 1pm Mawson Lakes Building P, P1-12
5 May - 2 Jun Tuesday 11:10am - 1pm Mawson Lakes Building P, P1-12
6 May - 3 Jun Wednesday 11:10am - 1pm Mawson Lakes Building P, P1-12
Class number
Class number 24785
Section
Section PR07
Size
Size 20
Available
Available 20
Dates Days Time Campus Location Instructor
25 Feb - 15 Apr Wednesday 2:10pm - 4pm Mawson Lakes Building P, P1-12
27 Feb - 17 Apr Friday 9:10am - 11am Mawson Lakes Building P, P1-12
6 May - 3 Jun Wednesday 2:10pm - 4pm Mawson Lakes Building P, P1-12
8 May - 5 Jun Friday 9:10am - 11am Mawson Lakes Building P, P1-12
Class number
Class number 24786
Section
Section PR08
Size
Size 20
Available
Available 20
Dates Days Time Campus Location Instructor
23 Feb - 13 Apr Monday 4:10pm - 6pm Mawson Lakes Building P, P1-12
27 Feb - 17 Apr Friday 4:10pm - 6pm Mawson Lakes Building F, F1-17
4 May - 1 Jun Monday 4:10pm - 6pm Mawson Lakes Building P, P1-12
8 May - 5 Jun Friday 4:10pm - 6pm Mawson Lakes Building F, F1-17
Class number
Class number 24787
Section
Section PR09
Size
Size 20
Available
Available 20
Dates Days Time Campus Location Instructor
26 Feb - 16 Apr Thursday 9:10am - 11am Mawson Lakes Building P, P1-15
26 Feb - 16 Apr Thursday 2:10pm - 4pm Mawson Lakes Building P, P1-15
7 May - 4 Jun Thursday 9:10am - 11am Mawson Lakes Building P, P1-15
7 May - 4 Jun Thursday 2:10pm - 4pm Mawson Lakes Building P, P1-15
Class number
Class number 24788
Section
Section PR10
Size
Size 20
Available
Available 20
Dates Days Time Campus Location Instructor
24 Feb - 14 Apr Tuesday 11:10am - 1pm Mawson Lakes Building F, F1-17
26 Feb - 16 Apr Thursday 2:10pm - 4pm Mawson Lakes Building P, P1-12
5 May - 2 Jun Tuesday 11:10am - 1pm Mawson Lakes Building F, F1-17
7 May - 4 Jun Thursday 2:10pm - 4pm Mawson Lakes Building P, P1-12
Class number
Class number 24789
Section
Section PR11
Size
Size 20
Available
Available 20
Dates Days Time Campus Location Instructor
26 Feb - 16 Apr Thursday 9:10am - 11am Mawson Lakes Building P, P1-12
26 Feb - 16 Apr Thursday 4:10pm - 6pm Mawson Lakes Building P, P1-12
7 May - 4 Jun Thursday 9:10am - 11am Mawson Lakes Building P, P1-12
7 May - 4 Jun Thursday 4:10pm - 6pm Mawson Lakes Building P, P1-12
Class number
Class number 24790
Section
Section PR12
Size
Size 8
Available
Available 8
Dates Days Time Campus Location Instructor
23 Feb - 13 Apr Monday 12:10pm - 2pm Mawson Lakes Building P, P1-12
27 Feb - 17 Apr Friday 11:10am - 1pm Mawson Lakes Building F, F1-17
4 May - 1 Jun Monday 12:10pm - 2pm Mawson Lakes Building P, P1-12
8 May - 5 Jun Friday 11:10am - 1pm Mawson Lakes Building F, F1-17
Notes:
HSOEA - Bachelor of Software Engineering (Honours)(Apprenticeship) students, please enrol in this class.
Class number
Class number 24791
Section
Section PR13
Size
Size 20
Available
Available 20
Dates Days Time Campus Location Instructor
25 Feb - 15 Apr Wednesday 2:10pm - 4pm Mawson Lakes Building P, P1-15
27 Feb - 17 Apr Friday 4:10pm - 6pm Mawson Lakes Building P, P1-15
6 May - 3 Jun Wednesday 2:10pm - 4pm Mawson Lakes Building P, P1-15
8 May - 5 Jun Friday 4:10pm - 6pm Mawson Lakes Building P, P1-15
Class number
Class number 24792
Section
Section PR14
Size
Size 20
Available
Available 20
Dates Days Time Campus Location Instructor
24 Feb - 14 Apr Tuesday 2:10pm - 4pm Mawson Lakes Building F, F1-17
26 Feb - 16 Apr Thursday 2:10pm - 4pm Mawson Lakes Building F, F1-17
5 May - 2 Jun Tuesday 2:10pm - 4pm Mawson Lakes Building F, F1-17
7 May - 4 Jun Thursday 2:10pm - 4pm Mawson Lakes Building F, F1-17
Class number
Class number 24793
Section
Section PR15
Size
Size 20
Available
Available 20
Dates Days Time Campus Location Instructor
23 Feb - 13 Apr Monday 2:10pm - 4pm Mawson Lakes Building P, P1-12
25 Feb - 15 Apr Wednesday 4:10pm - 6pm Mawson Lakes Building P, P1-15
4 May - 1 Jun Monday 2:10pm - 4pm Mawson Lakes Building P, P1-12
6 May - 3 Jun Wednesday 4:10pm - 6pm Mawson Lakes Building P, P1-15
Class number
Class number 24794
Section
Section PR16
Size
Size 20
Available
Available 20
Dates Days Time Campus Location Instructor
24 Feb - 14 Apr Tuesday 4:10pm - 6pm Mawson Lakes Building P, P1-12
26 Feb - 16 Apr Thursday 11:10am - 1pm Mawson Lakes Building F, F1-17
5 May - 2 Jun Tuesday 4:10pm - 6pm Mawson Lakes Building P, P1-12
7 May - 4 Jun Thursday 11:10am - 1pm Mawson Lakes Building F, F1-17

Adelaide City Campus East

Class number
Class number 24795
Section
Section FR01
Size
Size 350
Available
Available 350
Dates Days Time Campus Location Instructor
23 Feb - 13 Apr Monday 6:10pm - 8pm Adelaide City Campus East The Braggs, G.60
4 May - 1 Jun Monday 6:10pm - 8pm Adelaide City Campus East The Braggs, G.60
Class number
Class number 24796
Section
Section PR01
Size
Size 44
Available
Available 44
Dates Days Time Campus Location Instructor
24 Feb - 14 Apr Tuesday 4:10pm - 6pm Adelaide City Campus East Ingkarni Wardli, B.15
25 Feb - 15 Apr Wednesday 5:10pm - 7pm Adelaide City Campus East Engin and Maths Sciences, G13
5 May - 2 Jun Tuesday 4:10pm - 6pm Adelaide City Campus East Ingkarni Wardli, B.15
6 May - 3 Jun Wednesday 5:10pm - 7pm Adelaide City Campus East Engin and Maths Sciences, G13
Class number
Class number 24797
Section
Section PR02
Size
Size 32
Available
Available 32
Dates Days Time Campus Location Instructor
24 Feb - 14 Apr Tuesday 9:10am - 11am Adelaide City Campus East Ingkarni Wardli, 2.36
25 Feb - 15 Apr Wednesday 11:10am - 1pm Adelaide City Campus East Ingkarni Wardli, 2.36
5 May - 2 Jun Tuesday 9:10am - 11am Adelaide City Campus East Ingkarni Wardli, 2.36
6 May - 3 Jun Wednesday 11:10am - 1pm Adelaide City Campus East Ingkarni Wardli, 2.36
Class number
Class number 24798
Section
Section PR03
Size
Size 46
Available
Available 46
Dates Days Time Campus Location Instructor
26 Feb - 16 Apr Thursday 8:10am - 10am Adelaide City Campus East Ingkarni Wardli, B.16
26 Feb - 16 Apr Thursday 4:10pm - 6pm Adelaide City Campus East Ingkarni Wardli, B.16
7 May - 4 Jun Thursday 8:10am - 10am Adelaide City Campus East Ingkarni Wardli, B.16
7 May - 4 Jun Thursday 4:10pm - 6pm Adelaide City Campus East Ingkarni Wardli, B.16
Class number
Class number 24799
Section
Section PR04
Size
Size 32
Available
Available 32
Dates Days Time Campus Location Instructor
24 Feb - 14 Apr Tuesday 11:10am - 1pm Adelaide City Campus East Ingkarni Wardli, 2.36
27 Feb - 17 Apr Friday 2:10pm - 4pm Adelaide City Campus East Ingkarni Wardli, 2.36
5 May - 2 Jun Tuesday 11:10am - 1pm Adelaide City Campus East Ingkarni Wardli, 2.36
8 May - 5 Jun Friday 2:10pm - 4pm Adelaide City Campus East Ingkarni Wardli, 2.36
Class number
Class number 24800
Section
Section PR05
Size
Size 32
Available
Available 32
Dates Days Time Campus Location Instructor
26 Feb - 16 Apr Thursday 8:10am - 10am Adelaide City Campus East Ingkarni Wardli, 2.36
26 Feb - 16 Apr Thursday 2:10pm - 4pm Adelaide City Campus East Ingkarni Wardli, 2.36
7 May - 4 Jun Thursday 8:10am - 10am Adelaide City Campus East Ingkarni Wardli, 2.36
7 May - 4 Jun Thursday 2:10pm - 4pm Adelaide City Campus East Ingkarni Wardli, 2.36
Class number
Class number 24801
Section
Section PR06
Size
Size 44
Available
Available 44
Dates Days Time Campus Location Instructor
24 Feb - 14 Apr Tuesday 2:10pm - 4pm Adelaide City Campus East Ingkarni Wardli, B.15
27 Feb - 17 Apr Friday 1:10pm - 3pm Adelaide City Campus East Ingkarni Wardli, B.15
5 May - 2 Jun Tuesday 2:10pm - 4pm Adelaide City Campus East Ingkarni Wardli, B.15
8 May - 5 Jun Friday 1:10pm - 3pm Adelaide City Campus East Ingkarni Wardli, B.15
Class number
Class number 24802
Section
Section PR07
Size
Size 46
Available
Available 46
Dates Days Time Campus Location Instructor
24 Feb - 14 Apr Tuesday 11:10am - 1pm Adelaide City Campus East Ingkarni Wardli, B.16
26 Feb - 16 Apr Thursday 2:10pm - 4pm Adelaide City Campus East Ingkarni Wardli, B.16
5 May - 2 Jun Tuesday 11:10am - 1pm Adelaide City Campus East Ingkarni Wardli, B.16
7 May - 4 Jun Thursday 2:10pm - 4pm Adelaide City Campus East Ingkarni Wardli, B.16
Class number
Class number 24803
Section
Section PR08
Size
Size 63
Available
Available 63
Dates Days Time Campus Location Instructor
24 Feb - 14 Apr Tuesday 11:10am - 1pm Adelaide City Campus East Ingkarni Wardli, B.23
27 Feb - 17 Apr Friday 1:10pm - 3pm Adelaide City Campus East Ingkarni Wardli, 2.34
5 May - 2 Jun Tuesday 11:10am - 1pm Adelaide City Campus East Ingkarni Wardli, B.23
8 May - 5 Jun Friday 1:10pm - 3pm Adelaide City Campus East Ingkarni Wardli, 2.34

Census date Icon
Census date
Fri 04/09/2026
Enrol by date
Enrol by date
Fri 21/08/2026
Last day to W
Last day to W
Fri 18/09/2026
Last day to WF
Last day to WF
Fri 16/10/2026

Class details

Mawson Lakes

Class number
Class number 54886
Section
Section FR01
Size
Size 105
Available
Available 105
Dates Days Time Campus Location Instructor
3 Aug - 21 Sep Monday 4:10pm - 6pm Mawson Lakes Building P, P1-14
12 Oct - 9 Nov Monday 4:10pm - 6pm Mawson Lakes Building P, P1-14
Class number
Class number 54887
Section
Section PR01
Size
Size 20
Available
Available 20
Dates Days Time Campus Location Instructor
14 Aug - 25 Sep Friday 11:10am - 1pm Mawson Lakes Building P, P1-12
14 Aug - 25 Sep Friday 2:10pm - 4pm Mawson Lakes Building F, F1-13
16 Oct - 13 Nov Friday 11:10am - 1pm Mawson Lakes Building P, P1-12
16 Oct - 13 Nov Friday 2:10pm - 4pm Mawson Lakes Building F, F1-13
Class number
Class number 54888
Section
Section PR02
Size
Size 20
Available
Available 20
Dates Days Time Campus Location Instructor
11 Aug - 22 Sep Tuesday 11:10am - 1pm Mawson Lakes Building P, P2-43
13 Aug - 24 Sep Thursday 9:10am - 11am Mawson Lakes Building F, F1-13
13 Oct - 10 Nov Tuesday 11:10am - 1pm Mawson Lakes Building P, P2-43
15 Oct - 12 Nov Thursday 9:10am - 11am Mawson Lakes Building F, F1-13
Class number
Class number 54889
Section
Section PR03
Size
Size 20
Available
Available 20
Dates Days Time Campus Location Instructor
11 Aug - 22 Sep Tuesday 9:10am - 11am Mawson Lakes Building F, F1-13
13 Aug - 24 Sep Thursday 2:10pm - 4pm Mawson Lakes Building P, P1-15
13 Oct - 10 Nov Tuesday 9:10am - 11am Mawson Lakes Building F, F1-13
15 Oct - 12 Nov Thursday 2:10pm - 4pm Mawson Lakes Building P, P1-15
Class number
Class number 54890
Section
Section PR04
Size
Size 20
Available
Available 20
Dates Days Time Campus Location Instructor
12 Aug - 23 Sep Wednesday 2:10pm - 4pm Mawson Lakes Building GP, GP1-06
14 Aug - 25 Sep Friday 9:10am - 11am Mawson Lakes Building F, F1-13
14 Oct - 11 Nov Wednesday 2:10pm - 4pm Mawson Lakes Building GP, GP1-06
16 Oct - 13 Nov Friday 9:10am - 11am Mawson Lakes Building F, F1-13
Class number
Class number 54891
Section
Section PR05
Size
Size 20
Available
Available 20
Dates Days Time Campus Location Instructor
12 Aug - 23 Sep Wednesday 9:10am - 11am Mawson Lakes Building F, F1-15
13 Aug - 24 Sep Thursday 11:10am - 1pm Mawson Lakes Building F, F1-15
14 Oct - 11 Nov Wednesday 9:10am - 11am Mawson Lakes Building F, F1-15
15 Oct - 12 Nov Thursday 11:10am - 1pm Mawson Lakes Building F, F1-15
Class number
Class number 54892
Section
Section PR06
Size
Size 20
Available
Available 20
Dates Days Time Campus Location Instructor
11 Aug - 22 Sep Tuesday 3:10pm - 5pm Mawson Lakes Building F, F1-13
12 Aug - 23 Sep Wednesday 11:10am - 1pm Mawson Lakes Building P, P1-12
13 Oct - 10 Nov Tuesday 3:10pm - 5pm Mawson Lakes Building F, F1-13
14 Oct - 11 Nov Wednesday 11:10am - 1pm Mawson Lakes Building P, P1-12

Adelaide City Campus East

Class number
Class number 54893
Section
Section FR01
Size
Size 156
Available
Available 156
Dates Days Time Campus Location Instructor
3 Aug - 21 Sep Monday 3:10pm - 5pm Adelaide City Campus East Napier, 102
12 Oct - 9 Nov Monday 3:10pm - 5pm Adelaide City Campus East Napier, 102
Class number
Class number 54894
Section
Section PR01
Size
Size 68
Available
Available 68
Dates Days Time Campus Location Instructor
11 Aug - 22 Sep Tuesday 8:10am - 10am Adelaide City Campus East Engin and Maths Sciences, 108
11 Aug - 22 Sep Tuesday 12:10pm - 2pm Adelaide City Campus East Ingkarni Wardli, B.23
13 Oct - 10 Nov Tuesday 8:10am - 10am Adelaide City Campus East Engin and Maths Sciences, 108
13 Oct - 10 Nov Tuesday 12:10pm - 2pm Adelaide City Campus East Ingkarni Wardli, B.23
Class number
Class number 54895
Section
Section PR02
Size
Size 63
Available
Available 63
Dates Days Time Campus Location Instructor
12 Aug - 23 Sep Wednesday 4:10pm - 6pm Adelaide City Campus East Ingkarni Wardli, 2.34
12 Aug - 23 Sep Wednesday 4:10pm - 6pm Adelaide City Campus East Ingkarni Wardli, G.22
14 Oct - 11 Nov Wednesday 4:10pm - 6pm Adelaide City Campus East Ingkarni Wardli, 2.34
14 Oct - 11 Nov Wednesday 4:10pm - 6pm Adelaide City Campus East Ingkarni Wardli, G.22
Class number
Class number 54896
Section
Section PR03
Size
Size 63
Available
Available 63
Dates Days Time Campus Location Instructor
10 Aug - 21 Sep Monday 12:10pm - 2pm Adelaide City Campus East Ingkarni Wardli, G.22
12 Aug - 23 Sep Wednesday 8:10am - 10am Adelaide City Campus East Ingkarni Wardli, B.23
12 Oct - 9 Nov Monday 12:10pm - 2pm Adelaide City Campus East Ingkarni Wardli, G.22
14 Oct - 11 Nov Wednesday 8:10am - 10am Adelaide City Campus East Ingkarni Wardli, B.23

Prerequisite(s)

N/A

Corequisite(s)

N/A

Antirequisite(s)

N/A

Assumed knowledge

N/A

Textbook(s)

N/A

Inherent requirements

N/A

Other resources

N/A

Assessment

N/A

Fee calculator

To display course fees, please 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.

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.

Degree list
The following degrees include this course
Bachelor of Computer Science (Honours)
Bachelor of Teaching (Secondary) (Honours)
Bachelor of Cyber Security
Bachelor of Information Technology
Bachelor of Mathematics (Honours) majoring in Data Science
Bachelor of Software Engineering (Honours)
Bachelor of Computer Science