Within a thesis we developed a data base application for a small company which is in the media control business. The main goal of this application was the support of the work flows and processes of this company and the centralized storage of the data captured.

The core business of a media controlling company comprises the budgeting, planning, execution and control of media campaigns for other companies or brands.

So far the work of the staff at Leo Burnett Media AG was based on Excel. The new solution had to store the data in a data base, and, the processes should be performed based on that application. The storage of data should be optimized over all.

The companies data and processes were thoroughly analysed. In addition to the present processes a module for the administration of all customerrelated data was developed. This will directly help the agents doing their jobs.For the data export the corresponding data interfaces were defined.

Based on the findings of the analyse the data model was created and the application implemented. There was a special emphasis on an optimized user interface. For the development we used Access 97 and VBA.

With the new application the user can comfortably perform all necessary action within an advertising campaign. The work with the data in the data base has been done using forms. These forms guide the user through all steps of the process chain.

The interfaces to other applications (like office applications or report creation tools) are based on OLE automation. As an example we created address export to Outlook, mail merge documents in Word and reports in Excel. The application supports a multi lingual user interface. It is, due to the abstraction layer for SQL and ODBC, independent of the underlying DBMS.

This thesis represents the solid ground for further development efforts. Thanks to the modular design the application can be extended to a standard software solution.

Our master thesis consisted of the acquirement of an overall plan, the evaluation of the technologies used for this project and the programming of a lesson - information system, which is accessible via WWW. Such a system manages hierarchically organised modules in a decentralised data base. These modules contains information in a HTML form and other application proprietary files, like Word and Excel. It is possible with the help of the client program to navigate in the hierarchical structure and to open and download corresponding files.

The analysis of the available technologies showed us clear advantages for a "three-tier" model. This model contains a Java Applet as a graphic client and a RMI server which provides methods for the data base query via JDBC.

The Protoptype III of DAUIS (Diplomarbeit Unterrichts - Informationssystem) on hand offers the following functionality:

• Multiuser capable operation of multiple WWW clients with the Microsoft Internet Explorer 4.0.
• Navigating in the hierarchical data base.
• Indicating and downloading of files.
• Establishing and editing of user accounts.

This thesis results from a co-operation with 'Keller AG für Druckmesstechnik', a company which produces pressure transmitters. Our assignment was to develop a software that can be used in the development and production department. The program should simplify the measuring and calibrating processes. The functions of the software should work according to the requirements of Keller AG.

One of the main requirements for the software is, that it should be possible to construct calibration processes. They are written in a specific language. The specification of that language is a part of the thesis. The program is able to communicate with pressure transmitters which are connected to the computer directly, or indirectly by a measurement device. The test environment of the transmitters can also be controlled by the language. The test environment is created by pressure calibrator and oven.

Object oriented methods were used for designing and implementing the software. The developped software is easily expandable. Thats why it is well prepared for future needs. The goals of the thesis are all achieved successfully.

This diploma thesis covers a subtask from the overall project LokSIM. The goal of the overall project is the simulation of a real locomotive, controlled from a real engine cockpit. In order to obtain a feeling of real driving, the simulation can control a model locomotive. This in turn captures its "view" of the tracks by means of a video camera in order to be displayed on a canvas in front of the real cockpit. My part in this project was the development of software for a Client/Server setup to control a simulation run. The user interface requires either the attachment of the real cockpit or a computer implementation thereof. Moreover, the actual simulator must communicate with the model train. I first developed the Client/Server model. It includes a server, which administers the simulations and model locomotives. A Client can log into the server and start a simulation. This can involve a model train. The overall system is conceived as a distributed application, realised in several programming languages. The heart of the system, however, is the communication among the modules. In close coperation with parallel ongoing subprojects (simulator core, cockpit, radio link to model trains) we put together a system that runs on various networked computers. I designed the communication subsystem between the simulation module, a real or virtual cockpit, and the model train. The protocols and interfaces are unified on all edges. The links to the real cockpit and to the radio module which controls the model trains use RS232 ports. This work is based on thorough knowledge and ability in software engineering. Moreover, it required skills in communication, both computer based protocols and human interaction. This resulted in a fruitful cooperation when negotiating interfaces with project partners.

The institute for hygiene and applied physiology at the ETH Zürich has developed several applications to assess human sensoric functions. Existing devices for measuring the acoustic perception (audiometers) cannot be controlled by a computer. They must be operated by an examiner, and this results in higher costs and reduced accuracy. For this reason, an instrument that can execute auditive assessments automatically shall be developed. To achieve this, the device generates pure tones of different frequency and loudness, and the subject responds whether it hears these tones or not. Interpreting these responses, the instrument determines the hearing threshold level.

It was found, that a multi-media-PC is capable of fulfilling the needs of audiometry. The only remaining hardware parts are the headphones and a joystick. All other functions could be built into the software. The main modules of the program are:

• sound generation
• interpreting the user response
• controlling the conduction of the test
• user-interface

A main part of the software is the assessment strategy. Out of various pyschophysical techniques, the MOBS"-method was selected. The user-interface was implemented in two different ways. The audiometer shall be capable of executing fully automated hearing assessments. In order to do this, all communication with the user is done using only the headphones and the joystick. On the other hand, all capabilities of a conventional audiometer shall also be provided to an examiner. For this purpose, a normal user-interface was also created.

The prototype was tested on a small group of subjects. It was shown, that the measured values are the same as the ones measured using a standard audiometer, and that the headphones-only" user-interface is proficient. A well functioning platform for assessing the hearing threshold level has been accomplished. In addition, the application is designed in a way that makes further extensions easy feasible.

The purpose of this dissertation was to represent a small company (the metal workshop Liechtblick) in the Internet. All their products should be clearly arranged and presented to the WEB page visitors. Also, the visitor should be able to easily order the products through the internet. The ordering options should allow the customers to chose length, width and other specifications of the ordered parts.

In our solution, the WEB pages are produced dynamically with a data base in the background. This data base contais all necessary product information and permits also an easy maintenance of the product data sheets and ordering information.

We worked with following technologies:

• Access 97
• Active Server Pages (ASP)
• VBScript
• JavaScript
• Server Side Includes (SSI)
• Casscading Styles Sheets (CSS)
• Cookies

This thesis contains important features like admitting several users simultaneously, registration of customers, shopping cart, dynamic calculation of the price, discount levels, dynamic generation of pages and connection to the database.