Normalise the following relation to 3rd normal form, showing all steps and indicate any assumption you have made. The following un normalised table stores information about golfers and records information about each round of golf they play. A golfer may only record one round of golf per day. (GolferNO, Golf_Name, Golf_Address, Golf_Phone, Gender , CategoryNO, CategoryName, Handicap, (DatePlayed, LocationNO, LocationName, ConditionType, Condition_Description, Score)) Field Definition Field Definition GolferNO Represents a unique number that is assigned to a golf player CategoryNO A golfer is a assigned to a specific category Golf_Name Represents a golfer's name CategoryName Represents a Category name Golf_Address Represents a golfer's address DatePlayed Represents the date a player played a round of golf at a specific location. Golf_Phone Represents a golfer's phone number LocationNO Represents a unique number that is assigned to represent a specific location (golf course) Handicap Represents a golfer's assigned handicap number LocationName Represents a location name Score Represents the score a golf player achieved playing a round of golf on a particular date at a specific location ConditionType Represents a unique number that is assigned to represent a specific weather condition Condition_Description Represents the full description of a condition (10 marks) Question 2 For each of the tables listed below, state the normal form they currently adhere to. You must provide an explanation for your choice. (a) (StockNO, WarehouseNO, WarehouseName, StockName QtyonHand, SelfLocation, Unit_Price) Dependencies StockNO → StockName, Unit_Price WarehouseNO → WarehouseName, StockNO, WarehouseNO → QtyonHand, SelfLocation (b) (StudentNO, SubjectNO, Semester, Year, Grade) Dependencies StudentNO, SubjectNO, Semester, Year → Grade ( 5 marks) Question 3: Normalise the following user view to 3rd normal form. Show all steps and list any assumptions you have made. Note: The field 'Sale Price' represents the product unit price and the point of sale. Your database design should include the current price ( Unit Cost ) of any product