Field needed?

[duluter]

Hi, everyone.

I have a Farm table that contains data associated with individual farms. Each farm occurs within one county and one state.

I also have two control tables, a County table and a State table. There is a one-to-many relationship between the State and County tables.

In my Farm table, I originally had a StateID field and a CountyID field. But now I realize that I really only need a CountyID field because I can just look up which state we're in via a join on the State and County tables. I'm thinking about deleting the StateID field from the Farm table. Am I right that this setup would be a cleaner implementation? No need to include the StateID when I can just look it up through the County table, right?


Thanks,

Duluter

 

[duluter]

Cool. Thanks, Pat.


Duluter

 

[boblarson]

Hi, everyone.

I have a Farm table that contains data associated with individual farms. Each farm occurs within one county and one state.

I also have two control tables, a County table and a State table. There is a one-to-many relationship between the State and County tables.

In my Farm table, I originally had a StateID field and a CountyID field. But now I realize that I really only need a CountyID field because I can just look up which state we're in via a join on the State and County tables. I'm thinking about deleting the StateID field from the Farm table. Am I right that this setup would be a cleaner implementation? No need to include the StateID when I can just look it up through the County table, right?


Thanks,

Duluter

Just wanted to say "Good job!" in thinking that through like that. That is a good sign that you have the concepts of normalization.