course-details-portlet

IDATG2204 - Data modeling and database systems

About

New from the academic year 2020/2021

Examination arrangement

Examination arrangement: Portfolio assessment and Written exam
Grade: Letters

Evaluation form Weighting Duration Examination aids Grade deviation
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.
Database construction.
Normalization as a design theory for relational databases.
Other database models.
Developing and testing database applications.
Storage technologies, file organization, and index structures.
Query processing.
Database management systems (DBMS).
Transactions, concurrency, and recovery.
Data integrity.

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. Query languages​​: Relational Algebra and SQL.
5. Design theory for relational databases.
6. System design and programming using database systems - including database application testing.
7. Data storage, file organization and index structures.
8. Execution of database queries.
9. 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 lectures, interactive classroom activities, exercises, project work, code review, and self-tuition.

Compulsory assignments

  • Mandatory assignments

Further on evaluation

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.

The resit examination may be oral if few students are enrolled.

Specific conditions

Exam registration requires that class registration is approved in the same semester. 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 2021

No.of lecture hours: 4
Lab hours: 4
No.of specialization hours: 4

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

Phone:

Examination

Examination arrangement: Portfolio assessment and Written exam

Term Status code Evaluation form 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