| Module Code | CSU34041 |
| Module Name | Information Management II |
| ECTS Weighting [1] | 5 ECTS |
| Semester Taught | Semester 2 |
| Module Coordinator/s | Yvette Graham |
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.
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 Component | Brief Description | Learning Outcomes Addressed | % of Total | Week Set | Week Due |
| Project & Online (SQL) Coursework | Submission of the design and SQL implementation of a database. Online assessment as part of an Online SQL course. | LO1, LO2, LO3, LO7 | 25% | Week 3 | Week 9 |
| Exam Paper | Examination Paper (2 hours, in person). | LO1, LO2, LO3, LO4, LO5, L6, LO7 | 75% | 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 |
| 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 |
| Completion of online SQL course, online assessments activities, project development and submission | 50 hours |
| Total Hours | 119 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