On Integrity Constraints for a Waste Management Information System

Schreiber, D. (1994). On Integrity Constraints for a Waste Management Information System. IIASA Working Paper. IIASA, Laxenburg, Austria: WP-94-016

Preview

Text WP-94-016.pdf Download (687kB) | Preview

Abstract

There is a waste problem in nearly every country. A model of a waste generating system and an efficient waste management information system are the first steps to control this problem. Some countries have already enacted laws which force communities and enterprises to report annually the amounts of wastes produced. For example, the German federal state, Lower Saxony, enacted such a law in 1992. This YSSP-Project deals with a case study on the development of a waste management information system for this state. The quality of the system essentially depends on the consistency of the underlying database system. Therefore, the point of view of a database designer is given. The design of the data structures and the support of integrity constraints in the underlying database system is thereby especially emphasized. The data structures are modelled using an extended entity relationship model. They are implemented with a relational database management system. In contrast to the traditional way of supporting integrity constraints in the application program, we define triggers which are implemented in the database system itself to enforce main consistency rules. In the final chapter some conclusions about further steps are given.

Actions (login required)

View Item