Normalization

[veenna]

hi all,

I have three tables TableA,TableB,T ableC.

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

[ck9663]

Depends on how you want it done. I'd say you use the ID as link to all tables.


-- CK