CONTACTS
+----------+----------+
| VendorID | FarmerID |
+----------+----------+
| 53 | 12 |
| 56 | 13 |
| 55 | 14 |
| 54 | 15 |
| 55 | 16 |
| 53 | 17 |
+----------+----------+
DISTRIBUTOR
+---------------+---------------+-----------------------+--------------------+----------+
| DistributorID | FarmerContact | Name | Address | PhoneNum |
+---------------+---------------+-----------------------+--------------------+----------+
| 24 | 16 | Plants Plants Plants! | 43 Haven Rd | 555-6783 |
| 25 | 12 | The Outdoor Store | 56 South Orange Ln | 555-6734 |
| 26 | 17 | Farmhills Farm Stand | 6 Farmhills Rd | 555-9834 |
+---------------+---------------+-----------------------+--------------------+----------+
FARMER
+----------+--------------+----------+------------------+--------+------------+
| FarmerID | Name | PhoneNum | Address | Salary | HireDate |
+----------+--------------+----------+------------------+--------+------------+
| 12 | Brian Smith | 555-9384 | 22 Lincon Park | 70000 | 1996-10-08 |
| 13 | Chris Slover | 555-8394 | 43 West Millford | 65000 | 2004-10-06 |
| 14 | Nate Litvak | 555-2317 | 84 Sunset Grove | 60000 | 2008-04-03 |
| 15 | Marcus Ford | 555-0976 | 32 Sawmil Rd | 58000 | 2010-05-23 |
| 16 | Daisy Dukes | 555-1233 | 28 Highland Blvd | 63000 | 2012-05-11 |
| 17 | Helen Hay | 555-4195 | 3 Turner Way | 70000 | 1995-03-19 |
+----------+--------------+----------+------------------+--------+------------+
FIELD
+----------+----------+--------------+-------------+
| Location | SoilType | CurrentPlant | DatePlanted |
+----------+----------+--------------+-------------+
| 10W25N | 3 | Tulip | 2013-04-11 |
| 20E25S | 1 | Daffodil | 2013-02-11 |
| 20E30N | 1 | Sunflower | 2013-03-11 |
| 30W30S | 2 | Rose | 2013-06-11 |
| 5E5S | 5 | Violet | 2013-05-11 |
+----------+----------+--------------+-------------+
HARVEST
+-------------+---------------+-----------+------------+----------------+--------------+-----------------+-----------+------------+
| HarvestDate | FieldLocation | PlantType | PlantCount | ExpirationDate | PurchaseDate | DistributorSold | PriceSold | ReturnDate |
+-------------+---------------+-----------+------------+----------------+--------------+-----------------+-----------+------------+
| 2013-10-11 | 5E5S | Violet | 150 | NULL | 2013-10-15 | 24 | 5000 | NULL |
| 2013-10-12 | 30W30S | Rose | 203 | NULL | NULL | NULL | NULL | NULL |
| 2013-10-13 | 20E30N | Sunflower | 157 | 2014-01-22 | NULL | NULL | NULL | NULL |
| 2013-10-14 | 10W25N | Tulip | 50 | NULL | NULL | NULL | NULL | NULL |
| 2013-10-15 | 20E25S | Daffodil | 303 | NULL | NULL | NULL | NULL | NULL |
+-------------+---------------+-----------+------------+----------------+--------------+-----------------+-----------+------------+
ISRESPONSIBLEFOR
+----------+---------------+
| FarmerID | FieldLocation |
+----------+---------------+
| 12 | 10W25N |
| 17 | 20E25S |
| 13 | 20E30N |
| 12 | 30W30S |
| 15 | 5E5S |
+----------+---------------+
MATERIAL
+--------------+
| MaterialType |
+--------------+
| Fertilizer |
| Gas Tank |
| Pesticide |
| Plow |
| Tractor |
+--------------+
MATERIAL_BUNDLE
+----------+---------------+--------------+----------+-------+------------+
| VendorID | DatePurchased | MaterialType | Quantity | Price | ReturnDate |
+----------+---------------+--------------+----------+-------+------------+
| 53 | 2000-11-12 | Plow | 1 | 10000 | NULL |
| 53 | 2012-05-20 | Plow | 1 | 10000 | 2012-06-05 |
| 54 | 2000-11-12 | Gas Tank | 5 | 25000 | NULL |
| 55 | 2000-11-12 | Pesticide | 500 | 10000 | NULL |
| 55 | 2000-11-12 | Tractor | 1 | 5000 | NULL |
| 56 | 2000-11-12 | Fertilizer | 100 | 2000 | NULL |
+----------+---------------+--------------+----------+-------+------------+
SEED
+-----------+
| SeedType |
+-----------+
| Daffodil |
| Poppy |
| Rose |
| Sunflower |
| Tulip |
| Violet |
+-----------+
SEED_BUNDLE
+----------+---------------+-----------+----------+-------+------------+
| VendorID | DatePurchased | SeedType | Quantity | Price | ReturnDate |
+----------+---------------+-----------+----------+-------+------------+
| 53 | 2012-04-18 | Sunflower | 1000 | 50 | NULL |
| 53 | 2012-05-18 | Tulip | 3000 | 200 | NULL |
| 54 | 2012-07-18 | Rose | 2000 | 100 | NULL |
| 54 | 2012-08-18 | Poppy | 5000 | 450 | NULL |
| 55 | 2012-06-18 | Violet | 20000 | 600 | NULL |
| 56 | 2011-05-18 | Daffodil | 10000 | 500 | 2011-06-05 |
| 56 | 2011-06-29 | Daffodil | 4000 | 100 | NULL |
+----------+---------------+-----------+----------+-------+------------+
SOIL
+--------+-------------+
| TypeID | SoilType |
+--------+-------------+
| 1 | Sandy |
| 2 | Silty |
| 3 | Clay |
| 4 | Peaty |
| 5 | Saline Soil |
+--------+-------------+
VENDOR
+----------+------------------+------------------------+----------+
| VendorID | Name | Address | PhoneNum |
+----------+------------------+------------------------+----------+
| 53 | Lauren Wentworth | 5 Fox Hill Rd. | 555-2345 |
| 54 | george Doughtry | 15 Pleasant Valley Rd. | 555-3456 |
| 55 | Henrey Mullen | 34 Park Place | 555-9485 |
| 56 | Richard Young | 12 Regional St. | 555-3849 |
+----------+------------------+------------------------+----------+
+----------+----------+
| VendorID | FarmerID |
+----------+----------+
| 53 | 12 |
| 56 | 13 |
| 55 | 14 |
| 54 | 15 |
| 55 | 16 |
| 53 | 17 |
+----------+----------+
DISTRIBUTOR
+---------------+---------------+-----------------------+--------------------+----------+
| DistributorID | FarmerContact | Name | Address | PhoneNum |
+---------------+---------------+-----------------------+--------------------+----------+
| 24 | 16 | Plants Plants Plants! | 43 Haven Rd | 555-6783 |
| 25 | 12 | The Outdoor Store | 56 South Orange Ln | 555-6734 |
| 26 | 17 | Farmhills Farm Stand | 6 Farmhills Rd | 555-9834 |
+---------------+---------------+-----------------------+--------------------+----------+
FARMER
+----------+--------------+----------+------------------+--------+------------+
| FarmerID | Name | PhoneNum | Address | Salary | HireDate |
+----------+--------------+----------+------------------+--------+------------+
| 12 | Brian Smith | 555-9384 | 22 Lincon Park | 70000 | 1996-10-08 |
| 13 | Chris Slover | 555-8394 | 43 West Millford | 65000 | 2004-10-06 |
| 14 | Nate Litvak | 555-2317 | 84 Sunset Grove | 60000 | 2008-04-03 |
| 15 | Marcus Ford | 555-0976 | 32 Sawmil Rd | 58000 | 2010-05-23 |
| 16 | Daisy Dukes | 555-1233 | 28 Highland Blvd | 63000 | 2012-05-11 |
| 17 | Helen Hay | 555-4195 | 3 Turner Way | 70000 | 1995-03-19 |
+----------+--------------+----------+------------------+--------+------------+
FIELD
+----------+----------+--------------+-------------+
| Location | SoilType | CurrentPlant | DatePlanted |
+----------+----------+--------------+-------------+
| 10W25N | 3 | Tulip | 2013-04-11 |
| 20E25S | 1 | Daffodil | 2013-02-11 |
| 20E30N | 1 | Sunflower | 2013-03-11 |
| 30W30S | 2 | Rose | 2013-06-11 |
| 5E5S | 5 | Violet | 2013-05-11 |
+----------+----------+--------------+-------------+
HARVEST
+-------------+---------------+-----------+------------+----------------+--------------+-----------------+-----------+------------+
| HarvestDate | FieldLocation | PlantType | PlantCount | ExpirationDate | PurchaseDate | DistributorSold | PriceSold | ReturnDate |
+-------------+---------------+-----------+------------+----------------+--------------+-----------------+-----------+------------+
| 2013-10-11 | 5E5S | Violet | 150 | NULL | 2013-10-15 | 24 | 5000 | NULL |
| 2013-10-12 | 30W30S | Rose | 203 | NULL | NULL | NULL | NULL | NULL |
| 2013-10-13 | 20E30N | Sunflower | 157 | 2014-01-22 | NULL | NULL | NULL | NULL |
| 2013-10-14 | 10W25N | Tulip | 50 | NULL | NULL | NULL | NULL | NULL |
| 2013-10-15 | 20E25S | Daffodil | 303 | NULL | NULL | NULL | NULL | NULL |
+-------------+---------------+-----------+------------+----------------+--------------+-----------------+-----------+------------+
ISRESPONSIBLEFOR
+----------+---------------+
| FarmerID | FieldLocation |
+----------+---------------+
| 12 | 10W25N |
| 17 | 20E25S |
| 13 | 20E30N |
| 12 | 30W30S |
| 15 | 5E5S |
+----------+---------------+
MATERIAL
+--------------+
| MaterialType |
+--------------+
| Fertilizer |
| Gas Tank |
| Pesticide |
| Plow |
| Tractor |
+--------------+
MATERIAL_BUNDLE
+----------+---------------+--------------+----------+-------+------------+
| VendorID | DatePurchased | MaterialType | Quantity | Price | ReturnDate |
+----------+---------------+--------------+----------+-------+------------+
| 53 | 2000-11-12 | Plow | 1 | 10000 | NULL |
| 53 | 2012-05-20 | Plow | 1 | 10000 | 2012-06-05 |
| 54 | 2000-11-12 | Gas Tank | 5 | 25000 | NULL |
| 55 | 2000-11-12 | Pesticide | 500 | 10000 | NULL |
| 55 | 2000-11-12 | Tractor | 1 | 5000 | NULL |
| 56 | 2000-11-12 | Fertilizer | 100 | 2000 | NULL |
+----------+---------------+--------------+----------+-------+------------+
SEED
+-----------+
| SeedType |
+-----------+
| Daffodil |
| Poppy |
| Rose |
| Sunflower |
| Tulip |
| Violet |
+-----------+
SEED_BUNDLE
+----------+---------------+-----------+----------+-------+------------+
| VendorID | DatePurchased | SeedType | Quantity | Price | ReturnDate |
+----------+---------------+-----------+----------+-------+------------+
| 53 | 2012-04-18 | Sunflower | 1000 | 50 | NULL |
| 53 | 2012-05-18 | Tulip | 3000 | 200 | NULL |
| 54 | 2012-07-18 | Rose | 2000 | 100 | NULL |
| 54 | 2012-08-18 | Poppy | 5000 | 450 | NULL |
| 55 | 2012-06-18 | Violet | 20000 | 600 | NULL |
| 56 | 2011-05-18 | Daffodil | 10000 | 500 | 2011-06-05 |
| 56 | 2011-06-29 | Daffodil | 4000 | 100 | NULL |
+----------+---------------+-----------+----------+-------+------------+
SOIL
+--------+-------------+
| TypeID | SoilType |
+--------+-------------+
| 1 | Sandy |
| 2 | Silty |
| 3 | Clay |
| 4 | Peaty |
| 5 | Saline Soil |
+--------+-------------+
VENDOR
+----------+------------------+------------------------+----------+
| VendorID | Name | Address | PhoneNum |
+----------+------------------+------------------------+----------+
| 53 | Lauren Wentworth | 5 Fox Hill Rd. | 555-2345 |
| 54 | george Doughtry | 15 Pleasant Valley Rd. | 555-3456 |
| 55 | Henrey Mullen | 34 Park Place | 555-9485 |
| 56 | Richard Young | 12 Regional St. | 555-3849 |
+----------+------------------+------------------------+----------+