Path: utzoo!utgpu!jarvis.csri.toronto.edu!cs.utexas.edu!uunet!mcsun!unido!infbs!huelsman
From: huelsman@infbs.UUCP (Klaus Huelsmann)
Newsgroups: comp.databases
Subject: dynamic generation of ingres forms
Message-ID: <1629@infbs.UUCP>
Date: 7 Feb 90 12:17:19 GMT
Reply-To: huelsman@infbs.UUCP ()
Organization: TU Braunschweig,Informatik,West Germany
Lines: 20


Dear net,

We are running an experimental database design system based on the ER-model. 
It provides facilities for specifying ER-schemas and transforming them to
relational database schemas. The relational schemas are installed on the
INGRES database system version 6.2. Now we are interested in generating auto-
matically INGRES forms according to the underlying ER-schema where the forms
are some 'INGRES representation' of the entity-relationship schema. We think
of forms for inserting, retrieving, deleting and updating entities or 
relationships including some constraint checking on the attributes.

The questions are:
  1) How can we create INGRES forms by use of an application program?
  2) For which classes of integrity constraints given in some abstract
     way in the design environment can we generate the corresponding
     constraint checks for the forms?

  Thanks in advance.
			Klaus