Given the relation CarSurvey, which holds information for a market study. The relation holds data for the observed prefe

[answerhappygod]

Given The Relation Carsurvey Which Holds Information For A Market Study The Relation Holds Data For The Observed Prefe 1 (62.01 KiB) Viewed 37 times

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}