Module Catalogues, Xi'an Jiaotong-Liverpool University   
Module Code: CSE415
Module Title: Databases and Data Management
Module Level: Level 4
Module Credits: 5.00
Academic Year: 2019/20
Semester: SEM1
Originating Department: Computer Science and Software Engineering
Pre-requisites: N/A
This module provides a comprehensive and systematic study of the nature of information systems and particularly database systems, including current web technology for databases, aiming to achieve a critical and in-depth understanding of these systems.

The knowledge and techniques covered are essential to MSc Business Analytics and MSc Financial Computing.
Learning outcomes 
A Gain a critical understanding of the nature of relational databases;

B Critically evaluate, design and implement database systems;

C Show expertise in the use of state-of-the-art web technologies for databases and database connectivity.

Method of teaching and learning 
Students are expected to attend a two-hour formal lecture and a two-hour tutorial or lab session in a typical week. Examples will be provided to illustrate the effective use and design of databases. Students are expected to devote 6-7 hours per week of unsupervised learning for reflection and consideration of lecture material and background reading. Continuous assessment will be used to test to what extent practical skills have been learnt. A written examination at the end of the module will assess the academic achievement of the students.
Week 1 DB and DBMS

Weeks 2-3 The relational model, including relational algebra

Weeks 4-6 Database analysis and design techniques: entity relationship modelling (ERM); enhanced ERM; normalisation including functional dependencies

Weeks 7-8 Transaction management: concurrency control; database recovery

Weeks 9-10 SQL: definition; manipulation; administration

Week 11 Web technology and DBMSs, including SQLJ and JDBC

Week 12 Semistructured data and XML

Week 13 Revision

Delivery Hours  
Lectures Seminars Tutorials Lab/Prcaticals Fieldwork / Placement Other(Private study) Total
Hours/Semester 26      2    98  150 


Sequence Method % of Final Mark
1 Written Report (750-1250 Words) 10.00
2 Written Report (1000-1500 Words) 15.00
3 Project 15.00
4 Written 60.00

Module Catalogue generated from SITS CUT-OFF: 8/10/2020 4:13:45 AM