Key words
Developing information systems, Access DBMS, SQL, Database design, Dynamic webpages
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: 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 on the web the content of a table(view) via Dreamweaver, Web Matrix.. .
Prerequisites
Beside the basics of Windows GUI, we understand some computer architecture like PC, LAN and client-server.
Final Objectives
- Building simple windows application and web application
- The essentials of database design
- Profound study of SQL
Materials used
Study costs
Study guidance
Teaching Methods
Assessment
Lecturer(s)
Denis De Wachter
|
|
