Academic year
2019-20
Is found in:
- International Curriculum, programme stage 2
In other study programme:
-
Bachelor of Applied Information Technology as Databases II
-
Bachelor of Applied Information Technology as Databases II
-
Bachelor of Applied Information Technology as Databases II
-
Bachelor of Applied Information Technology as Databases II
This is a single course unit.
Study load:
4 credits
Weight:
4,00
Total study time: 100,00 hours
Possible deadlines for learning account: 15.03.2020 ()
Organisation of education
This course unit is marked out of 20 (rounded to an integer).
Re-sit exam: is possible.
It is not possible to enrol in this course unit under
- exam contract (to obtain a credit).
- exam contract (to obtain a degree).
Special admission is required to enrol in this course unit under credit contract.
Co-ordinator: Decorte Johan
Language course: No
Languages: English
Scheduled for: Semester 2
Objectives
is able to set up and to manage relational databases
is able to elaborate SQL procedures
is able to elaborate complex query statements
is able to write the appropiate and performant SQL statements for a demand for information
is able to explain datawarehousing and datamarts
is able to explain the advantage of using transactions by the (concurrent) use of databases
is able to explain the recovery of a transaction
is able to handle data exchange formats
Contents
SQL: DML, DDL, triggers, Stored procedures, CTE, UDT
Datawarehousing
Transactions
Data exchange formats
Order of enrolment
There are no prerequisites for this course.
Prerequisites
Knowledge of database design: EERD and normalization.
Basic knowledge of SQL: inner join, grouping, aggregate functions
Final objectives
The student is able to analyze complex information and process it into the most suitably structured database solution that he/she efficiently manages in view of performance |
Final objectives
Partial competence 1: Is able to work with a multi-user RDBMS in an easy way. (TI05 en TI06)
Indicators:
1.1 Is able to set up a relational database.
1.2 Is able to manage a relational DB
1.3 Is able to query a relational database using SQL
1.4 Is able to secure a relational database.
Partial competence 2: To be familiar with the limits of relational database systems and with the object-relational gap (TI03)
Indicators:
2.1. Is able to discuss the object-relational gap
2.2. Is able to explain solutions to eliminate the object-relational gap.
Partial competence 3: To describe semi-structured data using XML (TI01)
Indicators:
3.1 To be familiar with XMl and XML-related technologies
3.2 Is able to write an XML document
3.3 Is able to write an XML schema
Partial competence 4: Knows techniques to manage large databases (TI10)
Indicators:
4.1 Knowledge of distributed databases
4.2 Knowledge of datawarehousing
4.3 Knowledge of datamarts
Partial competence 5: to obtain and handle information (AC6)
Indicators:
5.1 Is able to translate information to the right SQL statements.
Organisation of education
Teaching conversation
Practica:guided individual exercises on computer
Study guidance
The students get
• practical guidance whereby guidance and learning is learned from the experiences of others (supervision)
• the possibility to consult the teacher for a specific substantive problem (consultation)
Evaluation
Evaluation(s) for first exam chance
Moment | Form | % | Remark |
Non-periodic | Other | 30,00 | Assignment, See evaluation card on Chamilo
|
Periodic | Written examination | 40,00 | Closed-book exam |
Periodic | Written examination | 30,00 | open questions on PC (reference material digitally available)
|
Evaluation(s) for re-sit exam
Moment | Form | % | Remark |
Periodic | Written examination | 40,00 | Closed-book exam |
Periodic | Written examination | 60,00 | open questions on PC (reference material digitally available)
|
Evaluation
- First exam session:
- Non-period bound evaluation: 15% (test on PC)
- Period bound evaluation: 85% (partially written-closed book, partially on PC)
- Second exam session:
- 100% (partially written-closed book, partially on PC)
Study materials
1. Mandatory books
Principles of Database ManagementMandatory - Author: Wilfried Lemahieu, Seppe vanden Broucke, Bart Baesens
- Publisher: Cambridge University Press
- Edition: Laatste versie
- ISBN-nr: 978-11-071-8612-5
Other study materials
Software:
SQLServer
Visual studio
Via Chamilo:
Slides
Additional documents
Recommended books:
Effective SQL: 61 Specific Ways to Write Better SQL - Ben G. Clothier, Douglas J. Steele, John L. Viescas - ISBN:9780134578897
Key words
Databases, SQL, DBMS, RDBMS, Transactions, datawarehousing, XML
IWETO-code: P175- Computer technology