Normalize the data. Split the data into separated tables until all tables are normalized (i.e., BCNF). For each table, assign an appropriate primary key. (You may use surrogate keys.) You may optionally designate foreign keys to represent relationships between the tables. You may state any assumptions you make here

bone Boat Name Ebb Tide Midnight on the Water Seafarer IV Far Horizon Far Horizon Ebb Tide Foreign Shores Foreign Shores Midnight on the Water Foreign Shores Make Hans Christian Hunter Sabre Endeavor Endeavor Hans Christian Catalina Catalina Hunter Catalina Model Length 38 MK II M38 M32 M37 M37 38 MK II Morgan Morgan M38 Morgan Owner Last 38 Johnson 38 Gates 32 Downton 37 Gates 37 Gates 38 Johnson 38 Howard 38 Howard 38 Gates 38 Howard Owner First Pat Terry Kelly Terry Terry Pat Casey Casey Terry Casey Owner Phone Address City 425-765-4455 4567 35th W Bellevue 503-486-8786 1324 24th NE Portland 503-578-7574 2435 36th SE Astoria 503-486-8786 1 324 24th NE Portland 503-486-8786 1324 24th NE Portland 425-765-4455 4567 35th W Bellevue 206-543-66772345 15th NE Seattle 206-543-6677 2345 15th NE Seattle 503-486-8786 1324 24th NE Portland 206-543-6677 2345 15th NE Seattle State WA OR OR OR OR WA WA WA OR WA ZIP RentalDate 98040 6/23/19 97215 6/23/19 97103 6/30/19 97215 6/30/19 972157/7/19 98040 7 /7/19 981157/7/19 98115 7/21/19 972157/28/19 98115 7/28/19 Customer First Michael Pam M erideth Andrew Jim Jan Oscar Michael Pam Jan Customerlast Scott Beesley Palmer Bernard Halpert Levinson Martinez Scott Beesley Levinson Amount $6,000.00 $5,500.00 $4,000.00 $4,500.00 $4,500.00 $6,000.00 $5,000.00 $5,000.00 $5,500.00 $5,000.00