Place the following tables in BCNF / 4NF

1)

c3 ? c4 c2 ? c7 c1 ? ? c5 (c1,c2) ? c6

2) Zoo database

Animal id uniquely identifies each individual animal at the zoo. If you know an animal id, you know the animal type, feeding time, location, animal food, cleaning time, medicines, and vet. Cleaning time and feeding times are done by location. Each type of animal has its own assigned vet and assigned food. Medicines, of course, are individualized by specific animal.

3) (Farmer) ? ?(Variety) ? ? (Farmer) ?(Location) ? ? (Variety) ?(HarvestDate)?

4)

Transcribed Image Text:

c1 a b b с с с d d e c2 1 2 3 4 5 5 6 7 8 للا c3 CC CC CC dd dd dd ee ee ee c4 red red red blue blue blue green green green 5 13 14 3 6 7 9 8 1 сб up left right down east east west west south c7 8 7 6 5 4 4 3 сл 2 1 animalld 26964 26964 26964 72235 54575 99382 70387 70387 38481 47374 47374 29189 74445 61317 46591 48407 23068 12946 AnimalType Feeding Time Location African Lion African Lion Penguin African Lion 9am African Lion 9am Bengal Tiger 9am Rhinoceros 1pm Rhinoceros 1pm Rhinoceros 1pm Ostrich Spider Monkey 9am Hippopotamus1pm Hippopotamus1pm Spider Monkey 9am Spider Monkey Sloth FruitBat Sea Lion 11am 1pm 3pm 3pm 3pm 3pm 10am 11am 1 1 1 1 1 2 14 4 14 14 14 14 3 3 3 13 15 2 AnimalFood Cleaning Time Medicines 2pm 2pm 2pm 2pm 2pm beef beef beef beef beef fish grass grass grass grass grass fruit insects 3pm fruit fruit leaves 9am fruit fish 3pm 3pm 3pm 3pm 3pm 1pm 1pm 1pm 1pm 8am 9am Vitamin Penicillin Vitamin Ketoconazole Dr. Linch Dr. Linch Metronidazole Dr. Linch Ivermectin Dr. Ketoconazole Sidney Dr. Snow Ketoconazole Dr. Snow Prednisone Tramadol Doxycycline null Ivermectin Vet Prednisone Dr. Linch Dr. Linch Ivermectin null Ivermectin Dr. Snow Ketoconazole Dr. Linch Dr. Snow Dr. Snow Dr. Sidney Dr. Linch Dr. Linch Dr. Van Dr. Van Dr. Van Farmer Variety Brown Redhaven Harvest Date Location Brown Glowhaven, Loring Mid July Sexton Redhaven Early July Brown Cresthaven, Alberta Late July Sexton Loring Early July Mid July Redlick Redlick Redlick Ludwig Ludwig Band The Shins U2 Home Country Status USA Ireland Lumineers USA Vampire Weeked USA Crystal Fighters Band Grammy England Nominated Yes Nominated Yes No Release Dates 2001, 2012 1987, 1991, Songs New Slang, Simple Song With or Without You, Mysterious Ways, Beautiful Day 2000 Ho Hey, Sleep on the Floor Oxford Comma, Obvious Bicycle At Home 2012, 2016 2008, 2013 2010 Play Lengths 3:51, 4:15 4:56, 4:04, 4:06 2:43, 3:38 3:15, 4:10 3:50 c1 a b b с с с d d e c2 1 2 3 4 5 5 6 7 8 للا c3 CC CC CC dd dd dd ee ee ee c4 red red red blue blue blue green green green 5 13 14 3 6 7 9 8 1 сб up left right down east east west west south c7 8 7 6 5 4 4 3 сл 2 1 animalld 26964 26964 26964 72235 54575 99382 70387 70387 38481 47374 47374 29189 74445 61317 46591 48407 23068 12946 AnimalType Feeding Time Location African Lion African Lion Penguin African Lion 9am African Lion 9am Bengal Tiger 9am Rhinoceros 1pm Rhinoceros 1pm Rhinoceros 1pm Ostrich Spider Monkey 9am Hippopotamus1pm Hippopotamus1pm Spider Monkey 9am Spider Monkey Sloth FruitBat Sea Lion 11am 1pm 3pm 3pm 3pm 3pm 10am 11am 1 1 1 1 1 2 14 4 14 14 14 14 3 3 3 13 15 2 AnimalFood Cleaning Time Medicines 2pm 2pm 2pm 2pm 2pm beef beef beef beef beef fish grass grass grass grass grass fruit insects 3pm fruit fruit leaves 9am fruit fish 3pm 3pm 3pm 3pm 3pm 1pm 1pm 1pm 1pm 8am 9am Vitamin Penicillin Vitamin Ketoconazole Dr. Linch Dr. Linch Metronidazole Dr. Linch Ivermectin Dr. Ketoconazole Sidney Dr. Snow Ketoconazole Dr. Snow Prednisone Tramadol Doxycycline null Ivermectin Vet Prednisone Dr. Linch Dr. Linch Ivermectin null Ivermectin Dr. Snow Ketoconazole Dr. Linch Dr. Snow Dr. Snow Dr. Sidney Dr. Linch Dr. Linch Dr. Van Dr. Van Dr. Van Farmer Variety Brown Redhaven Harvest Date Location Brown Glowhaven, Loring Mid July Sexton Redhaven Early July Brown Cresthaven, Alberta Late July Sexton Loring Early July Mid July Redlick Redlick Redlick Ludwig Ludwig Band The Shins U2 Home Country Status USA Ireland Lumineers USA Vampire Weeked USA Crystal Fighters Band Grammy England Nominated Yes Nominated Yes No Release Dates 2001, 2012 1987, 1991, Songs New Slang, Simple Song With or Without You, Mysterious Ways, Beautiful Day 2000 Ho Hey, Sleep on the Floor Oxford Comma, Obvious Bicycle At Home 2012, 2016 2008, 2013 2010 Play Lengths 3:51, 4:15 4:56, 4:04, 4:06 2:43, 3:38 3:15, 4:10 3:50

Answer rating: 100% (QA)

The given relations are Rc1c2c3c4c5c6c7 and the functional dependencies are c3c4 c... View the full answer