Answer Happy

Given the relation CarSurvey, which holds information for a market study. The relation holds data for the observed preferences of the owners of the cars: • Owner (ownlD, ownName) of the car(s); • Car: cType (e.g. gas, diesel or electric), producer: prdiD and prdName (e.g. BMW, Toyota, Tesla, etc), date of purchase (Date); • Location of the owner: locID (e.g. postal code), locName and locType, which could be village, small town, regional centre, capital city. Note: one owner may have one or more cars from different producers. Find functional dependencies and normalize it up to 3NF. CarSurvey {ownlD, ownName, cType, prdID, prdName, LocID, LocType, Date}