.

List all functional dependencies for each of the following tables

(A) w tage Author First Vernor Stephen Randy 1382 Lon 138X BookCode Title 0180 A Deepness in the Sky 1351 Dreamcatcher: A Novel Treasure Chests 1382 Treasure Chests Beloved 2226 Harry Potter and the Prisoner of Azkaban 2281 Van Gogh and Gauguin 2281 Van Gogh and Gauguin 2766 Of Mice and Men 5163 Travels with Charley 5790 Catch-22 6328 Band of Brothers Book Price PublisherCode PublisherName AuthorNum AuthorLast 7.19 TB Tor Books 3 Vintage 19.60 SC Scribner 6 King 24.46 TA Taunton Press 23 O'Rourke 24.46 TA Taunton Press 25 Schleining 12.95 PL Plume 1 Morrison 13.96 ST Scholastic Trade 15 Rowling 21.00 WP Westview Press 9 Collins 21.00 WP Westview Press 19 Collins, Jr. 6.95 TB Tor Books 20 Steinbeck 7.95 PE Penguin USA 20 Steinbeck 12.00 SC Scribner 10 Heller 9.60 TO Touchstone 14 Ambrose Books 37.95 CT Course 7 Pratt Technology Toni J.K. Bradley Bradley John John Joseph Stephen E. 669x A Guide to SQL Philip (B) Membe MName Num 214 www Alice B. Harris MAddress MCity 325 Meadow Park Murkywater 12345 DinnerClub Invite Invite Accept Dinner Dinner Num date Date Date Code 82/23/14 2/27/14 3/15/14 DIS Glowing Sea Delight 92/23/14 3/1/14 3/15/14 DIS Glowing Sea Delight 10 3/20/14 3/27/14 4/1/14 D12 Ranch Superb Entre EntreeDes Code EN3 Stuffed crab 235 123 Rose Court Highlight 12349 EN3 Stuffed crab Gerald M. Gallega Alice B. Harris 214 325 Meadow Park Murkywater 12345 EN5 132 Jeanne Cooley 789 Main Roseville 12378 11 3/20/14 3/24/14 4/1/14 D12 Ranch Superb ENS Marinated steak Marinated steak Stuffed crab Stuffed crab 155 185 Ann Smith 765 5th Street David B. Brown 779 Rose Lane Roseville Oakville 12378 12389 14/5/23/15 6/1/15 6/15/1507 21 5/24/15 5/30/256/15/15 D7 Pirates of the Sea EN3 Pirates of the Sea EN3 (C) Daily Type Rate ID Type Description $50 ww Stations have views of the forest. RV Park Reserve Check-In Check- Cust First Clast LotDescription ID Date Jout Date ID CPNO Name Name 1 5/14/16 5/24/16 1 John Lamon (999) 123-1234 33 Faces the forest and provides a view of the wildlife. It provides easy access to the hiking trail. 3 6/1/16 6/6/16 3 Duane Puckett |(999) 333-1236 11 Provides a fantastic view of Denali and is located at the east side of the park. 4 6/1/16 6/9/16 Eugene McCart (999) 444-1237 33 Faces the forest and provides a view of the wildlife. It provides easy access to the hiking trail. 5 6/6/16 6/10/16 5 Lonnie Nordyke (999) 555-1238 23 Overlooks the forest and is located next to the salmon $60 DE Stations have views of Denali. $50 WW Stations have views of the forest. $45 WW Stations have views of the forest. run. 11 6/12/16 6/14/16 11 George Barajas $50 ww Stations have views of the forest. 15 6/15/16 6/20/16 16 6/16/16 6/20/16 15 Breanna Ear 16 Rodney Flury $45 RV Stations are located next to the river. $60 DE Stations have views of Denali. (999) 345-1245 32 Faces the forest and provides a view of the wildlife. It provides easy access to the nature trail. (999) 345-6124 23 Overlooks the river and is located next to the salmon run. 1999) 234-1250 11 Provides a fantastic view of Denali and is located at the east side of the park. (999) 444-1237 22 Overlooks the river and is located next to moose landing. (999) 123-1234 33 Faces the forest and provides a view of the wildlife. It provides easy access to the hiking trail. 20 21 7/3/16 7/1/16 7/8/164 7/8/16 Eugene McCart 1 John Lamon $45 RV Stations are located next to the river. $50 ww Stations have views of the forest