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 |
|
|||||||||||||||||||||||||||||||||||||||
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 |
|