course-details-portlet

IDATG2204 - Data modeling and database systems

About

Examination arrangement

Examination arrangement: Portfolio assessment and written examination
Grade: Letters

Evaluation Weighting Duration Grade deviation Examination aids
Portfolio assessment 30/100
Written examination 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

Portfolio consists of project work and formative assessment.

80% of the 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.

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

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:
Computer Science (BIDATA)
Programming (BPROG)

Course materials

Announced at the start of the course.

Credit reductions

Course code Reduction From To
IMT2261 7.5 01.09.2020
IMT2571 7.5 01.09.2020
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 2022

Language of instruction: English

Location: Gjøvik

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

Department with academic responsibility
Department of Computer Science

Examination

Examination arrangement: Portfolio assessment and written examination

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