Question: color Outer Dims Width Height 100 Crescent Pre-Cut Maroon List_Price 4.75 50 11 14 101 Museum Gallery Arctic White 36 8 10 7.43 102 Crescent

color Outer Dims Width Height 100 Crescent

color Outer Dims Width Height 100 Crescent Pre-Cut Maroon List_Price 4.75 50 11 14 101 Museum Gallery Arctic White 36 8 10 7.43 102 Crescent Pre-Cut Arctic White 36 8 10 4.75 104 Roadshow 3-in-1 Biscayne Blue 144 32 40 40.10 103 Blick Double Arctic White 28 8 6 7.43 105 Suede Acid-Free Antelope 72 16 20 16.69 a. (10 points) Use the relation above (it is in at least 1NF) to determine ALL functional dependencies that the data suggests MAY be present. Use A -> notation. To be very clear: identify all minimal (atomic) functional dependencies that have data that suggest this functional dependency may exist, even if you think the functional dependency would fail a logical test. You should have more blank spaces below than you need. Fill in however many you find. Be sure to note any assumptions. I > color Outer Dims Width Height 100 Crescent Pre-Cut Maroon List_Price 4.75 50 11 14 101 Museum Gallery Arctic White 36 8 10 7.43 102 Crescent Pre-Cut Arctic White 36 8 10 4.75 104 Roadshow 3-in-1 Biscayne Blue 144 32 40 40.10 103 Blick Double Arctic White 28 8 6 7.43 105 Suede Acid-Free Antelope 72 16 20 16.69 a. (10 points) Use the relation above (it is in at least 1NF) to determine ALL functional dependencies that the data suggests MAY be present. Use A -> notation. To be very clear: identify all minimal (atomic) functional dependencies that have data that suggest this functional dependency may exist, even if you think the functional dependency would fail a logical test. You should have more blank spaces below than you need. Fill in however many you find. Be sure to note any assumptions. I >

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!