By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,413 Members | 1,594 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,413 IT Pros & Developers. It's quick & easy.

Normalization

P: 65
hi all,

I have three tables TableA,TableB,TableC.

TableA with Aid(primary Key), Aname.
TableB with Bid(primary Key),Bname,Aid(Foregin Key from TableA).
TableC with Cid(primary Key),Cname,Bid(Foregin Key from TableB),Aid

Here TableA and TableB are realted and TableB and TableC are Related.

I want to know whether it is against Normalization to store TableA Id in TableC With out relation?

Plz Help

regards
veena
Mar 2 '09 #1
Share this Question
Share on Google+
1 Reply


ck9663
Expert 2.5K+
P: 2,878
Depends on how you want it done. I'd say you use the ID as link to all tables.


-- CK
Mar 2 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.