Explore UCD

UCD Home >

COMP40725

Academic Year 2024/2025

Introduction to Relational Databases and SQL Programming (COMP40725)

Subject:
Computer Science
College:
Science
School:
Computer Science
Level:
4 (Masters)
Credits:
10
Module Coordinator:
Assoc Professor Tony Veale
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 all 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, PL/SQL), the entity-relationship model for database design, Third and Boyce-Codd Normal Forms. 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 very useful in the development of any application requiring the storage and manipulation of data.

About this Module

Learning Outcomes:

On completion of this module, a student should be aware of: SQL Programming, PL/SQL programming, data types, database management systems. Additionally, the students should gain experience in designing and implementing normalised relational databases through the implementation of practical exercises and a final database project.

Indicative Module Content:

Foundational concepts in relational database design, SQL Programming constructs, PL/SQL programming, data types, database management systems

Student Effort Hours:
Student Effort Type Hours
Autonomous Student Learning

156
Lectures

36
Practical

48
Total

240

Approaches to Teaching and Learning:
Lectures, weekly assignments, class discussions, individual projects (demonstrating soft and hard skills)

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 In Module Component Repeat Offered
Assignment(Including Essay): A graded programming exercise in SQL. Week 2 Alternative linear conversion grade scale 40% No
4
 No
Assignment(Including Essay): A graded programming exercise in SQL. Week 3 Alternative linear conversion grade scale 40% No
4
 No
Assignment(Including Essay): A graded programming exercise in SQL. Week 4 Alternative linear conversion grade scale 40% No
4
 No
Assignment(Including Essay): A graded programming exercise in SQL. Week 5 Alternative linear conversion grade scale 40% No
4
 No
Assignment(Including Essay): A graded programming exercise in SQL. Week 6 Alternative linear conversion grade scale 40% No
4
 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

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.

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, 22, 23, 24, 25, 26, 29, 30, 31, 32, 33 Fri 09:00 - 10:50
Spring Practical Offering 1 Week(s) - 21, 22, 23, 24, 25, 26, 29, 30, 31, 32, 33 Fri 11:00 - 12:50
Print this page
Fill in the following details:
Enter the body of your query here.

From time to time UCD would like to send you further information that we feel, based on your enquiry, would be of interest to you.