Create an ER model to represent the following scenario.

1. A farm would like to use a database to more accurately track its operations. The farm has many fields, each of which is identified by a number. Each eld grows a certain crop, starting at a planting date when the seeds are first sown, and ending at a harvest date. A field also has a known land area. A crop is identified by a combination of species, genus, and variety names, and all crops have a germination period (in weeks), a growth period (in weeks), and an average yield per plant. A crop may be grown on more than one eld, but a eld may contain at most one crop. Each eld/crop combination needs a unique fertilizer mixture. Fertilizer is a mixture of some amounts of Nitrogen, Phosphorus, and Potassium (% of total weight), among other trace elements that are negligible for the scope of this exercise. Additionally, the amount of fertilizer used per square kilometer is also important to keep track of. And nally, the date and total volume of each fertilizer application to each eld should be recorded.

2. For this exercise, use your existing model from the 1 exercise. Suppose that now, you must also model a different type of eld: a pasture for animal grazing. This eld cannot grow crops, and does not need fertilizer, but should hold information about what animals use the pasture. Each animal is identified by a tag number, and you should keep track of its weight, and species/genus just as with crops. Many different animals may be assigned to a single pasture. Additionally, only certain species of livestock eat certain species of crops, so be sure to nd a way to model this as well. On a separate note, crops should now be separated into two categories: annuals (1 growth cycle), and perennials (many growth cycles). Since perennials' growth is infinite, there is no need to record a growth period for these plants. Instead, the age of each perennial crop should be recorded.