Academic year
2018-19
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.2019 ()
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 SQL statements for a demand for information
is familiar with XML technologies
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
Contents
SQL: DML, DDL, triggers, Stored procedures, CTE, UDT
XML
Datawarehousing
Transactions
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.
Teaching methods
Learning dialogue
Practice session
Assignment
Organisation of education
Teaching conversation
Practica:guided individual exercises on computer
Study guidance
Individual learning problems can always be communicated to the lecturer and remedied.
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 |
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 |
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)
Other study materials
Software:
SQLServer
Visual studio
Via Chamilo:
Slides
Additional documents: students are free to print these documents
Recommended books:
Database Systems - Thomas M. Connolly & Carolyn E. Begg – ISBN: 9781292061184
Introduction to SQL - Rick Van Der Lans - ISBN 9780321305961
Effective SQL: 61 Specific Ways to Write Better SQL - Ben G. Clothier, Douglas J. Steele, John L. Viescas - ISBN:9780134578897
Study costs
Microsoft Imagine Premium: max 20 euro.
Guest colleges: 0,5 euro.
Printing costs for the documents.
Students are free to buy the recommended books at market value.
When participating in the exchange project: max 400 euro.
Key words
Databases, SQL, DBMS, RDBMS, Transactions, datawarehousing, XML
IWETO-code: P175- Computer technology