course-details-portlet

IDG2004 - Information Structures and Database Systems

About

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

Course materials

Announced at the start of the course.

More on the course

No

Facts

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

Coursework

Term no.: 1
Teaching semester:  AUTUMN 2024

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

Examination arrangement: Aggregate score

Term Status code Evaluation Weighting Examination aids Date Time Examination system Room *
Autumn ORD Written School exam 80/100 2024-12-12 15:00 INSPERA
Room Building Number of candidates
M414-Eksamensrom 4.etg Mustad, Inngang A 0
M433-Eksamensrom 4.etg Mustad, Inngang A 46
Autumn ORD Assignments 20/100
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.
Examination

For more information regarding registration for examination and examination procedures, see "Innsida - Exams"

More on examinations at NTNU