Select * from Region RegionName Farms East 2 North 3 Select * from Animal AnimalType SubsidyRate Bull 1200.51 Cow 753.935 Goat 0 Pig 0 Sheep 669.564 Select * from ClaimHistory ClaimNo ClaimAmount Date ClaimCount RegionName 120 6000 2009-05-19 6 East 121 1520 2010-02-04 7 North 122 600 2010-02-16 8 East 123 500 2010-02-17 9 North Select * from Crops CropType SubsidyRate Cereal 227.095 Linseed 440.878 Oilseed 553.589 Protein 229.302 Select * from CurrentClaim ClaimNo ClaimAmount Date RegionName 124 0 2010-02-18 North 125 0 2010-02-18 North Select * from Farm FarmName FarmerFirstName FarmerSurname Address PhoneNumber ClaimNumber RegionName NoOfCows NoOfGoats NoOfSheep NoOfPigs NoOfBulls Cereal Oilseed Linseed Protein CurrentSubsidyEntitlement NFarm1 John1 TheFarmer1 Countryside 123456 123 North 10 10 10 10 10 100 100 100 100 0 NFarm2 John2 TheFarmer2 Countryside2 121215 124 North 11 11 11 11 11 101 101 101 101 0 NFarm3 John3 TheFarmer3 Countryside3 3578174 125 North 12 12 12 12 12 102 102 102 102 0 EFarm1 John4 TheFarmer4 Countryside4 1525748 126 East 13 13 13 13 13 103 103 103 103 0 EFarm2 John5 TheFarmer5 Countryside5 54946177 127 East 14 14 14 14 14 104 104 104 104 0 Note - Sorry for the display of the Farm table, It's too long to display properly.