IDG2004 - Information Structures and Database Systems


New from the academic year 2020/2021

Examination arrangement

Examination arrangement: Written examination
Grade: Letters

Evaluation form Weighting Duration Examination aids Grade deviation
Written examination 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, XPath, XSLT and XML Schema.

Learning outcome

After completing the course successfully, the student will be able to:
-Recognize the features of database and database management systems.
-Create conceptual model for a specific application.
-Explain the characteristics and constraints of relational model.
-Understand and express queries in SQL.
-Describe structuring and management of semi-structured data in XML.

After completing the course successfully, the student acquires the skills to:
-Create and assess conceptual and associated logical data model for a specific application.
-Construct a specific relational database solution based on conceptual and logical model.
-Use SQL for defining, manipulating and querying database.
-Apply XML technologies for for storing and processing semi-structured data.

Learning methods and activities

-Laboratory work
-Mandatory assignments.

Compulsory Requirements:
-5 of 6 mandatory assignments must be approved in order to take the exam.

Compulsory assignments

  • 5 Coursework requirements

Further on evaluation

The student becomes eligible to attend the exam in the next three years after passing the mandatory coursework requirements.

Supplementary information about continuation: Deferred written exam in August.

Specific conditions

Exam registration requires that class registration is approved in the same semester. Compulsory activities from previous semester may be approved by the department.

Admission to a programme of study is required:
Geomatics (BIGEOMAT)
Web Development (BWU)

Course materials

Elmasri, R. and Navathe, S. (2016): Fundamentals of database systems, seventh edition, Pearson Education.

More on the course



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


Term no.: 1
Teaching semester:  AUTUMN 2020

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: Written examination

Term Status code Evaluation form Weighting Examination aids Date Time Digital exam Room *
Autumn ORD Written examination 100/100 E
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