Show/hide main menu

Modules

4CCS1DBS Database Systems

Credit value: 15

Lecturers: Dr Sophia Tsoka and Dr Natalia Criado-Pacheco (office hours)
Semester: 2
Teaching pattern: 3-hour lecture (weekly); 2-hour practical session (alternate weeks)

Assessment

Learning aims
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.

Learning outcomes
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.

Syllabus
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
  • SQL

 Suggested Reading and Resources (Link to MyReadingLists)

 


07 September 2017
Sitemap Site help Terms and conditions  Privacy policy  Accessibility  Modern slavery statement  Contact us

© 2018 King's College London | Strand | London WC2R 2LS | England | United Kingdom | Tel +44 (0)20 7836 5454