Module Specification
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.
1. Module Title Database Development
2. Module Code COMP207
3. Year Session 2023-24
4. Originating Department Computer Science
5. Faculty Fac of Science & Engineering
6. Semester First Semester
7. CATS Level Level 5 FHEQ
8. CATS Value 15
9. Member of staff with responsibility for the module
Dr R Ibsen-Jensen Computer Science R.Ibsen-Jensen@liverpool.ac.uk
10. Module Moderator
11. Other Contributing Departments  
12. Other Staff Teaching on this Module
Mrs J Birtall School of Electrical Engineering, Electronics and Computer Science Judith.Birtall@liverpool.ac.uk
Dr U Hustadt Computer Science U.Hustadt@liverpool.ac.uk
13. Board of Studies
14. Mode of Delivery
15. Location Main Liverpool City Campus
    Lectures Seminars Tutorials Lab Practicals Fieldwork Placement Other TOTAL
16. Study Hours 30

   5

 5

     40
17.

Private Study

 110
18.

TOTAL HOURS

 150
 
    Lectures Seminars Tutorials Lab Practicals Fieldwork Placement Other
19. Timetable (if known)            
 
20. Pre-requisites before taking this module (other modules and/or general educational/academic requirements):

 
21. Modules for which this module is a pre-requisite:

 
22. Co-requisite modules:

 
23. Linked Modules:

 
24. Programme(s) (including Year of Study) to which this module is available on a mandatory basis:
25. Programme(s) (including Year of Study) to which this module is available on a required basis:
26. Programme(s) (including Year of Study) to which this module is available on an optional basis:
27. 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.
 
28. 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.
 
29. 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

Hybrid delivery
Teaching Method 1 - Videos
Description: 1 hour of videos per week
Teaching Method 2 - Lecture
Description: 2 hours of on-campus lectures
 
30. 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.
 
31. Recommended Texts
  Reading lists are managed at readinglists.liverpool.ac.uk. Click here to access the reading lists for this module.
 

Assessment
32. 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 60
33. CONTINUOUS Duration Timing
(Semester)		 % of
final
mark		 Resit/resubmission
opportunity		 Penalty for late
submission		 Notes
  (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 0 25
  (207.2) Weekly Assessments There is a resit opportunity. Standard UoL penalty applies for late submission. This is not an anonymous assessment. Assessment Schedule (When) :1 0 15