All programmes > Principles of Database Management

Principles of Database Management (B-KUL-D0I62A)

6 ECTSEnglish45 First termCannot be taken as part of an examination contract
Lemahieu Wilfried (coordinator) |  Baesens Bart |  N.
OC Handelsingenieur en Handelsingenieur in de beleidsinformatica FEB Campus Leuven

Aims

At the end of this course the student:

• is capable of applying methods and techniques to model data requirements within a specific business context (data modelling)
• knows how to model data requirements using ER, EER, relational and UML models
• is capable of developing software solutions to query data models in an efficient way
• knows how to design and evaluate database systems and data warehouses in a networked environment

Previous knowledge

At the beginning of this course the student should be able to understand the basic principles of Management Information Systems. Previous knowledge of programming may be helpful, but is not a requirement.

Identical courses

This course is identical to the following courses:
I0D42B : Database Management (No longer offered this academic year)

Is included in these courses of study

Activities

6 ects. Principles of Database Management (B-KUL-D0I62a)

6 ECTSEnglishFormat: Lecture45 First term
Baesens Bart |  N.
OC Handelsingenieur en Handelsingenieur in de beleidsinformatica FEB Campus Leuven

Content

The course consists of two parts:

• Part 1:  Basic concepts of databases, conceptual data modeling, logical database design, relational databases (prof. Baesens)
• Part 2: Transaction management, web-based and other database architectures, data warehousing (prof. Lemahieu)

Course outline:

Part 1:
• Introduction
• Fundamental concepts regarding data management
• Architecture and classification of database management systems
• Data models for database management
• Logical database design
• Database languages in a relational environment
Part 2:
• Universal interfaces to relational database systems
• Transactions, recovery and concurrency control
• Web-database connectivity and database systems in an n-tier environment
• Data warehousing

Course material

Used Course Material
* Handbook: Lemahieu W., vanden Broucke S. and Baesens B., 2018, Principles of Database Management, Cambridge University Press
* Use of Toledo for extra course material  (slides, reader).
* Course material consists primarily of what has been taught during lectures

Toledo

* Toledo is being used for this learning activity.
 

Format: more information

The course is taught on-line, and if the situation allows, classroom exercises will be provided.

The focus of this course is on explaining the learning content. Students are expected to critically and thoroughly study the theory and examples that are presented during the lectures.

During the semester, students have to make one assignment.

 

Evaluation

Evaluation: Principles of Database Management (B-KUL-D2I62a)

Type : Partial or continuous assessment with (final) exam during the examination period
Description of evaluation : Oral, Written, Take-Home
Type of questions : Multiple choice
Learning material : None

Explanation


Features of the evaluation

  • The final examination during the examination period involves a multiple choice exam.
  • There will be a take home exam (one assignment) whose term and deliverance (individual/group, written/oral, …)  and deadline will be communicated by the lecturer (titularis) via Toledo and during the first lecture.

Determination of final grades

  • The grades are determined by the lecturer(s) as communicated via Toledo and stated in the examination schedule. The result is calculated and communicated as a number on a scale of 20.
  • The take home assignment is graded and accounts for 20%, while the final exam accounts for the remaining 80%.
  • If the student does not participate in the final examination, the final grade of the course will be NA (not taken). If the student does not participate in the take home exam the grades for this partial evaluation will be a 0-grade within the calculations of the final grade.
  • If the set deadline was not respected, the grade for that respective part will be a 0-grade in the final grade, unless the student asked the lecturer to arrange a new deadline. This request needs to be motivated by grave circumstances.

Second examination opportunity

  • The features of the evaluation and determination of grades are similar to those of the first examination opportunity, as described above.
  • At the second examination opportunity, the take home exam can be handed in again (in case the student made corrections to the original). The grade will be determined and calculated as in the first examination opportunity.

Information about retaking exams

* See ‘Explanation’ for further information regarding the second examination opportunity.