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 2019-20 Level 5 FHEQ First Semester 15

Aims

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

Learning Outcomes

(LO1) 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;

(LO2) Demonstrate an understanding of advanced SQL topics;

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

(LO4) Identify the principles underlying object relational models and the economic factors in their uptake and development;

(LO5) 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
 

Advanced SQL topics (2 lectures): Triggers, indexes and materialised view
Query optimisation (3 lectures): Relational Algebra Transaction management (9 lectures): Transaction management, recoverability and security
Object relational databases (3 lectures): Structure and economic factors in their deployment
Distributed databases (3 lectures): Models and security issues
Web technologies and DBMS (6 lectures): Semistructured databases and connectivity
Data warehousing and data mining (4 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

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
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.    80       
CONTINUOUS Duration Timing
(Semester)		 % of
final
mark		 Resit/resubmission
opportunity		 Penalty for late
submission		 Notes
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    10       
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    10       

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