Course - Databases - IDATT2103
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
Admission to a programme of study is required:
Computer Science - Engineering (BIDATA)
Digital Infrastructure and Cyber Security (BDIGSEC)
Recommended previous knowledge
Basic knowledge in programming.
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 |
No
Version: 1
Credits:
7.5 SP
Study level: Intermediate course, level II
Term no.: 1
Teaching semester: AUTUMN 2023
Language of instruction: Norwegian
Location: Trondheim
- Engineering
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.
For more information regarding registration for examination and examination procedures, see "Innsida - Exams"