Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> database design question

database design question

From: Ed Lufker <elufker_at_swcp.com>
Date: 1997/10/27
Message-ID: <63384k$cdb$1@sloth.swcp.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US