ITF10306 Databases (Spring 2016)
Facts about the course
- ECTS Credits:
- 10
- Responsible faculty:
- Avdeling for informasjonsteknologi
- Course Leader:
- Edgar Bostrøm
- Teaching language:
- Norwegian
- Duration:
- ½ year
Table of contents
The course is affiliated to the following study programme
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
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
The student's learning outcomes on passing 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
Teaching and learning methods
Workload
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.
Exam
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.
Reading list
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.