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/ Dr Yvette Graham

Module Learning Outcomes

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

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

Module Content

  1. Introduction to Databases
  2. Database Architectures 
  3. Database Models
  4. Relational Algebra for Data Management
  5. Designing Databases: Functional Dependency
  6. Designing Databases: The Entity Relationship (ER) Modelling
  7. Designing Databases: Mapping from ER to Relational Table
  8. Representing constraints and semantics in RDBMSs
  9. Concurrency Control in Database
  10. Security and Access Control in Databases
  11. General Data Protection Regulations for Information Management. Ethical Data Management.
  12. 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 A single project, developed during the semester, is the 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) course workSubmission of the design and SQL implementation of a database. Online assessment as part of an Online SQL courseLO1, LO2, LO3, LO72539
Exam PaperExamination Paper (3 hours online)LO1, LO2, LO3, LO4, LO5, L6, LO775n/an/a

Reassessment Details

Online Exam (3 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 applicable36 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: NONE

Other/alternative non-module prerequisites:

Module Co-requisites

NONE

Module Website

Blackboard

[1] TEP Glossary

[2] TEP Guidelines on Workload and Assessment