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 CSIT815
Subject Name Data Management and Security
Credit Points 6
Pre-Requisites None.
Co-Requisites None.
Restrictions None.
Equivalence CSIT115
Assessment Practical works (10%) Assignments (30%) Final examination (60%)
General Subject Yes.

Subject Description
This subject investigates three major areas of modern data management systems: data modelling, data processing and data security. The goal of the subject is to learn the fundamental concepts in data management including conceptual modelling, the relational data model, processing of relational data with Structured Query Language (SQL), enforcing the concepts of data confidentiality, integrity, and availability data management systems. The subject develops the skills in the design, implementation, processing, and security of data management systems. The subject covers the following topics in data security: discretionary access controls, user management, enforcing data security and integrity. The subject also explains the important ethical issues associated with responsible disclosure, responsibility, liability, security weaknesses, and privacy in data management systems.

Subject Learning Outcomes
On successful completion of this subject, students will be able to:
1. Summarise the principles of fundamental data management concepts, data models, and roles of typical components of data management systems.
2. Summarise the role of conceptual modelling in the process of database design.
3. Design and build relational databases using conceptual modelling techniques and the principles of relational data modelling.
4. Design and create data processing tasks using the relational database programming language, SQL.
5. Summarise the principles of confidentiality, integrity, and availability in the context of data management systems.
6. Analyse the theory of risks, threats, vulnerabilities and attack vectors to protect data management systems from security threats.
7. Adapt the principles of trust, trustworthiness, responsible disclosure, responsibility, liability, security weaknesses, and privacy in data management systems to secure data.