course-details-portlet

IDATT2103 - Databases

About

Examination arrangement

Examination arrangement: School exam
Grade: Letter grades

Evaluation Weighting Duration Grade deviation Examination aids
School exam 100/100 4 hours B

Course content

This course will cover the following topics: Data modeling (EER). Translation from EER to relational database. The relational model. Databases: ANSI / SPARC architecture, normalization, SQL, concurrency issues. Relationship database alternatives: NoSQL and semi-structural data (XML and JSON). Transaction management against database.

Learning outcome

Knowledge

The candidate must:

  • know key concepts within databases, and can account for these
  • be able to use SQL
  • be able to construct a data model (EER) for a given problem and translate this into the relational model
  • understand problems related to several simultaneous users of a database and know how these can be solved
  • know about NoSQL solutions
  • know the use and storage of semi-structural data such as XML

Skills

The candidate must:

  • be able to create a own database, and retrieve and modify the data in this database, all via SQL (D)
  • see the connection between program code and underlying SQL / database
  • be able to optimize SQL queries
  • be able to propose sustainable solutions for data storage related to normalization and reuse of data

General competence

The candidate must:

  • gain an understanding of using database solutions to solve different needs for storage and representation of digital data
  • have an understanding of what good data quality is

Learning methods and activities

Teaching with practical exercises and discussion forum.

Compulsory assignments

  • Assignments

Further on evaluation

Compulsory activities: Corresponding to 8 compulsory exercises, including 1 major exercise with its own database solution, must be approved in order to sit for the exam. Requirements can be made for exercises to be carried out as group work (team work).

Specific conditions

Required previous knowledge

None.

Course materials

Given at the start of the course.

Credit reductions

Course code Reduction From To
TDAT1005 5.0 AUTUMN 2020
INFT1001 3.0 AUTUMN 2020
DIFT1002 3.0 AUTUMN 2020
IINI1003 5.0 AUTUMN 2020
IDRI1002 5.0 AUTUMN 2020
IDATT2002 7.5 AUTUMN 2023
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 2023

Language of instruction: Norwegian

Location: Trondheim

Subject area(s)
  • Engineering
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 B 2023-12-13 15:00 INSPERA
Room Building Number of candidates
SL110 turkis sone Sluppenvegen 14 80
SL110 hvit sone Sluppenvegen 14 58
SL520 Sluppenvegen 14 6
SL238 Sluppenvegen 14 2
SL315 Sluppenvegen 14 4
SL318 Sluppenvegen 14 1
Summer UTS School exam 100/100 B 2024-08-05 09:00 INSPERA
Room Building Number of candidates
SL228 Sluppenvegen 14 0
SL310 hvit sone Sluppenvegen 14 3
SL274 Sluppenvegen 14 0
  • * 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