CSU34041 – Information Management II

Module CodeCSU34041
Module Name Information Management II
ECTS Weighting [1]5 ECTS
Semester TaughtSemester 2
Module Coordinator/s  Prof Vincent Wade; Yvette Graham

Module Learning Outcomes

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

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

Module Content

  • 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 and Learning Methods

Teaching is a combination of lectures and tutorials. There are three lectures or tutorial in 1 hour slots per week over 12 weeks.

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

A purpose built online SQL course is used as a means of teaching SQL. Students are expected to submit a single project, developed during the semester, as coursework for the module. This project consists of information modelling, database design and database implementation.

Assessment Details

Assessment ComponentBrief Description Learning Outcomes Addressed% of TotalWeek SetWeek Due
Project & Online (SQL) CourseworkSubmission of the design and SQL implementation of a database. Online assessment as part of an Online SQL course.LO1, LO2, LO3, LO725%Week 3Week 9
Exam PaperExamination Paper (2 hours, in person).LO1, LO2, LO3, LO4, LO5, L6, LO775%N/A N/A

Reassessment Details

In person Exam (2 hours).

Contact Hours and Indicative Student Workload

Contact Hours (scheduled hours per student over full module), broken down by: 33 hours
Lecture22 hours
Laboratory0 hours
Tutorial or seminar11 hours
Other0 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
Completion of online SQL course, online assessments activities, project development and submission50 hours
Total Hours119 hours

Recommended Reading List

  • Fundamentals of Database Systems by Elmasri & Navathe (7th edition).

Module Pre-requisites

Prerequisite modules: N/A

Other/alternative non-module prerequisites: N/A

Module Co-requisites

N/A

Module Website

Blackboard

[1] TEP Glossary

[2] TEP Guidelines on Workload and Assessment