Module Catalogues, Xi'an Jiaotong-Liverpool University   
Module Code: CSE201
Module Title: Database Development and Design
Module Level: Level 2
Module Credits: 5.00
Academic Year: 2019/20
Semester: SEM1
Originating Department: Computer Science and Software Engineering
Pre-requisites: CSE103
• To introduce students to the problems arising from concurrency in databases, 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;
• To introduce students to techniques for analyzing large amounts of data.
Learning outcomes 
At the conclusion of this module students should be able to

• identify and apply the principles underpinning transaction management within DBMS;

• demonstrate an understanding of advanced SQL topics;

• illustrate the issues related to Web technologies and DBMS and XML as a semi-structured data representation formalism;

• identify the principles underlying object relational models;

• state the main concepts in data warehousing and data mining.
Method of teaching and learning 
Students will be expected to attend three hours of formal lectures as well as to participate in one hour of supervised practical classes in a typical week. In addition, students will be expected to devote six hours of unsupervised time for reflection and consideration of lecture material and background reading.
1. Advanced SQL: Triggers, Indexes (3 lectures);
2. Query Optimization (12 lectures);
3. Transaction Management (12 lectures);
4. Object Relational Databases (3 lectures);
5. Distributed Databases (3 lectures);
6. Web Technologies & DBMS (3 lectures);
7. Data Warehousing and Data Mining (6 lectures).
Delivery Hours  
Lectures Seminars Tutorials Lab/Prcaticals Fieldwork / Placement Other(Private study) Total
Hours/Semester 39       13    98  150 


Sequence Method % of Final Mark
1 Written Examination 80.00
2 Assessment Task 10.00
3 Assessment Task 10.00

Module Catalogue generated from SITS CUT-OFF: 5/30/2020 2:40:29 AM