I need to find out if this table classifies as a relation, what the candidate ke
ID: 3908792 • Letter: I
Question
I need to find out if this table classifies as a relation, what the candidate keys are, and what the functional dependencies are. Any help would be appreciated!
BoatName Make Model Length OwnerLastName OwnerFirstNameOwnerPhone | Address City State ZIP CharterDate CustomerName Far Horizon Ebb Tide Far Horizon Far Horizon Foreign Shores Seafarer V Seafarer V Midnight on the WaterSabre Ebb Tide Foreign Shores Amount S 5,000.00 S 5,500.00 S 5,000.00 S 5,000.00 S 6,000.00 $ 4,500.00 S 4,500.00 S 4,000.00 $ 5,500.00 S 6,000.00 38 Princeton 38 Tulsa 38 Princeton 38 Princeton Da Bill Da Da Catalina Hunter Catalina Catalina Hans Christian38 MK Endeavour 37 Endeavour x;?43?// ?145 1? HI ! tkstilks n#A ??115 21 J.In.1 503-486-8786 1324 24th NE Portland OR 97215 21-Jun-14 206-543-6677 2345 15th NE SeattleWA 98115 28-Jun-14 WA 98115 4-Jul-14 425-765-4455 4567 35th W Bellevue WA 98040 4-Jul-14 503-486-8786 1324 24th NE PortlandOR97215 4-Jul-14 503-486-8786 1324 24th NE Portland OR 97215 18-Jul-14 OR | 97103| 18-Jul-14 503-486-8786 1324 24th NE PortlandOR97215 27-Jul-14 425-765-4455 4567 35th W Bellevue WA98040 27-Jul-14 Smith Sailors, Mike Tully, Jason Atkins, Merle Morgan Morgan 206-543-6677 2345 15th NE Seattle 37 Tulsa 37 Tulsa 32 Oxford 38 Tulsa 38 Berkel Bill Bill Travis, Chet Watson, John 37 32 38 503-578-75742435 36th SE Astoria Renborn, "Doc Hunter Hans Christian38 MK Sailors, Mike Tully JasornExplanation / Answer
Functional Dependencies:
BoatName , Make -> Model,length
OwnerLastName,OwnerFirstName -> OwnerPhone,Address,City,State,Zip
BoatName,CustomerName -> CharterDate,Amount
Candidate keys are on the left side of funtional dependencies BoatName,Make,OwnerLastName, OwnerFirstName, CustomerName
Based on Functional dependencies, the following relations can be formed: Boat,Owner and BoatCharter
Boat(BoatName ,Make, Model,length)
Owner(OwnerLastName,OwnerFirstName , OwnerPhone,Address,City,State,Zip,BoatName)
BoatCharter(BoatName,CustomerName , CharterDate,Amount)
underlined are primary keys (composite) and italicised are foreign keys .
Do ask if any doubt. Please upvote.