Bedrijfsinformatica Prof.
Alexandre Thys
Table of Contents
1 – Inleiding & Doel van de cursus...................................................................................................................................... 6
2- Basic Concepts........................................................................................................................................................................ 7
Wat is hardware ?.................................................................................................................................................................. 7
Wat is software ?.................................................................................................................................................................... 8
Wat zijn databanken ? ......................................................................................................................................................... 9
Wat zijn Netwerken? ......................................................................................................................................................... 14
Wat zijn Servers ? ............................................................................................................................................................... 16
Wat is Internet ? .................................................................................................................................................................. 17
Wat is Computer Architecture? .................................................................................................................................... 18
Evolutie van Computer Architecture .................................................................................................................... 19
Wat zijn Processen ?.......................................................................................................................................................... 21
Wat zijn algoritmes ?......................................................................................................................................................... 25
Wat is een informatiesysteem ? ................................................................................................................................... 22
Internet of Things (IoT) ................................................................................................................................................... 23
3- Algoritmes ............................................................................................................................................................................. 24
Geef de 8 stappen bij het programmeren ................................................................................................................ 24
Leg uit : Probleemdefinitie ........................................................................................................................................ 24
Leg uit : Oplossingsstrategie ..................................................................................................................................... 24
Leg uit : Voorstelling van het algoritme............................................................................................................... 24
Leg uit : Programmeren .............................................................................................................................................. 24
Wat is Compileren? ....................................................................................................................................................... 24
Wat gebeurd er bij het testen? ................................................................................................................................. 25
Leg uit : Documenteren ............................................................................................................................................... 25
Leg uit : Onderhoud ...................................................................................................................................................... 25
Hoe stel je algoritmes voor ? ......................................................................................................................................... 21
Wat is een Organigram?.............................................................................................................................................. 21
Sequenties.............................................................................................................................................................................. 26
Definitie.............................................................................................................................................................................. 26
Oefening 1 ......................................................................................................................................................................... 22
Oefening 2 ......................................................................................................................................................................... 22
Oefening 3 ......................................................................................................................................................................... 24
1
, SELECTIE (= voorwaardelijke opdracht) ................................................................................................................. 26
Definitie.............................................................................................................................................................................. 26
If then .................................................................................................................................................................................. 26
If then else......................................................................................................................................................................... 26
Case ...................................................................................................................................................................................... 26
ITERATIE (= herhalingsopdracht = loop) ................................................................................................................ 27
Definitie.............................................................................................................................................................................. 27
WHILE................................................................................................................................................................................. 27
REPEAT .............................................................................................................................................................................. 27
FOR....................................................................................................................................................................................... 28
Oefening 1 ......................................................................................................................................................................... 27
Oefening met Ingenestelde IF’s ............................................................................................................................... 29
Examenvraag : Algoritmes......................................................................................................................................... 30
4- Programmeren .................................................................................................................................................................... 28
Python in een notedop ..................................................................................................................................................... 30
Datatypes voor variabelen ............................................................................................................................................. 31
Hoe type van een variabele kennen? .................................................................................................................... 32
Delen door nul & soorten fouten ............................................................................................................................ 32
Variable names ............................................................................................................................................................... 32
Overschakelen van types............................................................................................................................................ 33
Andere built-in functies .............................................................................................................................................. 33
Operators ............................................................................................................................................................................... 34
Arithmetic Operators ................................................................................................................................................... 34
Assignment Operators ................................................................................................................................................. 34
Comparison Operators ................................................................................................................................................ 35
Logical Operators .......................................................................................................................................................... 35
Booleans ................................................................................................................................................................................. 35
Strings...................................................................................................................................................................................... 36
Create a string ................................................................................................................................................................. 36
Escape Characters ......................................................................................................................................................... 37
String Operators : + en * ............................................................................................................................................. 37
Lengte van een string berekenen ........................................................................................................................... 38
String-methodes............................................................................................................................................................. 38
Format-methode voor strings.................................................................................................................................. 39
Input & Print Functie ........................................................................................................................................................ 40
Selecties .................................................................................................................................................................................. 41
Controle statement – IF .............................................................................................................................................. 41
2
, Elif ........................................................................................................................................................................................ 41
Else ....................................................................................................................................................................................... 41
Else without elif.............................................................................................................................................................. 42
Ternary Operators or Conditional Expressions ............................................................................................... 42
Iteraties................................................................................................................................................................................... 45
While-Loop ....................................................................................................................................................................... 45
Oefeningen op de While .............................................................................................................................................. 46
FOR-Loop .......................................................................................................................................................................... 48
Generation programming languages ......................................................................................................................... 28
First-generation programming language............................................................................................................ 28
Second-generation programming language ...................................................................................................... 30
Third-generation programming language .......................................................................................................... 31
“holy grail” : express program in “everyday language” ................................................................................ 31
Traditional programming concepts ........................................................................................................................... 32
Data types ......................................................................................................................................................................... 32
De Primitieven ................................................................................................................................................................ 40
Oefeningen Programmeren............................................................................................................................................ 53
Oefening 1 ......................................................................................................................................................................... 64
Oefening 2 ......................................................................................................................................................................... 65
Oefening 3 ......................................................................................................................................................................... 65
Oefening 4 ......................................................................................................................................................................... 65
Oefening 5 : Examenvraag ......................................................................................................................................... 66
Oefening 6 : Examenvraag : functie in een functie ! ....................................................................................... 67
Input – Output Questions ........................................................................................................................................... 68
Transform next FOR-code with a while? -> Examenvraag .......................................................................... 73
Examenvraag Algoritmes in Python ...................................................................................................................... 74
5- Functionaliteiten ................................................................................................................................................................ 70
Process Modelling .............................................................................................................................................................. 70
Elementen ......................................................................................................................................................................... 70
Overview Flow objects ................................................................................................................................................ 81
Overview Connecting objects ................................................................................................................................... 82
Overview Swim lanes................................................................................................................................................... 82
Overview Artifacts ........................................................................................................................................................ 82
BPMI.iO............................................................................................................................................................................... 83
Use Cases ................................................................................................................................................................................ 83
Use Case diagrams......................................................................................................................................................... 83
Elementen ......................................................................................................................................................................... 83
3
, 6- Project Management (is ook een algoritme) .......................................................................................................... 89
Views........................................................................................................................................................................................ 89
Creating a Project ............................................................................................................................................................... 89
Inleidend voorbeeld met MS Project..................................................................................................................... 89
Applicatie : Project Libre ................................................................................................................................................. 91
Step 1: Creating a project ........................................................................................................................................... 91
Step 2 : Creating a Task List ...................................................................................................................................... 92
Step 3 : Setting up Resources ................................................................................................................................... 96
Step 4 : Assign Resources to Tasks ........................................................................................................................ 99
Other functionalities ..................................................................................................................................................102
7- Databanken.........................................................................................................................................................................104
Excel : voorbeeld van databank .................................................................................................................................104
Access : Voorbeeld van een relationele databank ..............................................................................................104
Data Modellering ..............................................................................................................................................................106
5.1 Classes (= tabellen) ..................................................................................................................................................106
Class Diagrams..............................................................................................................................................................106
Wat bevat een Class Diagram ? ..............................................................................................................................106
Klasse ................................................................................................................................................................................106
Associatie ........................................................................................................................................................................106
Multipliciteit ..................................................................................................................................................................107
Attributen........................................................................................................................................................................107
Associatie Klassen .......................................................................................................................................................108
Compositie ......................................................................................................................................................................112
Aggregatie .......................................................................................................................................................................112
Generalisatie ..................................................................................................................................................................112
5.2 Databases......................................................................................................................................................................114
Definitie............................................................................................................................................................................114
From Class to Table ....................................................................................................................................................114
First normal form (1NF) ...........................................................................................................................................114
Column Types................................................................................................................................................................115
Keys ...................................................................................................................................................................................116
Primary Key ...................................................................................................................................................................116
Mapping associations with multiplicity 1 .........................................................................................................117
Mapping other associations ....................................................................................................................................118
Instanties (records) ....................................................................................................................................................119
Database met Power BI.............................................................................................................................................121
Oefeningen HOC ...........................................................................................................................................................121
4
Alexandre Thys
Table of Contents
1 – Inleiding & Doel van de cursus...................................................................................................................................... 6
2- Basic Concepts........................................................................................................................................................................ 7
Wat is hardware ?.................................................................................................................................................................. 7
Wat is software ?.................................................................................................................................................................... 8
Wat zijn databanken ? ......................................................................................................................................................... 9
Wat zijn Netwerken? ......................................................................................................................................................... 14
Wat zijn Servers ? ............................................................................................................................................................... 16
Wat is Internet ? .................................................................................................................................................................. 17
Wat is Computer Architecture? .................................................................................................................................... 18
Evolutie van Computer Architecture .................................................................................................................... 19
Wat zijn Processen ?.......................................................................................................................................................... 21
Wat zijn algoritmes ?......................................................................................................................................................... 25
Wat is een informatiesysteem ? ................................................................................................................................... 22
Internet of Things (IoT) ................................................................................................................................................... 23
3- Algoritmes ............................................................................................................................................................................. 24
Geef de 8 stappen bij het programmeren ................................................................................................................ 24
Leg uit : Probleemdefinitie ........................................................................................................................................ 24
Leg uit : Oplossingsstrategie ..................................................................................................................................... 24
Leg uit : Voorstelling van het algoritme............................................................................................................... 24
Leg uit : Programmeren .............................................................................................................................................. 24
Wat is Compileren? ....................................................................................................................................................... 24
Wat gebeurd er bij het testen? ................................................................................................................................. 25
Leg uit : Documenteren ............................................................................................................................................... 25
Leg uit : Onderhoud ...................................................................................................................................................... 25
Hoe stel je algoritmes voor ? ......................................................................................................................................... 21
Wat is een Organigram?.............................................................................................................................................. 21
Sequenties.............................................................................................................................................................................. 26
Definitie.............................................................................................................................................................................. 26
Oefening 1 ......................................................................................................................................................................... 22
Oefening 2 ......................................................................................................................................................................... 22
Oefening 3 ......................................................................................................................................................................... 24
1
, SELECTIE (= voorwaardelijke opdracht) ................................................................................................................. 26
Definitie.............................................................................................................................................................................. 26
If then .................................................................................................................................................................................. 26
If then else......................................................................................................................................................................... 26
Case ...................................................................................................................................................................................... 26
ITERATIE (= herhalingsopdracht = loop) ................................................................................................................ 27
Definitie.............................................................................................................................................................................. 27
WHILE................................................................................................................................................................................. 27
REPEAT .............................................................................................................................................................................. 27
FOR....................................................................................................................................................................................... 28
Oefening 1 ......................................................................................................................................................................... 27
Oefening met Ingenestelde IF’s ............................................................................................................................... 29
Examenvraag : Algoritmes......................................................................................................................................... 30
4- Programmeren .................................................................................................................................................................... 28
Python in een notedop ..................................................................................................................................................... 30
Datatypes voor variabelen ............................................................................................................................................. 31
Hoe type van een variabele kennen? .................................................................................................................... 32
Delen door nul & soorten fouten ............................................................................................................................ 32
Variable names ............................................................................................................................................................... 32
Overschakelen van types............................................................................................................................................ 33
Andere built-in functies .............................................................................................................................................. 33
Operators ............................................................................................................................................................................... 34
Arithmetic Operators ................................................................................................................................................... 34
Assignment Operators ................................................................................................................................................. 34
Comparison Operators ................................................................................................................................................ 35
Logical Operators .......................................................................................................................................................... 35
Booleans ................................................................................................................................................................................. 35
Strings...................................................................................................................................................................................... 36
Create a string ................................................................................................................................................................. 36
Escape Characters ......................................................................................................................................................... 37
String Operators : + en * ............................................................................................................................................. 37
Lengte van een string berekenen ........................................................................................................................... 38
String-methodes............................................................................................................................................................. 38
Format-methode voor strings.................................................................................................................................. 39
Input & Print Functie ........................................................................................................................................................ 40
Selecties .................................................................................................................................................................................. 41
Controle statement – IF .............................................................................................................................................. 41
2
, Elif ........................................................................................................................................................................................ 41
Else ....................................................................................................................................................................................... 41
Else without elif.............................................................................................................................................................. 42
Ternary Operators or Conditional Expressions ............................................................................................... 42
Iteraties................................................................................................................................................................................... 45
While-Loop ....................................................................................................................................................................... 45
Oefeningen op de While .............................................................................................................................................. 46
FOR-Loop .......................................................................................................................................................................... 48
Generation programming languages ......................................................................................................................... 28
First-generation programming language............................................................................................................ 28
Second-generation programming language ...................................................................................................... 30
Third-generation programming language .......................................................................................................... 31
“holy grail” : express program in “everyday language” ................................................................................ 31
Traditional programming concepts ........................................................................................................................... 32
Data types ......................................................................................................................................................................... 32
De Primitieven ................................................................................................................................................................ 40
Oefeningen Programmeren............................................................................................................................................ 53
Oefening 1 ......................................................................................................................................................................... 64
Oefening 2 ......................................................................................................................................................................... 65
Oefening 3 ......................................................................................................................................................................... 65
Oefening 4 ......................................................................................................................................................................... 65
Oefening 5 : Examenvraag ......................................................................................................................................... 66
Oefening 6 : Examenvraag : functie in een functie ! ....................................................................................... 67
Input – Output Questions ........................................................................................................................................... 68
Transform next FOR-code with a while? -> Examenvraag .......................................................................... 73
Examenvraag Algoritmes in Python ...................................................................................................................... 74
5- Functionaliteiten ................................................................................................................................................................ 70
Process Modelling .............................................................................................................................................................. 70
Elementen ......................................................................................................................................................................... 70
Overview Flow objects ................................................................................................................................................ 81
Overview Connecting objects ................................................................................................................................... 82
Overview Swim lanes................................................................................................................................................... 82
Overview Artifacts ........................................................................................................................................................ 82
BPMI.iO............................................................................................................................................................................... 83
Use Cases ................................................................................................................................................................................ 83
Use Case diagrams......................................................................................................................................................... 83
Elementen ......................................................................................................................................................................... 83
3
, 6- Project Management (is ook een algoritme) .......................................................................................................... 89
Views........................................................................................................................................................................................ 89
Creating a Project ............................................................................................................................................................... 89
Inleidend voorbeeld met MS Project..................................................................................................................... 89
Applicatie : Project Libre ................................................................................................................................................. 91
Step 1: Creating a project ........................................................................................................................................... 91
Step 2 : Creating a Task List ...................................................................................................................................... 92
Step 3 : Setting up Resources ................................................................................................................................... 96
Step 4 : Assign Resources to Tasks ........................................................................................................................ 99
Other functionalities ..................................................................................................................................................102
7- Databanken.........................................................................................................................................................................104
Excel : voorbeeld van databank .................................................................................................................................104
Access : Voorbeeld van een relationele databank ..............................................................................................104
Data Modellering ..............................................................................................................................................................106
5.1 Classes (= tabellen) ..................................................................................................................................................106
Class Diagrams..............................................................................................................................................................106
Wat bevat een Class Diagram ? ..............................................................................................................................106
Klasse ................................................................................................................................................................................106
Associatie ........................................................................................................................................................................106
Multipliciteit ..................................................................................................................................................................107
Attributen........................................................................................................................................................................107
Associatie Klassen .......................................................................................................................................................108
Compositie ......................................................................................................................................................................112
Aggregatie .......................................................................................................................................................................112
Generalisatie ..................................................................................................................................................................112
5.2 Databases......................................................................................................................................................................114
Definitie............................................................................................................................................................................114
From Class to Table ....................................................................................................................................................114
First normal form (1NF) ...........................................................................................................................................114
Column Types................................................................................................................................................................115
Keys ...................................................................................................................................................................................116
Primary Key ...................................................................................................................................................................116
Mapping associations with multiplicity 1 .........................................................................................................117
Mapping other associations ....................................................................................................................................118
Instanties (records) ....................................................................................................................................................119
Database met Power BI.............................................................................................................................................121
Oefeningen HOC ...........................................................................................................................................................121
4
