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
- Illustrate basic database concepts and systems architecture
- Understand the representational and processing power of the relational DBMS
- Explain the process of and the issues involved in database design and implementation
- Show a basic understanding of database transaction management
- Design a relational database system logically and physically
- 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)