Active Record/ORM vs Normal Forms?
- by Arsenal
Hello,
I've been playing around with Active Record a bit, and I have noticed that A.C./ORM always uses the following database model when creating a one-to-one relationship
Person
id | country_id | name | ...
Country
id | tld | name | ...
No I wondered, isn't this a violiation of the third Normal Form? This clearly states "Every non-prime attribute is non-transitively dependent on every key of the table". Well this country_id isn't dependent of personid is it?
So is this wrong or am I just not getting the point?