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

Home -> Community -> Usenet -> comp.databases.theory -> Normalization Question

Normalization Question

From: BG <bgbills_at_yahoo.com>
Date: Fri, 21 Jan 2005 00:19:31 +0100
Message-ID: <41f03bb5$0$303$ba620e4c@news.skynet.be>


Hey All,

Here's an example table with a few fields. To abide by the rules of normalization, should the phone & date fields be placed into their own tables? Even though the data will not be repeated in any other table?

TblMembers



fname
lname
address
city
state
work_phone
cell_phone
home_phone

add_date
delete_date
promote_date
update_date

Thanks,

Gordon Received on Thu Jan 20 2005 - 17:19:31 CST

Original text of this message

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