Academic year
2016-17
Is found in:
- International Curriculum, programme stage 2
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.2017 ()
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: Dutch
Scheduled for: Semester 2
Objectives
The student is able to set up a database and to execute the simple management actions as a service to the endusers of the database.
The student is able to query a database using SQL
The student is able to use XML to handle semi-structured data in a database environment.
Contents
SQL: DML, DDL, DCL
Multi-user RDBMS: transactions, cursors, triggers, stored procedures
XML: XML Document, XML Schema,
Datawarehousing
Order of enrolment
There are no prerequisites for this course.
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
Individual learning problems can always be communicated to the lecturer and remedied.
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 costs
Study book at market value.
Cost of the printed material.
Key words
Databases, SQL, DBMS, RDBMS, Transactions, datawarehousing, XML
IWETO-code: P175- Computer technology