COMP20070

Source: https://hub.ucd.ie/usis/!W_HU_MENU.P_PUBLISH?p_tag=MODULE&MODULE=COMP20070&TERMCODE=202500&ACYR=2026 Parent: https://hub.ucd.ie/usis/!W_HU_MENU.P_PUBLISH?p_tag=COURSE&MAJR=ETS2&AUDIENCE=

Academic Year 2025/2026

Print

Databases and Information Systems I (COMP20070)

Subject: : Computer Science

College: : Science

School: : Computer Science

Level: : 2 (Intermediate)

Credits: : 5

Module Coordinator: : Dr Anh Vu Vo

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 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. They will learn details about the relational database model, relational database query languages (relational algebra/calculus, 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 system. Students will find these skills very useful in the development of any application requiring the storage and manipulation of data.

About this Module

Open All Close All

What will I learn?

Learning Outcomes:

On completion of this module students should be able to:\ - formulate, explain and compare the fundamental database concepts\ - design a relational database (conceptual and logical design using E-R and relational models)\ - analyse a relational database table \ - express queries in relational algebra and SQL\ - implement and query a relational database

Indicative Module Content:

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

How will I learn?

Student Effort Hours:

\

Approaches to Teaching and Learning:

• active/task-based learning (examples exercises; problem solving)\
• peer/group work where appropriate\
• individual work (assignment)\ \ If students are permitted to use generative AI tools in assignments, that will be indicated in the assignment specification.

Am I eligible to take this module?

Requirements, Exclusions and Recommendations

Not applicable to this module.

\

Module Requisites and Incompatibles

Not applicable to this module. \  \

How will I be assessed?

Assessment Strategy

\

Carry forward of passed components

No

\

What happens if I fail?

Please see Student Jargon Buster for more information about remediation types and timing. \

Assessment feedback

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.

Associated Staff

When is this module offered?

Timetabling information is displayed only for guidance purposes, relates to the current Academic Year only and is subject to change.

Print this page