course-details-portlet

IDATT2103

Databases

Credits 7.5
Level Intermediate course, level II
Course start Autumn 2023
Duration 1 semester
Language of instruction Norwegian
Location Trondheim
Examination arrangement School exam

About

About the course

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

Admission to a programme of study is required:
Computer Science - Engineering (BIDATA)
Digital Infrastructure and Cyber Security (BDIGSEC)

Required previous knowledge

None.

Course materials

Given at the start of the course.

Credit reductions

Course code Reduction From
TDAT1005 5 sp Autumn 2020
INFT1001 3 sp Autumn 2020
DIFT1002 3 sp Autumn 2020
IINI1003 5 sp Autumn 2020
IDRI1002 5 sp Autumn 2020
IDATT2002 7.5 sp Autumn 2023
This course has academic overlap with the courses in the table above. If you take overlapping courses, you will receive a credit reduction in the course where you have the lowest grade. If the grades are the same, the reduction will be applied to the course completed most recently.

Subject areas

  • Engineering

Contact information

Course coordinator

Lecturers

Department with academic responsibility

Department of Computer Science

Examination

Examination

Examination arrangement: School exam
Grade: Letter grades

Ordinary examination - Autumn 2023

School exam
Weighting 100/100 Examination aids Code B Date 2023-12-13 Time 15:00 Duration 4 hours Exam system Inspera Assessment
Place and room for 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.

Sluppenvegen 14
Room SL110 hvit sone
58 candidates
Room SL110 turkis sone
80 candidates
Room SL238
2 candidates
Room SL315
4 candidates
Room SL318
1 candidate
Room SL520
6 candidates

Re-sit examination - Summer 2024

School exam
Weighting 100/100 Examination aids Code B Duration 4 hours Exam system Inspera Assessment Place and room Not specified yet.

All about examinations at NTNU