ITF30307 Databases - Management and Systems (Autumn 2014)

The course is connected to the following study programs

Compulsory course in:

• Bachelor Programme in Computer Science
• Bachelor Programme in Information Systems: specialisation in IT Management and specialisation in Web Development

Elective course in:

• Bachelor Programme in Computer Engineering
• Bachelor Programme in Computer Engineering, Y-veien
• Bachelor Programme in Computer Engineering, Tress

Prerequisites

It is recommended that students have knowledge equivalent to the courses in Databases and Introduction to Programming.

Lecture Semester

Semester 5 (autumn)

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:

• deeper insight into what a database system is and of its components
• know how database systems interact with other systems such as middleware
• advanced theoretical understanding in, among other things, optimisation
• knowledge of different types of databases and applications, including data warehouses
• knowledge of big data

Skills

On completion of the course, the students can:

• set up and operate a database system
• write statements in relational algebra
• create simple stored procedures and triggers
• design a warehouse
• use XML in connection with databases
• work on different database systems

General competence

On completion of the course, the students have:

• sound competence in DBA
• advanced knowledge of developing and using database systems

Content

Database administration, connecting to databases, triggers and stored procedures, XML, middleware and persistence. Data warehousing and big data. Models for databases, relational algebra Non-relational systems: Multimedia databases, object-oriented and object-relational systems, and XML-based systems

Forms of teaching and learning

Lectures and project work. The course is mainly built on a combination of lectures and project work. Some topics included in the projects will not be covered in lectures, and students are therefore expected to learn about them independently.

Examination

Portfolio exam and written exam

The final individual grade is awarded on the basis of two partial exams. Students must pass each partial exam in order to pass the whole course.

Partial Exam 1 is a portfolio exam comprising reports from 4 projects conducted in groups. The portfolio exam accounts for 49%. Individual grades awarded.

Partial Exam 2 comprises an individual written exam lasting 3 hours and worth 51%. No support materials permitted.

Letter grading scale A?F.

In the case of resit exams or rescheduled exams, each part of an exam may be retaken and the results of each part combined. The content of the project assignment must be discussed with the course instructor in the case of resit exams or rescheduled exams.

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

Thomas M. Connolly Carolyn E. Begg. Database Systems: A Practical Approach to Design, Implementation and Management - 6th Edition

Handouts and web resources.