CSU34041 – Information Management II

Module Learning Outcomes

On successful completion of this module, students will be able to:

Design and Evaluate information Models (using Entity relationship Modelling Techniques) for representation and storage in a Relational Database;
Perform Data Normalization in Relational DBMSs and analyze data dependencies;
Apply and program in SQL to create, query and manage Relational Databases;
Analyze transaction properties and transaction scheduling techniques (lock based and timestamp based);
Identify and Assess different forms of database and data management systems (e.g. NoSQL etc.);
Comprehend and Identify implications of General Data Protection Regulations (GDPR) as they apply to database information;
Identify and Apply different privacy and security policies within relational database.

Introduction to Databases;
Database Architectures;
Database Models;
Relational Algebra for Data Management;
Designing Databases: Functional Dependency;
Designing Databases: The Entity Relationship (ER) Modelling;
Designing Databases: Mapping from ER to Relational Table;
Representing constraints and semantics in RDBMSs;
Concurrency Control in Database;
Security and Access Control in Databases;
General Data Protection Regulations for Information Management. Ethical Data Management;
Non Relational Databases, e.g. NoSQL.

Teaching is a combination of lectures and tutorials. There are three hours of lectures or tutorial per week over 12 weeks.

Tutorial style interaction is held within each lecture and typically a dedicated tutorial is held once every two weeks.

Quizes are used in class for continuous assessment to gauge progress in terms of both general module content and SQL.

Assessment Component	Brief Description	Learning Outcomes Addressed	% of Total	Week Set	Week Due
In class tests	In class tests are used to gauge progress throughout the course.	LO1, LO2, LO3, LO4, LO5, LO6, LO7	10%	N/A	N/A
Exam Paper	Examination Paper (2 hours, in person).	LO1, LO2, LO3, LO4, LO5, L6, LO7	90%	N/A	N/A

In person Exam (2 hours).

Contact Hours (scheduled hours per student over full module), broken down by:	33 hours
Lecture	22 hours
Laboratory	0 hours
Tutorial or seminar	11 hours
Other	0 hours
Independent Study (outside scheduled contact hours), broken down by:	86 hours
Preparation for classes and review of material (including preparation for examination, if applicable)	36 hours
Independent study including SQL.	50 hours
Total Hours	119 hours

Prerequisite modules: N/A

Other/alternative non-module prerequisites: N/A