From jkstill@cybcon.com Mon, 19 Mar 2001 19:13:59 -0800 From: jkstill@cybcon.com Date: Mon, 19 Mar 2001 19:13:59 -0800 Subject: RE: FK Constraints Message-ID: MIME-Version: 1.0 Content-Type: text/plain Joins do not require the presence of FK's in order to work properly. Jared On Mon, 19 Mar 2001 sinardyxing@bcsis.com wrote: > Hi, > > I'm a beginner too, but without a table FK (relation) how you make a join > statements ? Do you normalize your tables ? > > The relation model is concerned with logical maters only, not physical > matters. It addresses three aspects of data, data stucture (object) data > integrity, and data manipulation. > The Object (Tables), > Integrity portion has to do with PK and FK > Data manipulation (SELECT, JOIN etc) > > In addition I think with the Normalized database you will have smaller > database and easy to maintain (base on object). > > > > -----Original Message----- > akhil > Sent: Tuesday, 20 March 2001 2:05 AM > To: Multiple recipients of list ORACLE-L > > > Hi all: > > We have a situation where are no relationships are > defined at the database level. i.e no foreign keys > constraints have established at the Database. The > application is still at the Development Stage. > > Everything is controlled at the application level. > > I as the DBA appose this design for Data security and > also cannot reverse engineer from the tables into > Designer. > > Can you please share you pros / Cons. > > Thanks > > > > > > __________________________________________________ > Do You Yahoo!? > Get email at your own domain with Yahoo! Mail. > http://personal.mail.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: ramani akhil > INET: srinirmala@yahoo.com > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: ListGuru@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). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: sinardyxing@bcsis.com > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: ListGuru@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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: jkstill@cybcon.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@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).