IDG2004 - Information Structures and Database Systems


Examination arrangement

Examination arrangement: School exam
Grade: Letter grades

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

Course content

  • Basic concepts of database and database management systems.
  • Conceptual data modeling with Entity Relationship Diagram.
  • 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 languages ​​for relational model - relational algebra and SQL.

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

Compulsory assignments

  • Mandatory Assignments

Further on evaluation

Mandatory assignment consisting of multiple parts.

Grade: Letters (A - F) based on:

  • Written exam: 100/100

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

Specific conditions

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

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 2022

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: School exam

Term Status code Evaluation Weighting Examination aids Date Time Examination system Room *
Autumn ORD School exam 100/100 E 2022-12-07 09:00 INSPERA
Room Building Number of candidates
M438 Eksamensrom 4.etg, Inngang D Mustad, Inngang D 35
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