course-details-portlet

IDATA2303 - Data Modeling and Database Applications

About

Examination arrangement

Examination arrangement: School exam
Grade: Letter grades

Evaluation Weighting Duration Grade deviation Examination aids
School exam 100/100 3 hours E

Course content

  • The subject's history
  • Terminology
  • Relational Database Systems: data modeling, design, realization
  • Normalization
  • Structured Query Language (SQL)
  • Table definition and data manipulation
  • Advanced query techniques
  • Database security
  • Database integrity
  • Database design

Learning outcome

Knowledge - candidate has knowledge about:

  • Central concepts of database systems
  • SQL language for both data definition and querying

Skills - candidate can:

  • Design an efficient database structure, using normalization
  • Write efficient SQL data queries
  • Develop software systems that interact with SQL databases
  • Install and set up an SQL database server

General competence - candidate is able to:

  • Plan and execute software development projects including databases
  • Communicate orally and in writing about topics of the course

Learning methods and activities

Pedagogical methods: Lectures, exercises, and group project work. The subject requires a high personal effort. Mandatory requirements: Exercises, project application, and project reporting in accordance with established deadlines. Further provision on minimum content, requirements, and deadlines regarding the project is given by the lecturer at the study start. The project shall be submitted and approved before an exam may be taken.

Compulsory assignments

  • Mandatory assignments

Further on evaluation

All mandatory assignments must be approved to get access to the examination.

Specific conditions

Admission to a programme of study is required:
Computer Science - Engineering (BIDATA)

Course materials

To be announced at semester start.

Credit reductions

Course code Reduction From To
IDATA2002 7.5 AUTUMN 2023
IDATT2002 7.5 AUTUMN 2023
IDATG2002 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:  AUTUMN 2023

Language of instruction: English, Norwegian

Location: Ålesund

Subject area(s)
  • Computer and Information Science
  • Database technology
  • Information Technology and Informatics
  • Engineering
Contact information
Course coordinator:

Department with academic responsibility
Department of ICT and Natural Sciences

Examination

Examination arrangement: School exam

Term Status code Evaluation Weighting Examination aids Date Time Examination system Room *
Autumn ORD School exam 100/100 E 2023-12-14 09:00 INSPERA
Room Building Number of candidates
G132 Gnisten/Fagskolen 49
G317 Gnisten/Fagskolen 4
Summer UTS School exam 100/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