ULMS Electronic Module Catalogue

The information contained in this module specification was correct at the time of publication but may be subject to change, either during the session because of unforeseen circumstances, or following review of the module at the end of the session. Queries about the module should be directed to the member of staff with responsibility for the module.
Title Database Management
Code ACFI232
Coordinator Dr D Li
Operations and Supply Chain Management
Dongli@liverpool.ac.uk
Year CATS Level Semester CATS Value
Session 2024-25 Level 5 FHEQ First Semester 15

Pre-requisites before taking this module (other modules and/or general educational/academic requirements):

ACFI130 Data Analytics; ACFI132 Computational Methods 

Modules for which this module is a pre-requisite:

 

Programme(s) (including Year of Study) to which this module is available on a required basis:

 

Programme(s) (including Year of Study) to which this module is available on an optional basis:

 

Teaching Schedule

  Lectures Seminars Tutorials Lab Practicals Fieldwork Placement Other TOTAL
Study Hours 24

12

        36
Timetable (if known)              
Private Study 114
TOTAL HOURS 150

Assessment

EXAM Duration Timing
(Semester)
% of
final
mark
Resit/resubmission
opportunity
Penalty for late
submission
Notes
             
CONTINUOUS Duration Timing
(Semester)
% of
final
mark
Resit/resubmission
opportunity
Penalty for late
submission
Notes
Assessment 1: Group Project Assessment Type: Coursework Weighting: 50 % Size: 1,500 Words Reassessment Opportunity: Yes Penalty for Late Submission: Standard UoL Penalty Applies Anonymous Assess    50       
Assessment 2: Individual Project Assessment Type: Coursework Weighting: 50 % Size: 1,500 words Reassessment Opportunity: Yes Penalty for Late Submission: Standard UoL Penalty Applies Anonymous A    50       

Aims

The aim of this module is to equip students with the knowledge and skills necessary to use database management systems and ensure data security in financial services. Upon successful completion of this module, the students will be able to use SQL to read, manage, join, and create datasets/databases and learn approaches related to data security for several financial applications.


Learning Outcomes

(LO1) Students will be able to discuss the importance of database management systems

(LO2) Students will be able to apply their knowledge of database management system to address a business problem

(LO3) Students will be able to produce a set of recommendations based on the results of the analysis

(S1) Communication

(S2) IT Literacy

(S3) Lifelong Learning

(S4) Numeracy

(S5) Problem Solving

(S6) Organisation

(S7) Leadership


Teaching and Learning Strategies

Teaching Method - Lectures
Description: Lecture (12 Lectures of 2 hours each)
Scheduled Directed Student Hours: 24 hours
Attendance Recorded: Yes
Students will attend the weekly 2 hours lecture during which the key concepts will be introduced.

Teaching Method – Seminar (6 seminars of 2 hours each)
Description: Face to face sessions
Scheduled Directed Student Hours: 12 hours
Attendance Recorded: Yes
The seminar will take place over 6 weeks. During these sessions, students will learn to design databases and use database management system to read, analyse, and write data.

Self-Directed Learning Hours: 114 hours
Description: These independent learning hours are aimed at supporting the directed student learning. The module leader will provide guidance in the form of suggested readings or topics to complete with the expectation that students are well prepared to contribute to the tutorial activities and to understand the content of le ctures.

This module is a pre-requisite for the following modules:
ACFI331 Data Mining and Machine Learning

Skills/Other Attributes Mapping

Skills / attributes: Communication
How this is developed: By contributing to in-class discussions (lectures and seminars), and by preparing the project reports.
Mode of assessment (if applicable): Group and individual projects

Skills / attributes: IT Literacy
How this is developed: By developing database management skills in SQL in lectures and seminars. The students will also use digital tools and specialist software to engage with the course material, to collaborate and communicate.
Mode of assessment (if applicable): Group and individual projects

Skills / attributes: Lifelong Learning
How this is developed: In lectures and seminars by critically thinking about the way to structure databases and how to manage databases.
Mode of assessment (if applicable): Group and individual projects

Skills / attributes: Numeracy
How this is developed: During the lectures & seminars, the students will be writing computer codes to manage databases and analyse the extracted datasets.
Mode of assessment (if applicable): Group and individual projects

Skills / attributes: Problem solving
How this is developed: During the lectures & seminars, the students will gather and synthesise information, compare different approaches to solve problems, and use their knowledge of programming tools to arrive at a recommendation.
Mode of assessment (if applicable): Group and individual projects

Skills / attributes: Organization
How this is developed: In lectures & seminars, the students will learn to manage their time carefully by prioritising and completing tasks within specific deadlines. They will also develop their organization skills by working on group and individual projects.
Mode of assessment (if applicable): Group and individual projects< /p>

Skills / attributes: Leadership
How this is developed: During the lectures & seminars, the students will have the opportunity to lead team activities. For instance, they will have the opportunity to plan the tasks, identify the resources needed to complete the task, monitor the progress of the group and review the plan if needed.
Mode of assessment (if applicable): Group project


Syllabus

 

The module outline:
• Organisational Information Management Systems and data management
• Introduction to database management systems
• Design of databases to organise organisational data into a database
• Pulling, filtering and managing datasets
• Joining tables and other manipulations (add, subtract, multiple, concatenate)
• Queries in database management systems
• Data security and applications
• Accessing databases using programming tools


Recommended Texts

Reading lists are managed at readinglists.liverpool.ac.uk. Click here to access the reading lists for this module.