School of Computer Science

Module 21980 (2013)

Module description - ICY Databases

The Module Description is a strict subset of the Syllabus Page.

Module Title ICY Databases
School School of Computer Science
Module Code 06-21980
Level 1/C I
Member of Staff John Barnden
Semester Semester 1 - 10 credits
Delivery

2 hrs lectures/tutorials per week (plus 22 hours of assisted labs)

Contact Hours: 24

Description

The module will explore some of the fundamentals of databases. Topics will include: relational theory, relational algebra, query languages, data design. The necessary mathematical background will be developed alongside its application in databases. Students will be introduced to an existing database system.

Outcomes

On successful completion of this module, the student should be able to:

1 Use SQL to create, modify and query databases
2 Analyse a real-world scenario and perform a conceptual database design for it
3 Take a conceptual data design model and translate it into the relational model 4 Use an existing database system

Assessment

Sessional: 1.5hr examination (80%), continuous assessment (20%)

Supplementary (where allowed): 1.5 hour examination (100%)