Database Use and Design (Spring 2024)
Official course description:
Course info
Programme
Staff
Course semester
Exam
Abstract
In this course, students learn to design and build a database and to make use of databases in business applications.Description
In the era of the data revolution, data are everywhere and have become a key resource for many organizations. Although the abundance of data creates new possibilities for organizations, harnessing many of these possibilities requires foundational skills in analyzing data structures, designing and building databases of various types, and designing and building programmes that make use of databases.
This course is designed to help students acquire these foundational skills. While the course will emphasize business informatics skills such as conceptualizing organizational data structures through entity-relationship models, the students will also have the opportunity to expand technical skills acquired in the Introduction to Programming by building database-enabled business applications. The students will also learn about contemporary database design issues such as cybersecurity and architecture of database-enabled cloud-based applications.
Formal prerequisites
Python programming is a prerequisite.
This course is part of the second semester in the bachelor's degree in Global Business Informatics.
Intended learning outcomes
After the course, the student should be able to:
- Explain the difference between the relational and non-relational data models for various use cases
- Describe the architecture and components of a database system
- Design an ER model and a relational model for a concrete use case
- Define SQL queries in a concrete use cases
- Design and build a database-based program
- Design database architecture using cybersecurity best practices
- - Identify and evaluate how emerging technologies (e.g., IoT) can be integrated into databases and dataflows to help achieve sustainable development goals
Learning activities
Lectures, videos, quizzes, class exercises on data modeling, coding exercises in SQL and Python, working on an application development project, supervision.
Course literature
The course literature is published in the course page in LearnIT.
Student Activity Budget
Estimated distribution of learning activities for the typical student- Preparation for lectures and exercises: 20%
- Lectures: 15%
- Exercises: 15%
- Project work, supervision included: 30%
- Exam with preparation: 20%
Ordinary exam
Exam type:D: Submission of written work with following oral, External (7-point scale)
Exam variation:
D2G: Submission for groups with following oral exam supplemented by the submission. Shared responsibility for the report.
Group project report of 5,000-8,000 words in total.
Students may use ChatGPT and other AI tools as supplementary resources, but the core of your learning should be based on your own efforts and engagement with the course material. This approach will not only lead to a more meaningful learning experience but also prepare you better for real-world database challenges.
You will be gauged on your understanding of your Database project during your oral examination and an over reliance on AI tolls can be detrimental to your learning, your career, and your grade.
Group
- 5-6 students per group
20 minutes
Individual exam : Individual student presentation followed by an individual dialogue. The student is examined while the rest of the group is outside the room.
reexam
Exam type:D: Submission of written work with following oral, External (7-point scale)
Exam variation:
D2G: Submission for groups with following oral exam supplemented by the submission. Shared responsibility for the report.
Group project report of 5,000-8,000 words in total.
Students may use ChatGPT and other AI tools as supplementary resources, but the core of your learning should be based on your own efforts and engagement with the course material. This approach will not only lead to a more meaningful learning experience but also prepare you better for real-world database challenges.
You will be gauged on your understanding of your Database project during your oral examination and an over reliance on AI tolls can be detrimental to your learning, your career, and your grade.
Group
- 1-6 students per group
20 minutes
Individual exam : Individual student presentation followed by an individual dialogue. The student is examined while the rest of the group is outside the room.
Time and date
Ordinary Exam - submission Tue, 21 May 2024, 08:00 - 14:00Ordinary Exam Mon, 3 June 2024, 09:00 - 18:00
Ordinary Exam Tue, 4 June 2024, 09:00 - 18:00
Ordinary Exam Thu, 6 June 2024, 09:00 - 18:00
Ordinary Exam Fri, 7 June 2024, 09:00 - 18:00
Reexam - submission Wed, 24 July 2024, 08:00 - 14:00
Reexam Mon, 12 Aug 2024, 09:00 - 18:00