Hogeschool Gent
Geraard de Duivelstraat 5 - 9000 Gent
Tel: 09 243 33 33 - E-mail: info@hogent.be
Website: www.hogent.be
Databases and Transaction systems31483/3977/1718/1/39
Study guide

Databases and Transaction systems

31483/3977/1718/1/39
Academic year 2017-18
Is found in:
  • International Curriculum, programme stage 3
In other study programme:
  • Bachelor of Applied Computer Science 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.2017 ()

Organisation of education

Teaching Activities, Learning Activities, Assessment Activities
Lecture
Self-study64,00 hours
Seminar12,00 hours
Supervised independent work24,00 hours
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

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 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

  • Exercises
  • 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
MomentForm%Remark
PeriodicOther100,00Presentation of the developed application
Evaluation(s) for re-sit exam
MomentForm%Remark
PeriodicOther100,00Defence of the developed application for the lecturer (individual assignment)

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

Study costs

The student may buy the recommended book(s).

Key words

Mainframe – DB2 – CICS – Transactions - Databases 

IWETO-code: P175 – informatica