ITF10306 Databases (Spring 2015)
Facts about the course
- ECTS Credits:
- 10
- Responsible department:
- Faculty of Computer Science
- Course Leader:
- Edgar Bostrøm
- Teaching language:
- Norwegian
- Duration:
- ½ year
The course is connected to the following study programs
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
This course requires prerequisite knowledge equivalent to Introduction to Programming and/or Introduction to Information Technology.
Lecture 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.
The student's learning outcomes after completing 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
Content
- Databases in general
- SQLData 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.
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 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.