Informatics 3: Content Management

Subject INFO20001 (2011)

Note: This is an archived Handbook entry from 2011.

Credit Points: 12.50
Level: 2 (Undergraduate)
Dates & Locations:

This subject is not offered in 2011.

Time Commitment: Contact Hours: 2 x one hour lectures per week; 1 x two hour workshop per week.
Total Time Commitment: Estimated total time commitment of 120 hours
Study Period Commencement:
Credit Points:
Corequisites: None
Recommended Background Knowledge: None
Non Allowed Subjects:
  • 433-351 Database Systems (prior to 2010)
  • 615-230 Database Concepts (prior to 2009)
Core Participation Requirements: For the purposes of considering request for Reasonable Adjustments under the Disability Standards for Education (Cwth 2005), and Students Experiencing Academic Disadvantage Policy, academic requirements for this subject are articulated in the Subject Description, Subject Objectives, Generic Skills and Assessment Requirements of this entry.
The University is dedicated to provide support to those with special requirements. Further details on the disability support scheme can be found at the Disability Liaison Unit website:


Subject Overview:

Contemporary online services such as social networking and multimedia sharing sites, massively multiplayer online games and commerce services are built on content management systems and underlying databases. In this subject, students will learn how to build their own domain-specific content management system, combining web technologies with database technologies.

Topics include:

  • collection, modelling and retrieval of information in databases;
  • query languages including SQL;
  • integration of databases with websites;
  • web interfaces;
  • data interchange using XML;
  • transactions;
  • and a selection of advanced topics in data management.

On completion of this subject students should be able to:

  • demonstrate proficiency in solving practical data modelling tasks;
  • design content management systems using relational database techniques;
  • use SQL to interact with a relational database;
  • develop a web-based database application;
  • understand transaction-based data processing.

Project work during semester, expected to take about 36 hours (30%); a mid-semester test (10%); and a 2-hour end-of-semester written examination (60%). To pass the subject, students must obtain at least 50% overall, 15/30 in project work, and 35/70 in the mid-semester test and end-of-semester written examination combined.

Prescribed Texts:
  • Silberschatz, Korth & Sudarshan, Database System Concepts 6th Ed, 2011
Breadth Options:

This subject potentially can be taken as a breadth subject component for the following courses:

You should visit learn more about breadth subjects and read the breadth requirements for your degree, and should discuss your choice with your student adviser, before deciding on your subjects.

Fees Information: Subject EFTSL, Level, Discipline & Census Date
Generic Skills:

On completion of this subject students should have developed the following generic skills:

  • the ability to analyse and solve problems involving large amounts of real-world data;
  • the ability to synthesise information and communicate results effectively;
  • the ability to work effectively as a member of a project team;
  • the capacity for critical and independent thought and reflection;
  • the ability to apply knowledge of basic science and engineering fundamentals;
  • the ability to undertake problem identification, formulation and solution.
Notes: This subject is available for science credit to students enrolled in the BSc (both pre-2008 and new degrees), BASc or a combined BSc course.
Related Course(s): Bachelor of Science
Diploma in Informatics
Related Majors/Minors/Specialisations: Science credit subjects* for pre-2008 BSc, BASc and combined degree science courses
Related Breadth Track(s): Information and the Web
Informatics A

Download PDF version.