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 A Hernich
Computer Science
Andre.Hernich@liverpool.ac.uk
Year CATS Level Semester CATS Value
Session 2017-18 Level 5 FHEQ First Semester 15

Aims

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

Learning Outcomes

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;

Demonstrate an understanding of advanced SQL topics;

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

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

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


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

Lecture -

Tutorial -

Laboratory Work -


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
Unseen Written Exam  120  Semester 1  80  Yes  Standard UoL penalty applies  Written Exam Notes (applying to all assessments) This CA work is not marked anonymously. Practical assessment is employed for both formative assessment and summative assessment. Students will get short formative feedback on a weekly basis from the module demonstrators during tutorial / lab sessions. More detailed summative and formative feedback will be returned following assessment of the continuously assessed (CA) work. Resit exam will replace failed CA components, the Learning Outcomes will be covered in the resit exam.  
CONTINUOUS Duration Timing
(Semester)
% of
final
mark
Resit/resubmission
opportunity
Penalty for late
submission
Notes
Coursework  25 hours for all CA  10  Yes  Standard UoL penalty applies  Assessment 1 
Coursework  25 hours for all CA  10  Yes  Standard UoL penalty applies  Assessment 2 

Recommended Texts

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