CM2102: Database Systems

School Cardiff School of Computer Science and Informatics
Department Code COMSC
Module Code CM2102
External Subject Code 100754
Number of Credits 10
Level L5
Language of Delivery English
Module Leader Dr Jianhua Shao
Semester Autumn Semester
Academic Year 2022/3

Outline Description of Module

This module aims to provide students with a basic understanding of database system technology in general, and a theoretical and practical knowledge of relational database systems in particular. It seeks to equip the students with the skills to design and implement a database system.

On completion of the module a student should be able to

  1. Illustrate basic database concepts and systems architecture
  2. Understand the representational and processing power of the relational DBMS
  3. Explain the process of and the issues involved in database design and implementation
  4. Show a basic understanding of database transaction management
  5. Design a relational database system logically and physically
  6. Develop relational database queries using Structured Query Language (SQL)

How the module will be delivered

Modules will be delivered through blended learning. You will be guided through learning activities appropriate to your module, which may include:

  • on-line resources that you work through at your own pace (e.g. videos, web resources, e-books, quizzes),
  • on-line interactive sessions to work with other students and staff (e.g. discussions, live streaming of presentations, live-coding, team meetings)
  • face to face small group sessions (e.g. help classes, feedback sessions)

Skills that will be practised and developed

Design a relational database system logically and physically

Develop a relational database queries using SQL

 

How the module will be assessed

A blend of assessment types which may include coursework and portfolio assessments, class tests, and/or formal examinations

Students will be provided with reassessment opportunities in line with University regulations.

Assessment Breakdown

Type % Title Duration(hrs)
Exam online – Autumn semester 100 Database Systems 23

Syllabus content

Introduction to database systems:

Basic database concepts and architecture

The relational data model:

Data representation

Relational algebra

Database design:

Logical design (mapping, functional dependency, normalisation)

Physical design (data types and constraints, index, performance issues)

Database implementation using SQL:

Table creation in SQL

Data manipulation in SQL

Introduction to database transaction management:

Database recovery

Concurrency control

Deadlock and resolutions

Database Security (guest lecture)


Copyright Cardiff University. Registered charity no. 1136855