MM-107 Databases
- ECTS Credits:
- 5
- Responsible department:
- Faculty of Engineering and Science
- Course Leader:
- Halvard Øysæd
- Lecture Semester:
- Spring
- Teaching language:
- Norwegian
- Duration:
- 1 term
The course is connected to the following study programs
- Bachelor's Programme in Multimedia Technology and Design
- ICT, 1-year Programme
Teaching language
NorwegianCourse contents
Basic database theory, relational, NoSQL databases, DBMS, SQL, MySQL, database history, data storage, transactions, recovery and modelling.
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
Examination requirements
Students must pass the compulsory exercises in order to take the examination. Information about compulsory assignments will be given in the LMS at the start of the course.
Teaching 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.
Evaluation
The person responsible for the course decides, in cooperation with student representative, the form of student evaluation and whether the course is to have a midway or end of course evaluation in accordance with the quality system for education, chapter 4.1.
Offered as Single Standing Module
Yes. Subject to availability or capacity.Admission Requirement if given as Single Standing Module
Higher Education Entrance Qualification
Assessment methods and criteria
Written examination, 3 hours. Graded assessment.
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 – Datamodellering og databaser | 5 |
| DAT2800 – Databases 1 | 4 |
| DAT2800 – Databases 1 | 4 |
| DAT2820 – Databases 2 | 4 |
| DAT2820 – Databases 2 | 4 |