Subject Descriptions - Subject Information

Calendar: 2017 Postgraduate
Faculty: Faculty of Engineering and Information Sciences
Department: School of Computing and Information Technology

Subject Information
Subject Code MCS9235
Subject Name Database Systems
Credit Points 6
Pre-Requisites Nil
Co-Requisites None.
Restrictions None.
Equivalence None.
Assessment 1.Assignments- 25% 2. Class tests - 15% 3. Final examination- 60%
General Subject No.
EFTSL (Non Weighted) 0.125
Non Weighted Student Contribution Amounts
Commonwealth Supported (HECS) Students Only
Pre-1997 Pre-2005 Post-2005 Post-2008 Post-2009 Post-2010
$ 1131  $ 1131  $ 1131  $ 1131  $ 1131  $ 1131 
Weighted Student Contribution Amounts  
Work Experience No
Tutorial Enrolment Information Students should use the SMP OnLine Tutorial System (via SOLS) to enrol in Tutorial/laboratory groups for this subject. Once enrolments are open a link to the subject will appear in Tutorial Enrolments.
Availability Not Available in 2017

Subject Description
This subject investigates the major areas of modern database systems: 1. Design and programming of relational databases 2. Design and programming of semistructured databases (XML native database systems) 3. Design and programming of distributed database systems (NoSQL database systems) 4. Concurrency control and data recovery in database systems. The following topics are included: Introduction to conceptual modelling; Principles of relational database model; Processing relational databases with Structured Query Language (SQL) and its procedural extension (PL/SQL); Principles of semistructured database model; Processing of semistructured databases with XQuery and XPath; Design and implementation of distributed database systems; Normalisation of relational databases; Transaction management and recovery in database systems.

Subject Learning Outcomes
On successful completion of this subject, students will be able to:
1. Explain the principles of relational database model.
2. Design and implement a simple relational database.
3. Use relational database programming language SQL and its procedural extension PL/SQL.
4. Design and implement a simple semistructured database.
5. Use semistructured database programming languages XQuery and XPath.
6. Normalise a relational database.
7. Explain the principles of distributed databases.
8. Design a distributed database.
9. Implemented distributed NoSQL database system.
10. Explain the principles of transaction management and database recovery.

Textbook Information

Text book information is available via the UniShop website:

Search Criteria [Click here for help]
Subject Code / Name
Delivery Method
General Subjects