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 AND INFORMATION SYSTEMS
Code COMP518
Coordinator Dr G Christodoulou
Computer Science
G.Christodoulou@liverpool.ac.uk
Year CATS Level Semester CATS Value
Session 2016-17 Level 7 FHEQ First Semester 15

Aims

To provide a deep, systematic and critical understanding of the nature of information systems and particularly database systems, including web technology for databases.


Learning Outcomes

At the end of the module students should have a critical understanding of the nature of relational databases.

At the end of the module students should be able to design and implement large-scale database systems.

At the end of the module students should be able to develop the ability to use SQL as a data definition and data manipulation language, and to develop a critical understanding of querying a relational database with SQL.

At the end of the module students should be able to develop a systematic understanding of transaction management and concurrency control in database systems.

Syllabus
1  1

DB and DBMS: Access and Oracle (1 lecture)

2

The relational model and relational algebra (2 lectures)

3 Database analysis and design techniques: ER models (6 lectures)
    1. Conceptual design Entity Relationship models (2 lectures)
    2. Logical design (2 lectures)
    3. Normal forms (2 lecture)
4 Transaction management (5 lectures)
    1. Transactions (2 lectures)
    2. Serializability, Atomicity (1 lecture)
    3. Concurrency control, Locking  (2 lectures)

5

SQL and its dialects (5 lectures)

6 Database connectivity (1 lectures)
    1. The JDBC environment

7

Web Technologies and DBMSs (2 lectures)


Teaching and Learning Strategies

Lecture -

Tutorial -


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

   22

       44
Timetable (if known)              
Private Study 106
TOTAL HOURS 150

Assessment
EXAM Duration Timing
(Semester)		 % of
final
mark		 Resit/resubmission
opportunity		 Penalty for late
submission		 Notes
Written Exam  60  Semester 1  25  Yes  Standard UoL penalty applies  Final Exam Notes (applying to all assessments) 3 assessment tasks This work is not marked anonymously. Written examination (multiple choice)  
CONTINUOUS Duration Timing
(Semester)		 % of
final
mark		 Resit/resubmission
opportunity		 Penalty for late
submission		 Notes
Coursework  48 hours for all CAs  Semester 1  25  Yes  Standard UoL penalty applies  Assessment 1 
Coursework  48 hours for all CAs  Semester 1  25  Yes  Standard UoL penalty applies  Assessment 2 
Coursework  48 hours for all CAs  Semester 1  25  Yes  Standard UoL penalty applies  Assessment 3 

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: