Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> database design question
Hi All:
I am getting pulled in a project that is requiring me to design a database. Not much experience here. I have 3 files that have related info to a customer. Here's the info I have, the first 7 digits of the account number field in file1 is the house number field in file2. The question is: would you set up a primary-foriegn key relationship or should I just load each file into a table in Oracle and just do joins when I need to get infomation out of the database. What would having the primary-foreign key relationship buy me.
thanks in advance for any help with this. eddie lufker Received on Mon Oct 27 1997 - 00:00:00 CST