Module Catalogues, Xi'an Jiaotong-Liverpool University   
Module Code: CSE103
Module Title: Introduction to Databases
Module Level: Level 1
Module Credits: 5.00
Academic Year: 2019/20
Semester: SEM1/SEM2
Originating Department: Computer Science and Software Engineering
Pre-requisites: N/A
To establish an understanding of Information Systems, encourage the appropriate and efficient design and usage of Information Systems, to provide insight into the design process and social implications of Information Systems, to enable the use of Information Systems in a programming environment.
Learning outcomes 
1. Have a basic understanding of the design of databases;

2. Have a fundamental grounding in the operation and usage of database management systems including "hands-on" experience of a basic database management system;

3. Have in-depth knowledge of the database language, SQL;

4. Understand the processes and legal implications of creating and maintaining information systems.

Method of teaching and learning 
Students will be expected to attend two hours of formal lectures as well as to participate in two hours of practicals in a computer lab in a typical week. Lectures will introduce students to the academic content and practical skills which are the subject of the module, while computer practicals will allow students to practice those skills. Case studies are presented illustrating the effective use and design of databases.
In addition, students will be expected to devote seven hours of unsupervised time to solving continuous assessment tasks and private study. Private study will provide time 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, in particular, assessment tasks will be solved individually and each solution comprises the resolution, using sound software engineering techniques, of the given problems expressed in terms of a requirements statement. A written examination at the end of the module will assess the academic achievement of students.
1. Introduction to Database Systems (4 lectures);
2. Database Development Lifecycle: Conceptual Design, Logical Design and Physical Design (10 lectures);
3. SQL: DDL, DCL, DML (8 lectures);
4. Relational Algebra (2 lectures);
5. Different DBMS Environments (2 lectures);
6. Legal Frameworks (2 lectures).
Delivery Hours  
Lectures Seminars Tutorials Lab/Prcaticals Fieldwork / Placement Other(Private study) Total
Hours/Semester 26       26    98  150 


Sequence Method % of Final Mark
1 Assessment1 60.00
2 Assessment2 10.00
3 Assessment3 15.00
4 Assessment4 15.00

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