Key words
Headwords, Data banks (data bases), data models, data analysis, access, SQL, information systems, key (unique key), referential integrity, redundancy, normalisation, system analysis, IWETO-code, p175 Informatics
Objectives
To obtain an insight into information systems proceeding the functional analysis and the development.
Being able to collect, registrate and classificate data.
1. Collect information from a text or a form.
2. Organisation of information:
- to draw up an informational data bank on the basis of a text and forms
- interpret a conceptual data model (information model)
- change a conceptual into a technical data model
- normalise
3. Interprete a technical data model.
4. Define screens and to report of an existing data bank.
Topics
- Introduction to data bases
- Parts of data base system (tables, columns, query's, forms, reports,...)
- An example: MS Access
- To change texts and forms in ERD
- To change conceptual and technical data models
- Change a conceptual into a technical data model
- Normalisation (until the third normal form)
- Basics SQL
All items are illustrated with examples and exercised under guidance
Prerequisites
not required
Final Objectives
GENERAL REQUISITES
KNOWLEDGE: - Knowledge of informatical sources
SKILLS : - Collecting information - Organising information - Collecting data, registration, classification
ATTITUDES : - Thinking analytically and problem solving
GENERAL PROFESSIONAL REQUISITES
KNOWLEDGE : - Data bankprojects
SKILLS :
ATTITUDES:
SPECIFIC PROFESSIONAL REQUISITES
KNOWLEDGE : - Data banks for personal application (MS-Access)
SKILLS:
ATTITUDES:
Materials used
Data base systems for practical use - Prof.DR.J.Vandenbulcke - Kluwer - ISBN: 90.440-0147.7
Access 2000 practical guide - Eddy Van den Broeck
Data bases and Access 2002 - les Korpershoek en Ben Groenendijk - Academic Service - ISBN 90-395-15131
Dutch slides are available through the electronical environment
For this part of educational training students use their laptop
Study costs
Data base systems for practical use: ± 50 Euro (book is used in first and second year).
Access 2000 Practical guide: ± 10 Euro
Data bases and Access 2002: ± 35 Euro
Study guidance
Individual learning problems can always be mentioned to the teacher and be remedied.
Teaching Methods
Teaching conversation
Guided and individual exercises with PC
Assessment
FIRST SESSION
Written exam: 75%
Exercises Access: 25%
SECOND SESSION
Written exam: 75%
Exercises Access: 25%
Lecturer(s)
|
|
