1 x 120-minute lecture weekly
1 x 50-minute tutorial weekly
1 x 50-minute workshop weekly
1 x 180-minute project work weekly
1 1 of COMP2761, COMP1711
2 1 of COMP2731, COMP1712
Must Satisfy: (1 and 2)
Enrolment not permitted
1 of COMP8771, COMP9771 has been successfully completed
Topic description
Advanced database techniques and concepts including: advanced normalisation, monitoring and tuning database systems, query optimisation, professional, legal and ethical issues, distributed DBMSs and Object DBMSs and current topics in database research.
Educational aims
This topic introduces students to advanced techniques and concepts of database design and implementation, legal and ethical issues of databases and selected topics in database research.
Expected learning outcomes
At the completion of this topic, students are expected to be able to:

  1. Design and develop a complex database for a given scenario, with a professional approach to the documentation of the system
  2. Construct SQL programs using advanced features to ensure efficient processing
  3. Detect and evaluate various key issues which affect database systems and their performance
  4. Compare and contrast approaches for improving a database's performance
  5. Critically review a selection of emerging database technologies