University of Galway

Course Module Information

Course Modules

Semester 1 | Credits: 5

This course introduces the basic concepts of databases and discusses their practical applications (Web/mobile/desktop based applications) and design issues. Emphasis will be given to database design and implementation, with an introduction to related concepts and technologies.
(Language of instruction: English)

Learning Outcomes
  1. Explain basic principles of relational database design.
  2. Model data requirements using techniques such as Entity-Relationship and UML Class Diagrams.
  3. Apply the technique of normalisation to optimise data structures in relational database design.
  4. Understand how a relational database system enforces data integrity constraints and transaction management rules.
  5. Use the Structured Query Language (SQL) to create a relational database with tables and views.
  6. Use SQL to extract, summarise and aggregate data in a relational database.
Assessments
  • Written Assessment (70%)
  • Continuous Assessment (30%)
Teachers
The above information outlines module MS218: "Database Technologies" and is valid from 2023 onwards.
Note: Module offerings and details may be subject to change.