Explore UCD

UCD Home >

COMP20240

Academic Year 2024/2025

Relational Databases & Information Systems (Conversion) (COMP20240)

Subject:
Computer Science
College:
Science
School:
Computer Science
Level:
2 (Intermediate)
Credits:
5
Module Coordinator:
Professor Michela Bertolotto
Trimester:
Autumn
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 these data are permanently maintained, quickly updated and made accessible to users. Databases are essential components of computerised information systems. This is a module for MSc. Computer Science (Conversion) and Higher Diploma in Computer Science students covering how to design, develop and query relational databases. In this module, students will learn the fundamentals of database models, database designing methodologies, database querying. They will learn details about the relational database model, relational database query languages (relational algebra, SQL), the entity-relationship model for database design. From a more practical point of view they will gain experience in building a relational database using a commercial 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 successful completion of this module the learner will be able to:

1. Analyse the goals, functions, models, and components of database systems.
2. Explain the context, phases, and techniques for designing and building databases.
3. Select and apply appropriate design models to a given development environment.
4. Design an efficient database system using an appropriate database design technique.
5. Implement and manipulate a relational database using SQL.

Indicative Module Content:

Relational database model, relational database query languages (relational algebra, SQL), the entity-relationship model for database design.

Student Effort Hours:
Student Effort Type Hours
Lectures

24
Practical

24
Autonomous Student Learning

62
Total

110

Approaches to Teaching and Learning:
active/task-based learning (examples exercises; problem solving);
peer/group work where appropriate;
individual work (assignment)

Requirements, Exclusions and Recommendations

Not applicable to this module.


Module Requisites and Incompatibles
Incompatibles:
COMP40725 - Intro to RD & SQLProgrammiing


 

Assessment Strategy  
Description Timing Component Scale Must Pass Component % of Final Grade In Module Component Repeat Offered
Exam (In-person): In class mid-term test Week 6, Week 7, Week 8 Graded No

20

 Yes
Individual Project: Individual assignment Week 10, Week 11, Week 12 Graded No

40

 No
Exam (In-person): Final in-class test Week 11, Week 12, Week 14 Graded No

40

 No

Carry forward of passed components
No
 

Resit In Terminal Exam
Spring No
Please see Student Jargon Buster for more information about remediation types and timing. 

Feedback Strategy/Strategies

• Feedback individually to students, on an activity or draft prior to summative assessment
• Self-assessment activities

How will my Feedback be Delivered?

Not yet recorded.

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.