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 APPLIED DATABASE MANAGEMENT
Code COMP283
Coordinator Mr P Jimmieson
Computer Science
Phil@liverpool.ac.uk
Year CATS Level Semester CATS Value
Session 2016-17 Level 5 FHEQ Second Semester 7.5

Aims
  1. To utilise Relational Algebra to develop efficient Database Query Language code.
  2. To provide practical experience of designing relational databases;
  3. To provide the skills to manage and maintain a database system using commercial Database Management Systems such as Microsoft SQL Server.
  4. To introduce the skills required to maintain data integrity and durability across database systems.

Learning Outcomes

Design and structure an efficient scalable database system.

Implement and configure a database system.

Maintain a secure and durable database.
Describe, illustrate and explain the concept of linked databases and data migration technique.

Syllabus
1 
  • Introduction to Relational Algebra and Database Management Systems (2 Lectures, 2 Practicals)
  • Introduction to Design and Implementation of Relational Databases (3 Lectures, 3 Practicals)
  • Database Administration Concepts (4 Lectures, 4 Practicals)
  • Introduction to Inter-database connectivity and data warehousing (2 Lectures, 1 Practical)

Teaching and Learning Strategies

Lecture -

Laboratory Work -


Teaching Schedule
  Lectures Seminars Tutorials Lab Practicals Fieldwork Placement Other TOTAL
Study Hours 10

     10

     20
Timetable (if known)              
Private Study 55
TOTAL HOURS 75

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
Coursework  30 hours expected fo  Semester 2  25  Yes  Standard UoL penalty applies  Assessment 1 
Coursework  30 hours expected fo  Semester 2  25  Yes  Standard UoL penalty applies  Assessment 2 
Coursework  30 hours expected fo  Semester 2  25  No reassessment opportunity  Standard UoL penalty applies  Assessment 3 There is no reassessment opportunity, Lab based resit exam will replace CA components, the Learning Outcomes will be covered in the resit exam. 
Coursework  30 hours expected fo  Semester 2  25  Yes  Standard UoL penalty applies  Assessment 4 Notes (applying to all assessments) 4 (sets of) assessment tasks This work is not marked anonymously. Resit-arrangements: A single problem sheet to be solved in a three hour session, incorporating practical tasks and preparing a short report, replaces all four assessment tasks. The session will take place in the departmental lab. Students are not allowed network access but can make use of notes and textbooks during the session. The session will take place during the re-sit period and is scheduled by SAS. This lab based resit exam will replace CA components, the Learning Outcomes will be covered in the resit exam.  

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: