course-details-portlet

IDG2004 - Information Structures and Database Systems

About

Examination arrangement

Examination arrangement: School exam
Grade: Letter grades

Evaluation Weighting Duration Grade deviation Examination aids
School exam 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, 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.

Compulsory assignments

  • Mandatory Assignments

Further on evaluation

Mandatory assignment consisting of multiple parts.

Grade: Letters (A - F) based on:

  • Written exam: 100/100

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

Specific conditions

Compulsory activities from previous semester may be approved by the department.

Admission to a programme of study is required:
Business Administration (BØA)
Geomatics (BIGEOMAT)
Web Development (BWU)

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 2022

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: School exam

Term Status code Evaluation Weighting Examination aids Date Time Examination system Room *
Autumn ORD School exam 100/100 E 2022-12-07 09:00 INSPERA
Room Building Number of candidates
M438 Eksamensrom 4.etg, Inngang D Mustad, Inngang D 35
Summer UTS School exam 100/100 E 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