course-details-portlet

IDATG2204 - Data modeling and database systems

About

Examination arrangement

Examination arrangement: Portfolio assessment and written examination
Grade: Letter grades

Evaluation Weighting Duration Grade deviation Examination aids
Portfolio assessment 30/100
School exam 70/100 3 hours E

Course content

  • Basic introduction to data modelling with emphasis on conceptual modelling.
  • The relational model, relational algebra and SQL.
  • Normalization as a design theory for relational databases.
  • Other database models.
  • Database construction.
  • Developing and testing database applications.
  • Security in database systems.
  • Storage technologies, file organization, and index structures.
  • Query processing.
  • Database management systems (DBMS).
  • Data integrity, transactions, concurrency, and recovery.

Learning outcome

The student has knowledge of:

  1. Database management systems - general characteristics and system structure.
  2. Data modeling with an emphasis on conceptual modelling.
  3. Relational database model for database systems, database schema, and data integrity.
  4. Other database models.
  5. Query languages​​: Relational Algebra and SQL.
  6. Design theory for relational databases.
  7. System design and programming using database systems - including database application testing and data and application security preservation.
  8. Data storage, file organization and index structures.
  9. Execution of database queries.
  10. Transactions, concurrency, and robustness against errors.

The students are skilled in:

  1. Developing and assessing functional and effective conceptual models.
  2. Realization of relational databases.
  3. Developing, testing, and reviewing database applications using SQL, database APIs, and development tools.
  4. Evaluation and improvement of relational database schema based on normalization theory.
  5. Analysis and optimization of the performance of database systems.

General qualifications in the form of:

  1. Knowledge of applications of database systems and understanding of the benefits and limitations of such systems.
  2. Modelling and analytical approach to computer technical problems.
  3. Use of computer tools for software system development.
  4. Reviewing software design and program code.

Learning methods and activities

Learning activities include prerecorded lectures, interactive classroom activities, exercises, project work, peer code review, and self-tuition.

Compulsory assignments

  • Mandatory assignments

Further on evaluation

The portfolio consists of project work and formative assessment.

The project work shall result in a database application software system and a project report. An early version of the system shall be submitted for peer student code review. The project report shall document how experiences from - and feedback received in - the peer review process has had an impact on the final version of the system.

To pass the course both the portfolio and the final exam must be passed.

Mandatory assignments need to be passed to be eligible for attending the final exam. The student becomes eligible to attend the exam in the next three years if passing these mandatory coursework requirements.

The resit examination (written exam in August) may be oral if few students are enrolled. No resit for the portefolio.

Retake can be carried out for some partial assessments without all partial assessments having to be taken up again.

Specific conditions

Admission to a programme of study is required:
Digital Infrastructure and Cyber Security (BDIGSEC)
Programming (BPROG)

Course materials

Announced at the start of the course.

Credit reductions

Course code Reduction From To
IMT2261 7.5 AUTUMN 2020
IMT2571 7.5 AUTUMN 2020
IDATG2002 7.5 AUTUMN 2023
IDATA2002 7.5 AUTUMN 2023
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:  SPRING 2025

Language of instruction: English

Location: Gjøvik

Subject area(s)
  • Engineering
Contact information
Course coordinator:

Department with academic responsibility
Department of Computer Science

Timetable

List view
Calendar view

Examination

Examination arrangement: Portfolio assessment and written examination

Term Status code Evaluation Weighting Examination aids Date Time Examination system Room *
Spring ORD Portfolio assessment 30/100 INSPERA
Room Building Number of candidates
Spring ORD School exam 70/100 E INSPERA
Room Building Number of candidates
Summer UTS School exam 70/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