|Module Name||Information Management II|
|ECTS Weighting ||5 ECTS|
|Semester Taught||Semester 2|
|Module Coordinator/s||Prof Vincent Wade; 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.
- 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 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 (3 hours, online).||LO1, LO2, LO3, LO4, LO5, L6, LO7||75%||N/A||N/A|
Online Exam (3 hours).
Contact Hours and Indicative Student Workload
|Contact Hours (scheduled hours per student over full module), broken down by:||33 hours|
|Tutorial or seminar||11 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).
Prerequisite modules: N/A
Other/alternative non-module prerequisites: N/A