Thanks for all your suggestions. It should be enough to get going. I'm kind of thinking of shying away from the date datatype scenario suggestion - I inherited some databases and applications (written by third parties), that are Not using datatypes correctly... So, that would be the first observation of the new hire. Joel Patterson Database Administrator joel.patterson@xxxxxxxxxxx x72546 904 727-2546 ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mercadante, Thomas F (LABOR) Sent: Monday, January 08, 2007 11:58 AM To: Laimutis.Nedzinskas@xxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx Subject: RE: JAVA Developer You naively assuming that DBA's have the power to influence table designs. Keep on dreaming. ________________________________ This transmission may contain confidential, proprietary, or privileged information which is intended solely for use by the individual or entity to whom it is addressed. If you are not the intended recipient, you are hereby notified that any disclosure, dissemination, copying or distribution of this transmission or its attachments is strictly prohibited. In addition, unauthorized access to this transmission may violate federal or State law, including the Electronic Communications Privacy Act of 1985. If you have received this transmission in error, please notify the sender immediately by return e-mail and delete the transmission and its attachments. ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Laimutis Nedzinskas Sent: Monday, January 08, 2007 11:54 AM To: oracle-l@xxxxxxxxxxxxx Subject: RE: JAVA Developer ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mercadante, Thomas F (LABOR) When designing tables for use by your application, do you include foreign keys in your design, or do you prefer to handle the logic within the application? Please, DO NOT ALLOW JAVA DEVELOPER to get even close to data modelling. If you do then he must qualify as data modeller as such. This discipline has nothing to do with Java. Fyrirvari/Disclaimer http://www.landsbanki.is/disclaimer <http://www.landsbanki.is/disclaimer>