ITF10306 Databases (Spring 2015)
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 Programme in Computer Science
- Bachelor Programme in Information Systems
- Bachelor Programme in Computer Engineering
- Bachelor Programme in Computer Engineering, Y-veien
- Bachelor Programme in Computer Engineering,Tress
Elective course in Computer Science, one-year programme
Prerequisites
Teaching semester
Bachelor Programme in Computer Science: semester 2 (spring)
Bachelor Programme in Information Systems: semester 2 (spring)
Computer Science, one-year programme: semester 2 (spring)
Bachelor Programme in Computer Engineering: semester 4 (spring)
Bachelor Programme in Computer Engineering, Y-veien: semester 4 (spring)
Bachelor Programme in Computer Engineering,Tress: semester 4 (spring)
Total workload:
4 hours of lectures + exercises per week.
Content
- Databases in general
- SQLData 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 students:
- have an overview of what a database system is
- have sound knowledge of the relational model and some knowledge of alternative models
- have a sound knowledge of the development process associated with creating databases
- be familiar with the challenges of transactions and simultaneous use of databases
Skills
On completion of the course, the students 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 students can:
- see the connection between the database system and its place in an IT system
- develop and use databases
Teaching and learning methods
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 spring 2014.
Connolly, Begg: Database Systems - A Practical Approach to Design, Implementation and Management. Addison-Wesley, 6. utgave, 2010, ISBN-10: 0321523067, ISBN-13: 9780321523068.