Official course description, subject to change:
Basic info last published 28/10-19

Database Use and Design

Course info
Language:
English
ECTS points:
7.5
Course code:
2011001U
Participants min:
1
Participants max:
90
Offered to guest students:
yes
Offered as a single subject:
yes
Price (single subject):
10625 DKK (incl. vat)
Programme
Level:
Bachelor
Programme:
Bachelor of Science in Global Business Informatics
Staff
Course manager
Full Professor
Teacher
Associate Professor
Course semester
Semester
Forår 2020
Start
27 January 2020
End
31 August 2020
Abbreviation
20201
Exam
Exam type
ordinær
Internal/External
ekstern censur
Grade Scale
7-trinsskala
Exam Language
GB
Abstract
The course gives an introduction and overview of data engineering techniques.
Description

A data ‘revolution’ is underway, one that is already reshaping how knowledge is produced, business conducted, and governance enacted. Data has traditionally been time-consuming and costly to generate, analyse and interpret, and generally provided a relatively static and coarse snapshot of phenomena.

This state of affairs is changing now. Rather than being scarce and limited in scope, the production of data is increasingly becoming a ‘deluge’ i.e. a wide flow of real-time, varied, resolute and relational data that are relatively low in cost. 

Outside of business, data is increasingly becoming open as well. This data abundance (as opposed to data scarcity) is reshaping how we work with, circulate, trade, analyse and exploit data. This development is founded on the latest wave of information and communication technologies such as the plethora of digital devices encountered in homes, workplaces and public spaces as well as mobile, distributed and cloud computing; social media, and inter-worked sensors and devices. 

These technical infrastructures are leading to evermore aspects of everyday life – work, consumption, travel, communication, and leisure – being captured as data. Moreover, they are re-configuring the production, circulation and interpretation of data, producing what has been termed ‘big data’. 

The students will gain an understanding of the technical aspects of data management and the opportunities and risks they create for organisations.

During the course the students will relate to the (changing) nature of database use and design, including:
  • Data representation and modelling 
  • Data storage and retrieval 
  • Data Engineering and Big Data Processes 
  • Architecture of Unbundled Data Systems
Intended learning outcomes

After the course, the student should be able to:

  • Explain the difference between the relational and non-relational data models
  • Describe the architecture and components of a database system
  • Design an ER model and a relational model in a concrete scenario
  • Define SQL queries in a concrete scenario
  • Define Python programme for batch data processing
Ordinary exam
Exam type:
A: Written exam on premises, external (7-trinsskala)
Exam variation:
A11: Written exam on premises. Open book exam.
Exam description:
D