course-details-portlet

IDATA2303 - Data Modeling and Database Applications

About

Examination arrangement

Examination arrangement: Oral examination
Grade: Letters

Evaluation Weighting Duration Grade deviation Examination aids
Oral examination 100/100 30 minutes

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 Server: components, architecture, installation, configuration and administration
  • Software interfaces to relational databases
  • Basic interaction 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 project work. The subject requires a high personal effort. Mandatory requirements: 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 study start. The project shall be submitted and approved before an exam may be taken.

Compulsory assignments

  • Oblig

Further on evaluation

Oral exam (100%)

Specific conditions

Compulsory activities from previous semester may be approved by the department.

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

Course materials

To be announced at semester start.

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 2021

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: Lecturer(s):

Department with academic responsibility
Department of ICT and Natural Sciences

Examination

Examination arrangement: Oral examination

Term Status code Evaluation Weighting Examination aids Date Time Digital exam Room *
Autumn ORD Oral examination 100/100
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