IDATA2303 - Data Modeling and Database Applications


Examination arrangement

Examination arrangement: School exam
Grade: Letter grades

Evaluation Weighting Duration Grade deviation Examination aids
School exam 100/100 3 hours E

Course content

  • The subject's history
  • Terminology
  • Relational Database Systems: data modeling, design, realization
  • Normalization
  • Structured Query Language (SQL)
  • Table definition and data manipulation
  • Advanced query techniques
  • Database Server: components, architecture, installation, configuration and administration
  • Software interfaces to relational databases
  • Basic interaction design

Learning outcome

Knowledge - candidate has knowledge about:

  • Central concepts of database systems
  • SQL language for both data definition and querying

Skills - candidate can:

  • Design an efficient database structure, using normalization
  • Write efficient SQL data queries
  • Develop software systems that interact with SQL databases
  • Install and set up an SQL database server

General competence - candidate is able to:

  • Plan and execute software development projects including databases
  • Communicate orally and in writing about topics of the course

Learning methods and activities

Pedagogical methods: Lectures, exercises and project work. The subject requires a high personal effort. Mandatory requirements: Project application and project reporting in accordance with established deadlines. Further provision on minimum content, requirements and deadlines regarding the project is given by the lecturer at study start. The project shall be submitted and approved before an exam may be taken.

Compulsory assignments

  • Mandatary assignments

Further on evaluation

Oral exam (100%)

Specific conditions

Compulsory activities from previous semester may be approved by the department.

Admission to a programme of study is required:
Computer Science (BIDATA)

Course materials

To be announced at semester start.

More on the course



Version: 1
Credits:  7.5 SP
Study level: Intermediate course, level II


Term no.: 1
Teaching semester:  AUTUMN 2022

Language of instruction: English, Norwegian

Location: Ålesund

Subject area(s)
  • Computer and Information Science
  • Database technology
  • Information Technology and Informatics
  • Engineering
Contact information
Course coordinator: Lecturer(s):

Department with academic responsibility
Department of ICT and Natural Sciences


Examination arrangement: School exam

Term Status code Evaluation Weighting Examination aids Date Time Examination system Room *
Autumn ORD School exam 100/100 E 2022-11-29 09:00 INSPERA
Room Building Number of candidates
Summer UTS School exam 100/100 E INSPERA
Room Building Number of candidates
  • * The location (room) for a written examination is published 3 days before examination date. If more than one room is listed, you will find your room at Studentweb.

For more information regarding registration for examination and examination procedures, see "Innsida - Exams"

More on examinations at NTNU