IS-201 Data Modelling and Database Systems

The course is connected to the following study programs

• Bachelor's Programme in IT and Information Systems

Teaching language

Norwegian

Recommended prerequisites

Based on IS-100 and IS-110 or equivalent courses

Course 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

Learning outcomes

Upon successful completion of the course, the students should 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

Examination requirements

Approved mandatory assignments.

Teaching 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.

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.

Assessment methods and criteria

Portfolio evaluation consisting of group work and individual elements. Individual graded mark, A-F.

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