2019/2020
BA-BINTV2002U Database Theories and Applications
| English Title |
| Database Theories and
Applications |
|
|
| 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 |
|
|
| Teaching
methods |
|
|
|
Last updated on
05-02-2019
|
| 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 |
| Examination |
|
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 |
| Duration |
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
Permalink