Academic year
2017-18
Is found in:
- International Curriculum, programme stage 2
In other study programme:
-
Bachelor of Applied Computer Science 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.2018 ()
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 compose XML documents and schemas
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: XML Document, XML Schema
Datawarehousing
Transactions
Order of enrolment
There are no prerequisites for this course.
Prerequisites
The arrangements regarding prerequisites applied for this course unit are in the Faculty’s educational and examination regulations (FOER).
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
Exercises
Learning dialogue
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 | 15,00 | Quoted exercise on PC |
| Periodic | Other | 45,00 | Written exam: open questions on PC |
| Periodic | Written examination with a combination of open-ended and/or closed-ended questions | 40,00 | Closed-book exam |
Evaluation(s) for re-sit exam
| Moment | Form | % | Remark |
| Periodic | Other | 45,00 | Written exam: open questions on PC |
| Periodic | Written examination with a combination of open-ended and/or closed-ended questions | 55,00 | Closed-book exam |
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