MM-107 Databases (Spring 2024)
- ECTS Credits:
- 5
- Responsible department:
- Faculty of Engineering and Science
- Course Leader:
- Halvard Øysæd
- Lecture Semester:
- Spring
- Teaching language:
- Norwegian
- Duration:
- ½ year
Table of contents
The course is connected to the following study programs
- Bachelor's Programme in Multimedia Technology and Design
- ICT, 1-year Programme
Teaching language
Learning outcomes
On successful completion of the course, the student should:
- have a broad knowledge of basic database theory with special emphasis on understanding of relational databases.
- have broad knowledge and master the basic of the database query language Stuctured Query Language (SQL).
- be able to use a database tool (DBMS).
- have a general understanding of data storage transactions and recovery concerning DBMS.
- be familiar with NoSQL databases
- be familiar with how a database and a website can work together.
- know how to plan, develop, model and create a relational database
Contents
Teaching and learning methods
Lectures, laboratory exercises and self study. The exercises take place in the computer laboratory on customized computers with specialized hardware and software. A laboratory engineer, student assistant and/or course lecturer is present. The students get training in development and use of professional software and hardware. The classes are split into groups of suitable sizes so that all students get access to necessary equipment and the help they need to solve the exercises. Some of the exercises involve group work. The problems for the students to solve, are typically development of own programmes and hardware.
Expected workload in the course is approximately 135 hours.
Examination requirements
Examinations
Student evaluation
Offered as a free-standing course
Admission Requirement if given as a free-standing course
Reduction of Credits
This course’s contents overlap with the following courses. A reduction of credits will occur if one of these courses is taken in addition:
| Course | Reduction of Credits |
|---|---|
| DAT202 – Databases. | 5 |
| IKT105 – Data Modelling and Databases. | 5 |
| DAT2800 – Databases 1. | 4 |
| DAT2800 – Databases 1. | 4 |
| DAT2820 – Databases 2. | 4 |
| DAT2820 – Databases 2. | 4 |