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 CSCI835
Subject Name Database Systems
Credit Points 6
Pre-Requisites Nil
Co-Requisites None.
Restrictions ITCS904, CSCI235, MCS9235
Equivalence None.
Assessment Assignments 10%; Laboratory Tasks 30%; Final examination 60%.
General Subject Yes.

Subject Description
The subject presents more advanced topics in the modern relational database technology and it introduces the new non-relational (NoSQL) database technologies. The relational database technology component of the subject includes database design with meta modelling and spatio-temporal modelling, database normalization, advanced programming in SQL and programming of database server with stored PL/SQL procedures, functions, and triggers, concurrency control and database recovery techniques, design and programming of distributed database systems. The non-relational (NoSQL) database technology component of the subject includes the key-value data model, document-oriented model, column-family stores, graph data model, and new approaches to data distribution, consistency preserving, and transaction processing.

Subject Learning Outcomes
On successful completion of this subject, students will be able to:
1. Design and create extendable and spatio-temporal relational databases using advanced conceptual modelling techniques .
2. Adapt a theory of relational database normalization to prove the correctness of relational database designs.
3. Design and create stored procedures, stored functions and database triggers in advanced SQL and in PL/SQL.
4. Design and create effective database transaction based on the principles of transaction processing and theory of concurrency in database systems.
5. Summarise the principles of distributed database systems, design and create distributed relational databases.
6. Summarise the principles of modern non-relational (NoSQL) database technologies, design and create key-value and document oriented database systems.
7. Adapt the principles of distributed and clustered computing systems to design and to create more effective database applications.