Studying online

There are now 2 possible online modes for units:

Units with modes Online timetabled and Online flexible are available for any student to self-enrol and study online.

Click on an offering mode for more details.

Unit Overview


This unit deals with data modelling through the theory and practice of database design, implementation and use. Several database models are addressed, with a strong focus on the relational model and its theoretical grounding in sets and relational algebra. The process of problem decomposition into entity–relations, the design of appropriate relational schemas, and their refinement through normalisation underlies the unit. Critical issues surrounding the design of query languages and their implementation are addressed, and information retrieval is practised using a specific query language. Students learn database connectivity by building systems in one of several programming languages that support a connectivity Application Programming Interface (API).

6 points
Details for undergraduate courses
  • Level 2 elective

Students are able to (1) understand existing database implementation and create refinements and improvements through analysis; (2) understand the 'business' requirements to design a database; (3) refine a database to improve and ensure correctness and reliability; (4) correctly program SQL queries and reports; and (5) build an application layer interface for easier user interaction.


This comprises an examination, a programming test and laboratory-based exercises.

Student may be offered supplementary assessment in this unit if they meet the eligibility criteria.

Unit Coordinator(s)
Associate Professor David Glance
Unit rules
CITS1200 Java Programming
or CITS1210 C Programming
or CITS1220 Software Engineering
or CITS1005 Computing for Engineers and Scientists
or CITS1001 Object-oriented Programming and Software Engineering
or CITS1002 Programming and Systems
or CITS1401 Problem Solving and Programming
or CITS2401 Computer Analysis and Visualisation
CITS3240 Databases
Contact hours
56 (lectures: 26 hrs
labs: 24 hrs
tutorials: 6 hrs)

Book lists are available from
  • The availability of units in Semester 1, 2, etc. was correct at the time of publication but may be subject to change.
  • All students are responsible for identifying when they need assistance to improve their academic learning, research, English language and numeracy skills; seeking out the services and resources available to help them; and applying what they learn. Students are encouraged to register for free online support through GETSmart; to help themselves to the extensive range of resources on UWA's STUDYSmarter website; and to participate in WRITESmart and (ma+hs)Smart drop-ins and workshops.
  • Unit readings, including any essential textbooks, are listed in the unit outline for each unit, one week prior the commencement of study. The unit outline will be available via the LMS and the UWA Handbook one week prior the commencement of study. Reading lists and essential textbooks are subject to change each semester. Information on essential textbooks will also be made available on the Essential Textbooks. This website is updated regularly in the lead up to semester so content may change. It is recommended that students purchase essential textbooks for convenience due to the frequency with which they will be required during the unit. A limited number of textbooks will be made available from the Library in print and will also be made available online wherever possible. Essential textbooks can be purchased from the commercial vendors to secure the best deal. The Student Guild can provide assistance on where to purchase books if required. Books can be purchased second hand at the Guild Secondhand bookshop (second floor, Guild Village), which is located on campus.
  • Contact hours provide an indication of the type and extent of in-class activities this unit may contain. The total amount of student work (including contact hours, assessment time, and self-study) will approximate 150 hours per 6 credit points.