Re: Theory v Practice

Craig, i dont know jack about VB but M$ Access wont let you do updates(according to my sources) unless there is PK or Unique index on the tables.

joe

Craig Healey 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: Joe Testa
  INET: jtesta_at_dmc-it.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).