Path: utzoo!mnetor!uunet!seismo!sundc!pitstop!sun!yosemite!trogers
From: trogers%yosemite@Sun.COM (Tom Rogers)
Newsgroups: comp.databases
Subject: Re: Relational DB table generation S/W
Message-ID: <42499@sun.uucp>
Date: 19 Feb 88 15:46:04 GMT
Sender: news@sun.uucp
Lines: 25
Keywords: schema design SunSimplify schemadesign Sun


>Does anyone know of any software out there that can generate
>the tables once the relationships between the data are defined
>for the relational model?
 
Schemadesign is an interactive schema designer/editor that currently
works only on Sun bit-mapped displays. With it you can define all tables, 
relationships (it uses the ER model), and fields within the database, and then 
generate a new schema/dbms or reconfigure an existing one. The generated 
database is a valid SunUnify relational dbms. Schemadesign is part of 
a front-end package called SunSimplify which includes other tools and an 
access method level interface. SunSimplify runs only on the SunUnify dbms, 
but future versions of SunSimplify will work on other dbms.
 
There are other schema design packages that run on PCs and RTs, including
Chen & Associates, Inc's ER Designer, CCA's DB Designer, and ETH's 
Gambit.
 
For more information on schema design tools and database user interfaces, see
the following article:
 
Entity Relationship Database User Interfaces
T.R. Rogers, R.G.G. Cattell
Proceedings 6th ER Conference on Entity-Relationship Approach
New York, Nov '87.