it's not common and you should insist on primary and foreign key
constraints.
all you need is ONE user to hack into the database outside the app and
insert/delete/update rows that violate the integrity constraints and
your app stops working.
- Craig Healey <C.Healey_at_hhsuk.com> wrote:
> The developers working on our new VB app are also responsible for
> setting up the Oracle DB behind it. The app is for an order
> entry/despatch/warehouse system with >5 million customers and >1000
> orders per day. We have nearly 400 tables. They are not planning on
> using primary keys/secondary keys, as they say they will handle all
> the
> constraints via VB.
> I only have a theoretical knowledge of database design, which says
> this
> is very wrong. Is the Oracle system being used as anything more than
> an
> expensive file system? In real world scenarios, is this a common
> practice?
>
> Regards
>
> Craig Healey
>
>
>
>
> This email and any files transmitted with it are confidential and
> intended solely
> for the use of the individual or entity to whom they are addressed
> and may contain
> confidential and/or privileged material. Any review, retransmission,
> dissemination
> or other use of, or taking of any action in reliance upon, this
> information by
> persons or entities other than the intended recipient is prohibited.
> Statements
> and opinions expressed in this e-mail may not represent those of the
> company.
>
> If you have received this email in error please notify
> system.administrator_at_hhsuk.com
>
> This footnote also confirms that this email message has been swept by
> MIMEsweeper
> for the presence of computer viruses (www.mimesweeper.com)
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Craig Healey
> INET: C.Healey_at_hhsuk.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Do you Yahoo!?
Y! Web Hosting - Let the expert host your web site
http://webhosting.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Wed Oct 23 2002 - 13:39:24 CDT
