4CCS1DBS Database Systems
Lecturers: Dr Sophia Tsoka and Dr Natalia Criado-Pacheco (office hours)
Teaching pattern: 3-hour lecture (weekly); 2-hour practical session (alternate weeks)
The aim of this module is to introduce the theoreatical foundations of database
systems and the main concepts underlying practical organisation and management of such systems.
On successful completion of this module, the students will appreciate the
importance of database systems in information management, will be able to design and query a relational database, will have some experience with translating natural language queries into a logical formalism, will be able to create and manage an SQL database, and will have an understanding of some key concepts in database administration.
This module covers the following topics:
- Introduction to database systems
- Database Administration: basic concepts, database recovery
- Entity-relationship modelling
- A relational model of data
- Functional dependencies and normal forms
- Relations, model constraints, relational algebra
Suggested Reading and Resources (Link to MyReadingLists)
07 September 2017