COMP20070 Databases and Information Systems I

Academic Year 2024/2025

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.

Show/hide contentOpenClose All

Curricular information is subject to change

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.

Student Effort Hours: 
Student Effort Type Hours
Specified Learning Activities

20

Autonomous Student Learning

60

Lectures

24

Practical

12

Total

116

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
Not applicable to this module.
 
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 9, 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.

Name Role
Professor Michela Bertolotto Lecturer / Co-Lecturer