Key words
Developing information systems, Access DBMS, SQL, Database design
Objectives
In every organisation the central point of an information system is a database : a set of related tables, controlled by sophisticated system software (DBMS); Every manager must understand the (main) datastructure of this database in order to retrieve information efficiently (by using a query like SQL), to make some analyse, to make some good prognoses.
Topics
The leading DBMS on the desktop is Access 2002: studying some sample applications, made in Accesss, is a good starting point.
Making some new small database systems with attention on 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 Dreamweaver.
Prerequisites
Beside the basics of Windows GUI, we understand some computer architecture like PC, LAN and client-server.
Final Objectives
Materials used
teacher's text
- other text- and/or casebook(s)
scientific & technical literature
Study costs
45 €
Study guidance
Teaching Methods
lectures
- case studies
- exercises
home study
Assessment
closed book written examination - oral examination
Lecturer(s)
Denis DE WACHTER
|
|
