course-details-portlet

IDG2004

Information Structures and Database Systems

Choose study year
Credits 7.5
Level Intermediate course, level II
Course start Autumn 2024
Duration 1 semester
Language of instruction English
Location Gjøvik
Examination arrangement Aggregate score

About

About the course

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

Course materials

Announced at the start of the course.

Subject areas

  • Database technology

Contact information

Course coordinator

Lecturers

Department with academic responsibility

Department of Computer Science

Examination

Examination

Examination arrangement: Aggregate score
Grade: Letter grades

Ordinary examination - Autumn 2024

Written School exam
Weighting 80/100 Date 2024-12-12 Time 15:00 Duration 4 hours Exam system Inspera Assessment
Place and room for written school exam

The specified room can be changed and the final location will be ready no later than 3 days before the exam. You can find your room location on Studentweb.

Mustad, Inngang A
Room M433-Eksamensrom 4.etg
46 candidates
Room M414-Eksamensrom 4.etg
Assignments
Weighting 20/100

Re-sit examination - Summer 2025

Written School exam
Weighting 80/100 Duration 4 hours Exam system Inspera Assessment
Place and room
The specified room can be changed and the final location will be ready no later than 3 days before the exam. You can find your room location on Studentweb.