Management
Information Systems
Victor Beckers
2020-2021
,INTRODUCTION TO INFORMATION SYSTEMS ................................................................................................... 1
WHAT ARE INFORMATION SYSTEMS (IS’S) .................................................................................................................... 1
ORGANIZATIONAL STRUCTURE.................................................................................................................................... 1
ORGANIZATIONAL SILOS ............................................................................................................................................ 2
CROSS-FUNCTIONAL BUSINESS PROCESSES ................................................................................................................... 5
FROM SILOS TO ENTERPRISE INFORMATION SYSTEMS ..................................................................................................... 6
2019 ERP REPORT ........................................................................................................................................... 10
OVERVIEW OF A DIFFERENT INDUSTRIES...................................................................................................................... 10
UNDERSTANDING THE ERP VENDOR LANDSCAPE .......................................................................................................... 11
ON-PREMISE DEPLOYMENT...................................................................................................................................... 11
CLOUD DEPLOYMENT .............................................................................................................................................. 11
IMPLEMENTATION APPROACH .................................................................................................................................. 12
PROJECT COSTS ..................................................................................................................................................... 12
PROJECT DURATION................................................................................................................................................ 12
ERP IN THE CLOUD IS IT READY? ARE YOU? BOOZ&CO REPORT...................................................................... 13
3 MODELS FOR HOUSING ERP .................................................................................................................................. 13
THE BENEFITS OF CLOUD-BASED ERP ......................................................................................................................... 13
LIMITATIONS OF THE CLOUD ..................................................................................................................................... 14
THE EVALUATION FRAMEWORK................................................................................................................................. 15
BLOCKCHAINS ................................................................................................................................................ 15
INTRODUCTION TO BLOCKCHAINS.............................................................................................................................. 15
INTRODUCTION TO CRYPTOGRAPHY ........................................................................................................................... 21
DEEPER INTO BLOCKCHAINS AND BITCOINS ................................................................................................................. 30
SUMMING UP & DEEPER ......................................................................................................................................... 43
RSA INCRIPTION ALGORITHM (INTRODUCTION) FACULTATIF ........................................................................................... 46
BITCOIN & SMARTCONTRACTS .................................................................................................................................. 47
SOLIDITY & SMART CONTRACTS ................................................................................................................................ 56
RELATIONAL DATABASE MANAGEMENT SYSTEMS ......................................................................................... 61
DATABASES & RELATIONAL DATABASE MANAGEMENT SYSTEMS..................................................................................... 61
WHY DATABASES? ................................................................................................................................................. 61
DATA MODELS ...................................................................................................................................................... 62
DATA ABSTRACTION ............................................................................................................................................... 63
TRANSACTIONS AND CONCURRENCY CONTROL ............................................................................................................ 63
INTRODUCTION TO SQL .................................................................................................................................. 65
BACKGROUND ....................................................................................................................................................... 65
TABLES IN SQL ...................................................................................................................................................... 65
SQL DATA TYPES................................................................................................................................................... 65
CONSTRAINTS ....................................................................................................................................................... 66
SQL QUERIES OVER SINGLE TABLES ........................................................................................................................... 66
SQL QUERIES OVER MULTIPLE TABLES....................................................................................................................... 68
NESTED QUERIES ................................................................................................................................................... 70
AGGREGATION ...................................................................................................................................................... 71
INSERT, UPDATE/SET, DELETE ........................................................................................................................... 73
BUSINESS PROCESS ........................................................................................................................................ 75
WHAT IS A BUSINESS PROCESS? ................................................................................................................................ 75
CROSS-FUNCTIONAL PROCESSES ................................................................................................................................ 77
PROCESS MODELLING ............................................................................................................................................. 77
BUSINESS PROCESS AND INFORMATION SYSTEMS .......................................................................................................... 78
BUSINESS PROCESS AND ERP ................................................................................................................................... 79
AGILE DEVELOPMENT.............................................................................................................................................. 81
,BUSINESS PROCESS MODEL AND NOTATION (BPMN) ..................................................................................... 82
PROCESS MODELLING VIEWPOINTS ............................................................................................................................ 82
PURPOSES OF PROCESS MODELLING ........................................................................................................................... 82
MAPPING, ABSTRACTION AND PURPOSE OF A MODEL .................................................................................................... 83
BPMN ELEMENTS ................................................................................................................................................. 84
NAMING CONVENTIONS .......................................................................................................................................... 94
BPMN DIAGRAM .................................................................................................................................................. 94
MODEL WITH INFORMATION ARTIFACTS ..................................................................................................................... 95
SUB-PROCESS........................................................................................................................................................ 96
REWWORK AND REPETITION..................................................................................................................................... 98
PURCHASE ORDER (PO) HANDLING PROCESS ............................................................................................................. 100
PROCESS DISCOVERY .................................................................................................................................... 101
THE 3 CHALLENGES .............................................................................................................................................. 101
PROCESS DISCOVERY METHODS............................................................................................................................... 103
PROCESS MODEL QUALITY ASSURANCE ....................................................................................................... 107
SYNTACTIC QUALITY.............................................................................................................................................. 107
SEMANTIC QUALITY .............................................................................................................................................. 108
PRAGMATIC QUALITY ............................................................................................................................................ 108
SEVEN MODELING GUIDELINES (7PMG) ....................................................................................................... 108
SAP S/4HANA ............................................................................................................................................... 109
INTRODUCTION TO SAP S/4HANA ........................................................................................................................ 109
SAP S/4HANA: PRACTICE ................................................................................................................................... 112
INNOVATION IN SAP S/4HANA............................................................................................................................. 113
SAP SD (SALES AND DISTRIBUTION) ........................................................................................................................ 117
MATERIALS MANAGEMENT (MM) ......................................................................................................................... 127
Legend for titles used in the synthesis:
TITLE 1
TITLE 2
TITLE 3
TITLE 4
Marks:
• Homework (10%) : individual work
o E-Learning on BPMN: 0.5 pt (deadline: 18/02/2021)
o BPMN: 0.5 pt (deadline: 25/02/2021)
o SAP: Case study on SD: 0.5 pt (deadline 04/03/2021)
o SAP: Case Study on MM: 0.5 pt (deadline 11/03/2021)
• Project (40%): Extended GBI
o Group work: 4 students
o Deadline: 23/04/2021
• Final exam (50%):
o Written
, ASCHWIN ITTOO’S PART
INTRODUCTION TO INFORMATION SYSTEMS
WHAT ARE INFORMATION SYSTEMS (IS’S)
Information system is an integrated set of components (hardware of software) for collecting, filtering,
storing and processing data to create meaningful information, knowledge and digital products.
(Business processes end-users)
DATA VS INFORMATION
Data are raw values >< Information are richer and processed data
- Example of data: sales figures of retailer
- Example of information: average sales profits
N.B.: Decision-making: accurate, up-to-date information
TYPICAL EXAMPLES OF IS
- Materials Requirements Planning Systems (MRP)
- Accounting Systems
- Expert Systems
- Entreprise Information Systems / Entreprise Resource Planning (ERP)
- …
IS & ORGANIZATIONS
➔ Organizations and Information Systems are intertwined.
➔ The IS evolution based on organization’s information needs.
Appreciating IS = understanding organizational structure.
ORGANIZATIONAL STRUCTURE
An organization is a collection of functions. The traditional functions are P-O-S-D-C-O-R-B. Functions
are departments and/or functional units.
A very traditional way in which organizations was structured in the past is the following:
Organization
Planning Organizing Staffing Directing Coordinating Reporting Budgeting
Terminology and/or functions may vary across industry, organization.
1
Information Systems
Victor Beckers
2020-2021
,INTRODUCTION TO INFORMATION SYSTEMS ................................................................................................... 1
WHAT ARE INFORMATION SYSTEMS (IS’S) .................................................................................................................... 1
ORGANIZATIONAL STRUCTURE.................................................................................................................................... 1
ORGANIZATIONAL SILOS ............................................................................................................................................ 2
CROSS-FUNCTIONAL BUSINESS PROCESSES ................................................................................................................... 5
FROM SILOS TO ENTERPRISE INFORMATION SYSTEMS ..................................................................................................... 6
2019 ERP REPORT ........................................................................................................................................... 10
OVERVIEW OF A DIFFERENT INDUSTRIES...................................................................................................................... 10
UNDERSTANDING THE ERP VENDOR LANDSCAPE .......................................................................................................... 11
ON-PREMISE DEPLOYMENT...................................................................................................................................... 11
CLOUD DEPLOYMENT .............................................................................................................................................. 11
IMPLEMENTATION APPROACH .................................................................................................................................. 12
PROJECT COSTS ..................................................................................................................................................... 12
PROJECT DURATION................................................................................................................................................ 12
ERP IN THE CLOUD IS IT READY? ARE YOU? BOOZ&CO REPORT...................................................................... 13
3 MODELS FOR HOUSING ERP .................................................................................................................................. 13
THE BENEFITS OF CLOUD-BASED ERP ......................................................................................................................... 13
LIMITATIONS OF THE CLOUD ..................................................................................................................................... 14
THE EVALUATION FRAMEWORK................................................................................................................................. 15
BLOCKCHAINS ................................................................................................................................................ 15
INTRODUCTION TO BLOCKCHAINS.............................................................................................................................. 15
INTRODUCTION TO CRYPTOGRAPHY ........................................................................................................................... 21
DEEPER INTO BLOCKCHAINS AND BITCOINS ................................................................................................................. 30
SUMMING UP & DEEPER ......................................................................................................................................... 43
RSA INCRIPTION ALGORITHM (INTRODUCTION) FACULTATIF ........................................................................................... 46
BITCOIN & SMARTCONTRACTS .................................................................................................................................. 47
SOLIDITY & SMART CONTRACTS ................................................................................................................................ 56
RELATIONAL DATABASE MANAGEMENT SYSTEMS ......................................................................................... 61
DATABASES & RELATIONAL DATABASE MANAGEMENT SYSTEMS..................................................................................... 61
WHY DATABASES? ................................................................................................................................................. 61
DATA MODELS ...................................................................................................................................................... 62
DATA ABSTRACTION ............................................................................................................................................... 63
TRANSACTIONS AND CONCURRENCY CONTROL ............................................................................................................ 63
INTRODUCTION TO SQL .................................................................................................................................. 65
BACKGROUND ....................................................................................................................................................... 65
TABLES IN SQL ...................................................................................................................................................... 65
SQL DATA TYPES................................................................................................................................................... 65
CONSTRAINTS ....................................................................................................................................................... 66
SQL QUERIES OVER SINGLE TABLES ........................................................................................................................... 66
SQL QUERIES OVER MULTIPLE TABLES....................................................................................................................... 68
NESTED QUERIES ................................................................................................................................................... 70
AGGREGATION ...................................................................................................................................................... 71
INSERT, UPDATE/SET, DELETE ........................................................................................................................... 73
BUSINESS PROCESS ........................................................................................................................................ 75
WHAT IS A BUSINESS PROCESS? ................................................................................................................................ 75
CROSS-FUNCTIONAL PROCESSES ................................................................................................................................ 77
PROCESS MODELLING ............................................................................................................................................. 77
BUSINESS PROCESS AND INFORMATION SYSTEMS .......................................................................................................... 78
BUSINESS PROCESS AND ERP ................................................................................................................................... 79
AGILE DEVELOPMENT.............................................................................................................................................. 81
,BUSINESS PROCESS MODEL AND NOTATION (BPMN) ..................................................................................... 82
PROCESS MODELLING VIEWPOINTS ............................................................................................................................ 82
PURPOSES OF PROCESS MODELLING ........................................................................................................................... 82
MAPPING, ABSTRACTION AND PURPOSE OF A MODEL .................................................................................................... 83
BPMN ELEMENTS ................................................................................................................................................. 84
NAMING CONVENTIONS .......................................................................................................................................... 94
BPMN DIAGRAM .................................................................................................................................................. 94
MODEL WITH INFORMATION ARTIFACTS ..................................................................................................................... 95
SUB-PROCESS........................................................................................................................................................ 96
REWWORK AND REPETITION..................................................................................................................................... 98
PURCHASE ORDER (PO) HANDLING PROCESS ............................................................................................................. 100
PROCESS DISCOVERY .................................................................................................................................... 101
THE 3 CHALLENGES .............................................................................................................................................. 101
PROCESS DISCOVERY METHODS............................................................................................................................... 103
PROCESS MODEL QUALITY ASSURANCE ....................................................................................................... 107
SYNTACTIC QUALITY.............................................................................................................................................. 107
SEMANTIC QUALITY .............................................................................................................................................. 108
PRAGMATIC QUALITY ............................................................................................................................................ 108
SEVEN MODELING GUIDELINES (7PMG) ....................................................................................................... 108
SAP S/4HANA ............................................................................................................................................... 109
INTRODUCTION TO SAP S/4HANA ........................................................................................................................ 109
SAP S/4HANA: PRACTICE ................................................................................................................................... 112
INNOVATION IN SAP S/4HANA............................................................................................................................. 113
SAP SD (SALES AND DISTRIBUTION) ........................................................................................................................ 117
MATERIALS MANAGEMENT (MM) ......................................................................................................................... 127
Legend for titles used in the synthesis:
TITLE 1
TITLE 2
TITLE 3
TITLE 4
Marks:
• Homework (10%) : individual work
o E-Learning on BPMN: 0.5 pt (deadline: 18/02/2021)
o BPMN: 0.5 pt (deadline: 25/02/2021)
o SAP: Case study on SD: 0.5 pt (deadline 04/03/2021)
o SAP: Case Study on MM: 0.5 pt (deadline 11/03/2021)
• Project (40%): Extended GBI
o Group work: 4 students
o Deadline: 23/04/2021
• Final exam (50%):
o Written
, ASCHWIN ITTOO’S PART
INTRODUCTION TO INFORMATION SYSTEMS
WHAT ARE INFORMATION SYSTEMS (IS’S)
Information system is an integrated set of components (hardware of software) for collecting, filtering,
storing and processing data to create meaningful information, knowledge and digital products.
(Business processes end-users)
DATA VS INFORMATION
Data are raw values >< Information are richer and processed data
- Example of data: sales figures of retailer
- Example of information: average sales profits
N.B.: Decision-making: accurate, up-to-date information
TYPICAL EXAMPLES OF IS
- Materials Requirements Planning Systems (MRP)
- Accounting Systems
- Expert Systems
- Entreprise Information Systems / Entreprise Resource Planning (ERP)
- …
IS & ORGANIZATIONS
➔ Organizations and Information Systems are intertwined.
➔ The IS evolution based on organization’s information needs.
Appreciating IS = understanding organizational structure.
ORGANIZATIONAL STRUCTURE
An organization is a collection of functions. The traditional functions are P-O-S-D-C-O-R-B. Functions
are departments and/or functional units.
A very traditional way in which organizations was structured in the past is the following:
Organization
Planning Organizing Staffing Directing Coordinating Reporting Budgeting
Terminology and/or functions may vary across industry, organization.
1
