English   Danish

2019/2020  BA-BINTV2002U  Database Theories and Applications

English Title
Database Theories and Applications

Course information

Language English
Course ECTS 7.5 ECTS
Type Elective
Level Bachelor
Duration One Semester
Start time of the course Autumn
Timetable Course schedule will be posted at calendar.cbs.dk
Max. participants 120
Study board
Study Board for BSc/MSc in Business Administration and Information Systems, BSc
Course coordinator
  • Weifang Wu - Department of Digitalisation
Main academic disciplines
  • Information technology
Teaching methods
  • Blended learning
Last updated on 05-02-2019

Relevant links

Learning objectives
After completing the course, students should be able to do:
  • Use relational algebra to express database queries
  • Use SQL to interact with database management systems
  • Design appropriate database tables, using functional dependencies and normal forms
  • Understand, compare, and implement the fundamental query processing algorithms
  • Understand, compare, and implement the fundamental transaction processing algorithms
  • Understand the practice of data recovery
  • Interpret and comparatively criticize database system architectures
Course prerequisites
Basic programming skills are required
Database Theories and Applications:
Exam ECTS 7,5
Examination form Oral exam based on written product

In order to participate in the oral exam, the written product must be handed in before the oral exam; by the set deadline. The grade is based on an overall assessment of the written product and the individual oral performance.
Individual or group exam Individual oral exam based on written group product
Number of people in the group 3-4
Size of written product Max. 15 pages
Assignment type Project
Written product to be submitted on specified date and time.
20 min. per student, including examiners' discussion of grade, and informing plus explaining the grade
Grading scale 7-point grading scale
Examiner(s) Internal examiner and second internal examiner
Exam period Winter
Make-up exam/re-exam
Same examination form as the ordinary exam
Course content, structure and pedagogical approach

Much of the world's data resides in databases, including the companies 'data and websites' data. As big data is becoming an important element in the way that organizations are delivering high volume data, successful database management becomes more critical to organizations. This course is on the design and implementation of database management systems. The purpose of the course is to introduce database related concepts and help you learn and apply knowledge of the database management. The emphasis in this course is on hands-on and practical learning. As such, you will work with real databases, real data science tools, and real-world datasets. We will discuss topics related to the problem of managing and using large-scale data sets, including data models (relational vs. non-relational), indexing (trees, hash tables), High-velocity transaction processing, real-time analytics, and high-volume data processing. Basic programming skills are required.

Description of the teaching methods
Lectures and exercises will be used based on real cases and real data.
Course materials and quiz will be provided and conducted online.
Feedback during the teaching period
Feedback to the students' projects will be offered during the course.
Student workload
Lectures 30 hours
Hands-on exercises 15 hours
Class preparation 70 hours
Assignments 25 hours
Exam and preparation for Exam 66 hours
Total 206 hours
Expected literature

The literature can be changed before the semester starts. Students are advised to find the  final literature on LEARN before they buy the books.

Last updated on 05-02-2019