Re: Oracle and Visio

From: internetmaster <youlove_at_me.com>
Date: Wed, 24 Jul 2002 19:52:34 -0400
Message-ID: <3D3F3DC2.3010902_at_me.com>

Daniel Morgan wrote:
> Charles wrote:
>
>

[Quoted] >>On Tue, 23 Jul 2002 10:27:30 +0100, "Telemachus"
>><telemachus_at_ulysseswillreturn.net> wrote:
>>
>>
>>>Yes.
>>>But only if all the pk and RI and fk constraints are in place otherwise it
>>>can only get what it can see.
>>>
>>
>>I just used Visio on a legacy database. 60 or so tables and no fk/pk
>>defined. All you get is a set of tables, not all that well organized.
>>Not very usefull although it is a place to start.

>
>
> Why would anyone have a relational database without primary key constraints?
>
> Legacy, I presume, does not mean before normalization was defined.

We have an application at work which I won't name but will reveal the vendor's name -- Computer Associate.

We want to expose the underlying Oracle database to a reporting tool and we asked them to send over a data model so we could understsand how the tables relate to one another. They sent over a lovely data model.

The other day, I went into ERWin and reverse engineered the database and found that it actually doesn't have any keys or RI. I plan on calling CA next week.

>
> Daniel Morgan
>
Received on Thu Jul 25 2002 - 01:52:34 CEST