Key words
Developing information systems
Objectives
In every organisation the central point of an information system is a database : a set of related tables, controlled buysophisticated system software (DBMS); Every manager must u nderstand the (main) datastructure of this database in orderto retrieve information efficiently (by using a query likeSQL), to make some analyse, to make some good prognoses.
Prerequisites
Beside the basics of Windows GUI, we understand some computer architecture like PC, LAN and client-server.
Topics
The leading DBMS on the desktop is Access 2000: studying some sample applications, made in Accesss, is a good starting point.
Making some new small database systems with attentionon keys, validation controls and normalisation of the basetables.
A profound study of ANSI SQL.
The transition to a more secure system : a database server.
Database design.
Some guidelines to publish the content of a table(view) via FrontPage.
Teaching Methods
lectures
- case studies
- exercises
- group paper
home study
Materials used
teacher's text
- other text- and/or casebook(s)
scientific & technical literature
Study guidance
Assessment
closed book - open book written examination - oral examination
Course
Study costs
45 €
Lecturer(s)
Denis DE WACHTER
Language
Dutch
|
|
