ITF10306 Databases (Spring 2016)

The course is connected to the following study programs

Compulsory course in:

• Bachelor in Computer Science
• Bachelor in Information Systems
• Bachelor in Computer Engineering
• Bachelor in Computer Engineering, Y-veien
• Bachelor in Computer Engineering,Tress

Elective course for other study programmes.

Prerequisites

This course requires prerequisite knowledge equivalent to Introduction to Programming and/or Introduction to Information Technology.

The student's learning outcomes after completing the course

Knowledge

On completion of the course, the student:

• has an overview of what a database system is
• has sound knowledge of the relational model and some knowledge of alternative models
• has a sound knowledge of the development process associated with creating databases
• is familiar with the challenges of transactions and simultaneous use of databases

Skills

On completion of the course, the student can:

• create SQL statements for data definition, manipulation and extraction at a relatively advanced level
• create data models
• normalise a structure
• give an account of different topics in the field of databases

General competence

On completion of the course, the student can:

• see the connection between the database system and its place in an IT system
• develop and use databases

Content

• Databases in general
• SQL
• Data modelling
• Normalisation
• Theoretical basis for relational databases
• Simultaneity, security, integrity and recovery
• Markets and advanced aspects, data warehouses, etc

Forms of teaching and learning

Lectures, group exercises, self-study and submission of assignments.

Workload

4 hours of lectures + exercises per week.

Coursework requirements - conditions for taking the exam

• 4 compulsory assignments
• Compulsory attendance of up to 16 hours of lectures or group sessions

The coursework requirements must be approved before students may sit the exam.

Examination

Written exam lasting 4 hours. Letter grading scale A?F.
No support materials permitted.

Course evaluation

This course is evaluated as follows:

• Mid-semester evaluation (optional)
• Final evaluation (compulsory)

The course instructor prepares a course report on the basis of student feedback and on his/her own experiences of the course. Course reports are discussed with the Committee for Study Quality at the Faculty of Computer Sciences.

Literature

Updated 2nd July 2015.

Connolly, Begg: Database Systems - A Practical Approach to Design, Implementation and Management. Addison-Wesley, 6. edition, 2014, ISBN-10: 1-292-06118-9, ISBN-13: 978-1-292-06118-4.

Alternative literature in Norwegian or English are given by the course instructor.