IS-201 Data Modelling and Database Systems (Autumn 2020)
- ECTS Credits:
- 10
- Responsible department:
- Faculty of Social Sciences
- Course Leader:
- Terje Gjøsæter
- Lecture Semester:
- Autumn
- Teaching language:
- Norwegian, but English when English speaking students attend the course.
- Duration:
- ½ year
Table of contents
The course is connected to the following study programs
Teaching language
Norwegian, but English when English speaking students attend the course.
Recommended previous knowledge
Based on IS-100 and IS-110 or equivalent courses
Learning outcomes
Upon successful completion of the course, the students will be able to:
- conduct analysis, design and construction of simple relational databases
- explain the key principles for the organization and management of relational data
- perform normalization
- use SQL to define and manage a relational database
- explain the principles of controlling parallel processes in databases
Contents
The course gives an introduction to:
- conduct analysis by data modelling
- design a database using the relational model
- perform normalization
- develop a database using SQL
Teaching and learning methods
Teaching activities consist of lectures and organised lab work. Instruction in IS-201 is coordinated with IS-200 og IS-202. This coordination makes it difficult to take IS-201 without taking the other courses during the same semester.
Estimated workload is 270 hours.
Examination requirements
Approved mandatory assignments.
Examinations
A 4-hour written individual examination, graded A-F.
Student evaluation
The study programme manager, in consultation with the student representative, decides the method of evaluation and whether the courses will have a midterm- or end of term evaluation, see also the Quality System, section 4.1. Information about evaluation method for the course will be posted on Canvas.
Offered as a free-standing course
Yes, subject to capacity.
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 |
|---|---|
| IS-2400 – Data Modelling and Database Systems. | 10 |
| IS-2400 – Introduction to Database Systems. | 10 |
Last updated from FS (Felles studentsystem)
Oct. 15, 2026 6:10:10 AM