Hello,
I have a database project in mind and am just starting to sketch it out. I want to track information from several hundred farms over several years. I intend to collect contact information for each farm and then environmental and production specific data (farm type, crops grown, soil info, water info, etc.). I can visualize all the tables that I will need to house the data but I cant wrap my head around how to set it up in a way that would allow me to easily track the farm over time. One idea that has popped into my head has been to add a date field to all tables so the date the data was collected could be queried. When I think about this, it seems like a lot of redundant data. Does anyone know of a slick efficient way to build this into the design of a database? Any comments would be appreciated.