Module Details

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 DEVELOPMENT
Code COMP207
Coordinator Dr R Ibsen-Jensen
Computer Science
R.Ibsen-Jensen@liverpool.ac.uk
Year CATS Level Semester CATS Value
Session 2020-21 Level 5 FHEQ First Semester 15

Aims

To introduce students to
- the problems arising from databases, including concurrency in databases, information security considerations and how they are solved;
- the problems arising from the integration of heterogeneous sources of information and the use of semi-structured data;
- non-relational databases and the economic factors involved in their selection;
- techniques for analysing large amounts of data, the security issues and commercial factors involved with them.


Learning Outcomes

(LO1) Demonstrate an understanding of basic and advanced SQL topics;

(LO2) At the end of this module the student will be able to identify and apply the principles underpinning transaction management within DBMS and the main security issues involved in securing transaction;

(LO3) Illustrate the issues related to Web technologies as a semi-structured data representation formalism;

(LO4) Interpret the main concepts and security aspects in data warehousing, and the concepts of data mining and commercial considerations involved in adopting the paradigm.

(S1) Problem Solving - Numeracy and computational skills

(S2) Problem solving – Analysing facts and situations and applying creative thinking to develop appropriate solutions.


Syllabus

 

Basic and advanced SQL topics (5 lectures): SELECT, INSERT, DELETE, indexes and materialised view;
Transactions/concurrency in databases (9 lectures): Transaction management, recoverability and security;
Query optimisation (5 lectures): Relational Algebra Transaction management;
Distributed databases (3 lectures): Models and security issues;
Web technologies and DBMS (5 lectures): Semistructured databases and connectivity;
Data warehousing and data mining (3 lectures): Platforms, security and commercial aspects.


Teaching and Learning Strategies

Teaching Method 1 - Lecture
Description:
Attendance Recorded: Not yet decided

Teaching Method 2 - Tutorial
Description:
Attendance Recorded: Not yet decided

Teaching Method 3 - Laboratory Work
Description:
Attendance Recorded: Not yet decided

Due to Covid-19, in 2020/21, one or more of the following delivery methods will be implemented based on the current local conditions.
(a) Hybrid delivery, with social distancing on Campus
Teaching Method 1 - Lecture
Description: On-line asynchronous lectures
Teaching Method 2 – Tutorial / Laboratory Work
Description: On-line synchronous/asynchronous sessions

(b) Fully online delivery and assessment
Teaching Method 1 - Lecture
Description: On-line asynchronous lectures
Teaching Method 2 - Tutorial / Laboratory Work
Description: On-line synchronous/asynchronous sessions

(c) Standard on-campus delivery with minimal social distancing
As our plann ing has already gone too far, even if the campus opens up, we will offer hybrid teaching
Teaching Method 1 - Lecture
Description: On-line asynchronous lectures
Teaching Method 2 - Tutorial / Laboratory Work
Description: On-line synchronous/asynchronous sessions


Teaching Schedule

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

  5

5

    40
Timetable (if known)              
Private Study 110
TOTAL HOURS 150

Assessment

EXAM Duration Timing
(Semester)
% of
final
mark
Resit/resubmission
opportunity
Penalty for late
submission
Notes
(207) Written Exam There is a resit opportunity. Standard UoL penalty applies for late submission. This is an anonymous assessment. Assessment Schedule (When) :Semester 1  120 minutes.    70       
CONTINUOUS Duration Timing
(Semester)
% of
final
mark
Resit/resubmission
opportunity
Penalty for late
submission
Notes
(207.2) Assessment 2 There is a resit opportunity. Standard UoL penalty applies for late submission. This is not an anonymous assessment. Assessment Schedule (When) :1  25 hours for all CA    15       
(207.1) Assessment 1 There is a resit opportunity. Standard UoL penalty applies for late submission. This is not an anonymous assessment. Assessment Schedule (When) :1  25 hours for all CA    15       

Recommended Texts

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