It is not the case in a relational model of a database when a B row is added and a C row is added. They can (B row and C row), if not properly normalized in this example, point to the same A row.
Your existing structure IS properly normalized. If rows in TableB and TableC point to a the same, single row in TableA, what normalization rule does this violate?
And, please stop trying to make a class match a table. It doesn't work.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/