Courses Bachelor Display 2021-2022

Course Description To PDF
Course title Database Management
Course code EBC2179
ECTS credits 6,5
Assessment Whole/Half Grades
Period
Period Start End Mon Tue Wed Thu Fri
4 31-1-2022 25-3-2022 X X
Level no level
Coordinator Ron Triepels
For more information: r.triepels@maastrichtuniversity.nl
Language of instruction English
Goals
* Data modeling, SQL, dimensional modeling, normalization, and data security.
* Students apply problem solving approaching to exercises from the book and the course manual and develop relevant and creative soluations. Also, they apply their knowledge to their final project.
* By learning a structured method to design data models the students are able to find the best possible solution to a given database problem.
* When trying to design data bases there are often more then one solution possible. Through discussions in the class rooms students are sensitized for the advantages or disadvantages of the various options.
* Students learn to design data bases that work efficiently and effectively.
* During the meeting on data security and privacy the impact of data management and collection on individuals and society is explicitely discussed. Also, during guest lectures theses topics are often discussed.
* The students are motivated to participate in the classrooom discussion either as a discussion leader or a participant. The work on the final paper develops the students written communication skills.
* By letting the students play discussion leader during tutorial meetings they are motivated to take control of their own learning process.
* The students work in subgroups for their final paper and for the discussion leader role.
Description
The aim of this course is to introduce students to the theoretical and practical issues related to database management. This includes designing databases using data modelling, querying databases using SQL and understanding the underlying theoretical issues. In addition, we will discuss some data issues from a managerial perspective. The first part of the course will focus on the theoretical and practical issues of designing and using relational databases, which are the foundation of most data management systems in organisations. The concepts of relational databases will be the main emphasis of the course. However, the course will also cover non-relational models, such as dimensional solutions. The second part of the course will be dealing with new trends and approaches to problems in modern web-driven organisations.

Formative assessment: Feedback by tutors and peers
Summative assessment: Exam, participation, final project presentation and report, subgroup work for final paper and discussion leader role
Instructional approach: Tutorial meetings organized by the students, guest lectures
Literature
Prerequisites
Keywords
Teaching methods (indicative; course manual is definitive)
Assessment methods (indicative; course manual is definitive) Written Exam
Evaluation in previous academic year For the complete evaluation of this course please click "here"
This course belongs to the following programmes / specialisations
Bachelor Business Analytics Year 2 Compulsory Course(s)