Databases and Information Systems (DIS)

Course content

This course introduces students to basic database concepts such as relational databases, normal forms, and transactions. In addition, the course covers system development (basic software development) and version control, and includes the practical development of a smaller system (web system, mobile system, or the like, which must be decided before the course starts) as project work.

Education

BSc Programme in Computer Science and Economics

Learning outcome

Knowledge of

  • Key database technical concepts such as the relational model, data independence and transactions.
  • Entity-relationship modeling (ER modeling) and relational data modeling, including transformations from ER modeling to relational data modeling.
  • Queries in database query languages, including relational calculus, relational algebra, and SQL.
  • The theory of database normalization, including functional dependencies, keys, and relational decompositions.
  • ACID (atomicity, consistency, isolation, durability) properties and use of transactions.
  • Indexing techniques and their role in database query optimization.
  • Use of constraints and triggers.
  • Facilities for connecting databases, programming environments, and program libraries.

 

Skills in

  • Developing a data model and realizing database applications starting from the ER modeling, over relational modeling and normalization, to concrete relational, SQL-based database application.
  • Planning and managing an agile, iterative, and learning-oriented system development process, which under given resource and time constraints leads to the realization of a new database application.

 

Competence in

  • Developing a database design and implement database applications.
  • Effectively participating in an agile software development process as part of a group of developers.

A combination of lectures, exercise sessions and a practical group project (with report).

See Absalon when the course is set up.

Programming skills and experience in software development at a level corresponding to the completion of the DIKU courses "Programming og problemløsning" and either "High Performance Programming and Systems" or "Computer Systems”.

The course is similar to the discontinued course NDAB20003U Databaser og informationssystemer (DoI). Therefore you cannot register for NDAB21010U - Databases and Information Systems (DIS), if you have already passed NDAB20003U Databaser og informationssystemer (DoI).

Written
Individual
Continuous feedback during the course
ECTS
7,5 ECTS
Type of assessment
Written examination, 4 hours under invigilation
Type of assessment details
...
Aid
Written aids allowed

Books, notes, printouts are allowed.

Marking scale
7-point grading scale
Censorship form
External censorship
Criteria for exam assessment

See Learning Outcome.

Single subject courses (day)

  • Category
  • Hours
  • Lectures
  • 28
  • Preparation
  • 78
  • Exercises
  • 14
  • Project work
  • 82
  • Exam
  • 4
  • English
  • 206

Kursusinformation

Language
English
Course number
NDAB21010U
ECTS
7,5 ECTS
Programme level
Bachelor
Duration

1 block

Placement
Block 4
Schedulegroup
A
Capacity
No limit
The number of seats may be reduced in the late registration period
Studyboard
Study Board of Mathematics and Computer Science
Contracting department
  • Department of Computer Science
Contracting faculty
  • Faculty of Science
Course Coordinator
  • Dmitriy Traytel   (7-8684738b86777e52767b407d8740767d)
Saved on the 08-05-2023

Are you BA- or KA-student?

Are you bachelor- or kandidat-student, then find the course in the course catalog for students:

Courseinformation of students