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 <[EMAIL PROTECTED]> 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 > [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).