Academic year
2018-19
Is found in:
- International Curriculum, programme stage 3
In other study programme:
-
Bachelor of Applied Information Technology as Databases and Transaction systems
-
Bachelor of Applied Information Technology as Databases and Transaction systems
-
Bachelor of Applied Information Technology as Databases and Transaction systems
-
Bachelor of Applied Information Technology as Databases and Transaction systems
This is a single course unit.
Study load:
4 credits
Weight:
4,00
Total study time: 100,00 hours
Possible deadlines for learning account: 01.12.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: Lievens Stijn
Other teaching staff: Van Achter Angeline
Language course: No
Languages: English
Scheduled for: Semester 1
Objectives
Is able to develop, debug and execute transactions;
Is able to discuss, maintain and optimize existing transactions.
Is able to create database objects;
Is able to modify existing database objects;
Is able to execute DML and DDL statements using SPUFI;
Is able to manipulate (read, add or update) data in a relational database from a Cobol program.
Is able to deliver user-friendly and flexible solutions (re-usable, adaptable, maintainable) in accordance with the client’s requirements
Contents
Transactional systems : CICS
DB2: Database objects
Using databases from a Cobol program.
Order of enrolment
There are no prerequisites for this course.
Prerequisites
Knowledge of software development and relational databases.
Only in combination with ‘Introduction to the Mainframe’ and ‘Batch applications’.
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 develop CICS transactions.(TI01)
Indicators:
- Is able to develop, debug and execute transactions;
- Is able to discuss, maintain and optimize existing transactions.
Partial competence 2: Is able to manage a DB2 database.(TI05)
Indicators:
- Is able to create database objects;
- Is able to modify existing database objects;
- Is able to execute DML and DDL statements using SPUFI.
Partial competence 3: Is able to use a DB2 database from a Cobol program. (TI01)
Indicators:
- Is able to manipulate (to read, to add or to update) data in a relational database from a Cobol program.
Partial competence 4: To aim at task fulfilment to a high standard in order to achieve results that meet the requirements. (ABC2)
Indicators:
- To act professionally and functionally;
- To deliver user-friendly and flexible solutions (re-usable, adaptable, maintainable);
- To act in accordance with the client’s requirements
Teaching methods
Practice session
Assignment
Organisation of education
Teaching conversation with exercises.
Study guidance
Individual learning problems may always be reported to the lecturer and will be remedied.
Students are guided and coached
Developing the project, students are guided and coached.
Evaluation
Evaluation(s) for first exam chance
Moment | Form | % | Remark |
Non-periodic | Observation of performance of the student | 20,00 | See evaluation card on Chamilo
|
Periodic | Other | 80,00 | Oral defence assignment (See evaluation card on Chamilo)
|
Evaluation(s) for re-sit exam
Moment | Form | % | Remark |
Periodic | Observation of performance of the student | 20,00 | No second exam opportunity will be organized. If a student did not pass for the first exam opportunity, the assessment for this evaluation form or the absence for this evaluation form will remain valid for the second exam opportunity.
|
Periodic | Other | 80,00 | individual assignment (See details in evaluation card on Chamilo)
|
Evaluation
- First exam session:
- non-period bound evaluation: 100% students will develop a project independently and will present the result
- period bound evaluation: 0%
- Second exam session:
- 100% students will develop a project independently and will present the result
Other study materials
Software: 3270 emulator.
Chamilo: tasks and additional documents.
Recommended books: Redbooks IBM; available online.
Study costs
Software: 3270 emulator (free)
Tasks and additional documents. These may be printed by the students at their own expense.
Recommended books: IBM redbooks. Available online (free).
Key words
Mainframe – DB2 – CICS – Transactions - Databases
IWETO-code: P175 – informatica