A farmer owns and operates a 640-acre farm for several generations. Since the farm business id growing, the farmer is thinking to build a database that would make easier the management of the activities in the farm. He is considering the following requirement of the activities in the farm. He is considering the following requirements for the database
1. For each livestock classification group (For example cow, horse etc.), the farmer keeps track of the following information: identification number, classification, total number of livestock's per classification group (for example number of cows, number of horses etc.)
2. For each crop the following information is recorded: crop identification number and Classification
3. Farmer has recorded the yield of each crop classification group during the last ten years. The records consist of the year, yield, sales, price of the crop and the amount of money earned.
4. The farmer has recorded the yield of each livestock classification group during the last ten years. The record consists of the following historical data: the year (historical), Selling price per head, number of livestock in the end of the year, number of livestock sold during one-year period, and the total amount of money earned.
