I have used the following approach to building my database please could some let me know if this is the correct way. I have been told its not.
Summary
A farm has many farm houses
A farm has many crops through its lifetime
A crop is an intake of birds (every 40 days or so birds leave and a new crop is created)
during the crop life cycle, for each house has a daily questionnaire (pencard) which is completed
everything works has expected.
I have been told my CropHouse is wrong and Should have done it using a Link table
Example below.
