Description
This module is intended as an introduction to the theory and practice of database design, construction and management. The module starts with an overview of the fundamental concepts of database management, and an explanation of the necessary elements of a database system. The focus then shifts to conceptual data modeling using established, industry-standard techniques and notation such as Entity Relationship (ER) and Universal Modeling Language (UML) diagrams. Finally, the module covers the construction, modification, maintenance and querying of a relational database using a standard query language such as SQL.
Learning outcomes:
By the end of the module, students will:
- Understand the dominant database paradigms available today, their strengths, weaknesses and application examples.
- Understand the aims and functions of Database Management Systems (DBMS).
- Be able to extract requirements for, design and specify a relational database using standard notation and methodologies such as entity relationship (ER) diagrams and universal modelling language (UML).
- Be able to implement, modify and query a database solution using standard tools such as SQL.
Main course text:
• Wilfried Lemahieu, Seppe vanden Broucke and Bart Baesens, "Principles of Database Management", Cambridge University Press, 2018 (principally chapters 1-7).
Compulsory module for: MSc in Knowledge, Information and Data Science
Optional for: this module is an option for students on the MSc in Digital Humanities, MA in Archives and Records Management, MA in Library and Information Studies and MA in Publishing.
Module deliveries for 2024/25 academic year
Last updated
This module description was last updated on 19th August 2024.
Ìý