IDG2004 - Information Structures and Database Systems


Examination arrangement

Examination arrangement: Aggregate score
Grade: Letter grades

Evaluation Weighting Duration Grade deviation Examination aids
Assignments 20/100
Written School exam 80/100 4 hours

Course content

The course includes, but is not limited to, the following topics:

  • Basic concepts of database and database management systems.
  • Conceptual data modeling.
  • Introduction to relational model, constraints and relational algebra.
  • Logical database design and normalization.
  • SQL for defining, manipulating and querying database.
  • XML data, XML Schema, XPath and XSLT.

Learning outcome

After completing the course successfully,

The student has knowledge of:

- Database management systems - characteristics and general structure.

- Data modeling with a focus on conceptual modeling.

- Relational model, its characteristics and integrity constraints.

- Query language ​​for relational model.

- Logical design and normalization for relational databases.

- Structuring and management of semi-structured data using XML.

The student acquires the skills to:

- Create and assess conceptual and associated logical data models.

- Construct relational database solutions based on conceptual and logical models.

- Employ normalization to evaluate and assess relational databases.

- Make use of SQL for defining, manipulating and querying relational databases.

- Utilize XML technologies for storing and processing semi-structured data.

The student acquires general competence in:

- Knowledge of database systems - their applications, benefits and limitations.

- Creating abstract models and solutions for practical problems.

- Assessing alternatives for storing and managing digital data.

- Using computer tools for developing software systems.

Learning methods and activities

Lectures, in-class exercises, laboratory work, assignments.

Further on evaluation

Grade: Letters (A - F) based on:

  • Assignments: 20/100
  • Written exam: 80/100

Resit examination - for the written exam in August. The resit examination may be oral if few students are enrolled. No resit for the assignments.

Assignment score is valid for a year.

Retake can be carried out for some partial assessments without all partial assessments having to be taken up again.

Specific conditions

Admission to a programme of study is required:
Business Administration (BØA)
Geomatics (BIGEOMAT)
Web Development (BWU)

Course materials

Announced at the start of the course.

More on the course



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


Term no.: 1
Teaching semester:  AUTUMN 2023

Language of instruction: English

Location: Gjøvik

Subject area(s)
  • Database technology
Contact information
Course coordinator: Lecturer(s):

Department with academic responsibility
Department of Computer Science


Examination arrangement: Aggregate score

Term Status code Evaluation Weighting Examination aids Date Time Examination system Room *
Autumn ORD Written School exam 80/100 2023-12-18 09:00 INSPERA
Room Building Number of candidates
M438 Eksamensrom 4.etg, Inngang D Mustad, Inngang D 19
Autumn ORD Assignments 20/100 INSPERA
Room Building Number of candidates
Summer UTS Written School exam 80/100 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