Program Overview

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. Formal languages and reading of structured text are also covered.

Education

• BSc Programme in Bioinformatics
• BSc Programme in Computer Science and Economics
• BSc Programme in Computer Science
• BSc Programme in Machine Learning and Data Science

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.
• Methods for reading structured texts (i.e., regular expressions, finite automata, context-free grammars).
• Data protection regulation (GDPR)

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 implementing database applications.
• Effectively participating in an agile software development process as part of a group of developers.

Teaching and Learning Methods

A combination of lectures, exercise sessions, and a practical group project.

Literature

See Absalon when the course is set up.

Recommended Prerequisites

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".

Remarks

The course is equivalent 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).

Additionally, most of the contents of this course were covered in the discontinued courses "NDAB 16009U Udvikling af informationssystemer (UIS)" and "NDAB 21002U Data Science (DS)", so we advise against taking this course if you have passed either of those.

Exam

• ECTS: 7.5 ECTS
• Type of assessment: On-site written exam, 4 hours under invigilation
• Type of assessment details: The on-site written exam is an ITX exam.
• Examination prerequisites:
  • The group project must be approved.
  • Two mandatory assignments, marked as pass/fail, must be passed.
• Aid: All aids allowed except Generative AI and internet access
• Marking scale: 7-point grading scale
• Censorship form: External censorship
• Re-exam: 4-hour written test with written aids (as in the ordinary exam).

Criteria for Exam Assessment

See Learning Outcome.

Course Type

Single subject courses (day)

Workload

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

Course Information

• Language: English
• Course number: NDAB21010U
• ECTS: 7.5 ECTS
• Programme level: Bachelor
• Duration: 1 block
• Placement: Block 4
• Schedule group: A
• Capacity: No limitation – unless you register in the late-registration period (BSc and MSc) or as a credit or single subject student.
• Study board: Study Board of Mathematics and Computer Science
• Contracting department: Department of Computer Science
• Contracting faculty: Faculty of Science
• Course Coordinator: Dmitriy Traytel

Contracting Department and Faculty

• Department: Department of Computer Science
• Faculty: Faculty of Science

Course Coordinator

• Dmitriy Traytel

Additional Information

• Saved on the
• Are you BA- or KA-student?
• University of Copenhagen
  Nørregade 10
  1165 København K

University of Copenhagen

• Management
• Administration
• Faculties
• Departments
• Research centres
• Animal hospitals
• School of Dentistry
• Libraries
• Museums and attractions

Contact

• Map
• Find an employee
• Contact UCPH

Services

• Press and media service
• Merchandise
• IT-support
• For suppliers

For Students and Employees

• KUnet

Job and Career

• Job portal
• Jobs for students
• Alumni

Emergencies

• Emergency response

Web

• Cookies and privacy policy
• Accessibility statement
• Information security

Connect with UCPH

Close menu