CMT220: Databases and Modelling
| School | Cardiff School of Computer Science and Informatics |
| Department Code | COMSC |
| Module Code | CMT220 |
| External Subject Code | 100754 |
| Number of Credits | 20 |
| Level | L7 |
| Language of Delivery | English |
| Module Leader | Professor Irena Spasic |
| Semester | Spring Semester |
| Academic Year | 2024/5 |
Outline Description of Module
Database systems are the most widely used software systems in commerce and industry. Database management systems are used to store and manage the complex integrated information resources of organisations. This module introduces the theoretical and practical issues relating to the design and use of these systems. In addition to the provision of a sound foundation in traditional, second generation database systems, it explores the representation and management of complex information resources with NoSQL database technology.
On completion of the module a student should be able to
- Design a relational database, i.e. map conceptual models to efficient representations in a database schema
- Manage relational database systems
- Use SQL to define and query a relational database
- Discuss and evaluate the principles of data integrity, security and concurrency control
- Model and manage information using markup languages
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
Understanding the role of information in decision making
Designing relational databases (including conceptual design, logical design, physical design)
Evaluation of issues concerning database applications, including security and data integrity
Modelling information using markup languages (XML and JSON)
Awareness of the differences between relational and NoSQL databases
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) |
|---|---|---|---|
| Class Test | 50 | Timed Practical Implementation | N/A |
| Exam online – Spring semester | 50 | Databases And Modelling | 2 |
Syllabus content
Introduction to databases
Information, data and knowledge
Database systems
Relational data model
Structured Query Language (SQL)
Relational algebra
Database design
Conceptual database design (ER diagrams)
Logical database design (ER to SQL)
Physical database design (indexes)
Security, transactions and concurrency
Security and integrity
Transactions and recovery
Concurrency control
Markup languages and NoSQL databases
XML, XPath and XQuery