CMT220: Databases and Modelling
| School | Cardiff School of Computer Science and Informatics |
| Department Code | COMSC |
| Module Code | CMT220 |
| External Subject Code | 100366 |
| Number of Credits | 20 |
| Level | L7 |
| Language of Delivery | English |
| Module Leader | Professor Irena Spasic |
| Semester | Spring Semester |
| Academic Year | 2023/4 |
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
- Describe and evaluate the principles behind other types of database management systems, for example NoSQL
How the module will be delivered
This module will be delivered through a combination of lectures, supervised lab sessions, example classes and tutorials, as appropriate.
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) |
|---|---|---|---|
| Practical-Based Assessment | 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
JSON
NoSQL