Course - Information Structures and Database Systems - IDG2004
Information Structures and Database Systems
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.
Specific conditions
Admission to a programme of study is required:
Business Administration (BØA)
Geomatics - Engineering (BIGEOMAT)
Web Development (BWU)
Course materials
Announced at the start of the course.
Subject areas
- Database technology
Contact information
Course coordinator
Lecturers
Department with academic responsibility
Examination
Examination
Ordinary examination - Autumn 2025
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.