IDG2004 - Information Structures and Database Systems


Examination arrangement

Examination arrangement: Aggregate score
Grade: Letters

Evaluation Weighting Duration Grade deviation Examination aids
Assignment 20/100
School exam 80/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.

Further on evaluation

Grade: Letters (A - F) based on: 

  • Written exam: 80/100 
  • Other work (5 practice assessments): 20/100 

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

Specific conditions

Admission to a programme of study is required:
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 2021

Language of instruction: English

Location: Gjøvik

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

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 School exam 80/100 E 2021-12-01 09:00 INSPERA
Room Building Number of candidates
M433-Eksamensrom 4.etg Mustad, Inngang A 33
Autumn ORD Assignment 20/100



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