Database design

From: Mabel Trigüis <mabelle_at_bluewin.ch>
Date: 1998/01/22
Message-ID: <01bd27a3$e75a28c0$da0bbac3@m3bj1>#1/1

Sorry if you have this message twice, but I sending it from another server. If you have an ORACLE database:
1) If you have a system with 150 tables with 50 sequences. Do you think it is a good idea to convert all the 50 sequences to only one general sequence?
2) Do you think that putting all the integrity rules ( not possible with check constraints ) in a stored procedure instead of hardcoded in the form is a good idea for maintenance?

Thanks in advance,

Mabel Triguis
Switzerland
mabelle_at_bluewin.ch
mabel.triguis_at_unctad.org Received on Thu Jan 22 1998 - 00:00:00 CST