Explore UCD

UCD Home >

COMP40725

Academic Year 2026/2027

Introduction to Relational Databases and SQL Programming (COMP40725)

Subject:
Computer Science
College:
Science
School:
Computer Science
Level:
4 (Masters)
Credits:
10
Module Coordinator:
Dr Anh Vu Vo
Trimester:
Spring
Mode of Delivery:
On Campus
Internship Module:
No
How will I be graded?
Letter grades

Curricular information is subject to change.

Collection, organisation and storage of data are major tasks in many human activities and in every modern computing system. Computer-based information systems ensure that this data is permanently maintained, quickly updated and made accessible to users. Databases are essential components of computerised information systems. This is a module for students interested in understanding how to design, develop and query databases. In this module, students will learn the fundamentals of database models, database designing methodologies, database querying and database normalisation theory. They will learn details about the relational database model, relational database query languages (relational algebra, SQL, procedural extensions of SQL), the entity-relationship model for database design and database normalisation. From a more practical point of view they will gain experience in building a relational database using industry standard database management systems. Students will find these skills useful in the development of applications requiring the storage and manipulation of data.

About this Module

Learning Outcomes:

On completion of this module, a student should be aware of:
- database models
- SQL
- procedural extensions of SQL
- database design
- database normalisation

Indicative Module Content:

Foundational concepts in database models, database languages (including SQL and procedural extensions of SQL), and database design

UNESCO highlights a set of key competencies that support individuals in their development and support society in achieving the UN Sustainable Development Goals (SDGs). UCD has adapted these competencies and is combining them with others to form a general framework of learning competencies. This module will help you develop the competencies below to the levels specified. 
Learning Competency Additional Information Level

Collaboration

The ability to learn from others; to understand and respect the needs, perspectives and actions of others (empathy); to understand, relate to and be sensitive to others (empathic leadership); to deal with conflicts in a group; and to facilitate collaborative and participatory problem solving. Proficient

Critical Thinking

The ability to question norms, practices and opinions; to reflect on one’s own values, perceptions and actions. Proficient

Systems Thinking

The ability to recognize and understand relationships; to analyse complex systems; to think of how systems are embedded within different domains and different scales; and to deal with uncertainty. Proficient

Strategic

The ability to collectively develop and implement innovative actions that further sustainability at the local level and further afield. Proficient

Integrated Problem Solving

The overarching ability to apply different problem-solving frameworks to complex sustainability problems and develop viable, inclusive and equitable solution options that promote sustainable development, integrating the competencies in this list. Proficient

Digital Literacy and Judgement

The ability to access, evaluate, create and communicate information in digital environments; to engage critically, ethically and responsibly with digital technologies and digital information; to understand their opportunities, limitations, risks and impact on individual’s digital identities; and to exercise informed judgement in digital participation and decision-making. Proficient

The United Nations identified seventeen Sustainable Development Goals (SDGs) as core to the 2030 Agenda for Sustainable Development, and UCD contributes in general to SDG 4 Quality Education. Further SDGs explored within this module if relevant are listed below. A scale of 1 - 5 indicates the extent to which the SDG is covered.


 

Student Effort Hours:
Student Effort Type Hours
Lectures

36

Practical

48

Autonomous Student Learning

156

Total

240


Approaches to Teaching and Learning:
- Lectures
- Weekly assignments
- Class discussions
- Individual projects (demonstrating soft and hard skills)

If students are permitted to use generative AI tools in assignments, that will be indicated in the assignment specification.

Requirements, Exclusions and Recommendations

Not applicable to this module.


Module Requisites and Incompatibles
Incompatibles:
COMP20240 - Rel DB & Info Sys (Conv), COMP41090 - SQL Programming


 

Assessment Strategy
Description Timing Component Scale Must Pass Component % of Final Grade Component repeat (in-module) Offered
Assignment(Including Essay): A graded programming exercise in SQL. Week 3 Alternative linear conversion grade scale 40% No
10
No
Assignment(Including Essay): A graded programming exercise in SQL. Week 6 Alternative linear conversion grade scale 40% No
10
No
Exam (Open Book): A mid-term test (essentially an SQL practical assignment conducted under time-limited exam conditions). Week 9 Alternative linear conversion grade scale 40% No
20
No
Individual Project: A substantial project in SQL/database design requiring a comprehensive report and an SQL implementation. Week 12 Alternative linear conversion grade scale 40% No
60
No

As part of UCD's student support, under the Additional Consideration policy, extensions may be available for the following assessments in the module: Assignment (including essay/poster), Portfolio, Reflective Assignment, Report(s), and Individual Project.


Carry forward of passed components
No
 

Remediation Type Remediation Timing
In-Module Resit Prior to relevant Programme Exam Board
Please see Student Jargon Buster for more information about remediation types and timing. 

Feedback Strategy/Strategies

• Feedback individually to students, post-assessment

How will my Feedback be Delivered?

Not yet recorded.

Name Role
Amen Faridoon Lecturer / Co-Lecturer

Timetabling information is displayed only for guidance purposes, relates to the current Academic Year only and is subject to change.
Spring Lecture Offering 1 Week(s) - 20, 21, 23, 24, 25, 26, 29, 31, 32, 33 Mon 11:00 - 12:50
Spring Practical Offering 1 Week(s) - 20, 21, 22, 23, 24, 25, 26, 30, 31, 32, 33 Fri 13:00 - 14:50
Spring Practical Offering 2 Week(s) - 20, 21, 22, 23, 24, 25, 26, 30, 31, 32, 33 Fri 13:00 - 14:50