Mati Color Outer Wah 200 101 Het Brand Crescent. Pre-Cut Museum Gallery Crescent Precut Roadshow 3-in-1 0 36 14 102 10 Maroon Arctic White Arctie White Biscayne Blue Arctic White TA 36 10 104 103 14 32 10 10.10 Blick Double Suede Acid-Free 105 6 28 22 Antelope 16 20 16. a. (10 points) Use the relation above (it is in at least INF) to determine ALL functional dependencies that the data suggests MAY be present. Use AB 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. -> > b. (7 points) Would any of these functional dependencies cause you to be surprised if it was not removed eliminated as being a legitimate functional dependency when it is eventually tested locally why or why not? If you have more than one option for your response, choose the one that would surprise you the most Be sure to explain your reasoning. C. (6 points) Which attribute (if any) could be eliminated without losing any real content, because it seems to be a type of redundancy? Briefly explain your reasoning. d. (12 points) Use the attributes and dependency diagram shown below to losslessly normalize this table, Specifically, put this relation into 2NF, and then into 3NF, showing each normal form. It is currently in at least 1NF. SCHOOL_SPORT_MASCOT d. (12 points) Use the attributes and dependency diagram shown below to losslessly normalize this table. Specifically, put this relation into 2NF, and then into 3Ne, showing each normal form It is currently in at least 1NF. SCHOOL_SPORT_MASCOT University Sport Mascot_Name Mascot_Symbol Season_Start Date 2NF: b. (7 points) Would any of these functional dependencies cause you to be surprised M it was not removed le, not eliminated as being a legitimate functional dependency) when it is eventually tested logically? Www or why not? If you have more than one option for your response, choose the one that would surprise you the most. Be sure to explain your reasoning. C (6 points) Which attribute (if any) could be eliminated without losing any real content, because it seems to be a type of redundancy? Briefly explain your reasoning. d. (12 points) Use the attributes and dependency diagram shown below to losslessly normalize this table. Specifically, put this relation into 2NF, and then into 3NF, showing each normal form, It is currently in at least INF SCHOOL_SPORT_MASCOT 100% Mati Brand Color 100 Outer Dims 50 Width Maroon Arctic White Height 14 List Price 101 4.75 36 102 10 Crescent Pre-Cut Museum Gallery Crescent Pre-Cut Roadshow 3-in-1 Blick Double Suede Acid-Free Arctic White 36 8 104 10 47 1144 32 10 103 40.10 Biscayne Blue Arctic White Antelope 28 8 5 105 16 20 16:53 (10 points) Use the relation above (it is in at least INF) to determine ALL. functional dependencies that the dat suggests MAY be present. Use A B 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 function dependency would fail a logical test. You should have more blank spaces below than you need. Fill in however many vou find. Be sure to note any assumptions. 10S Suede Acid-Free Antelope 72 16 20 16.62 a. (10 points) Use the relation above (it is in ot least INF) to determine ALL functional dependencies that the dats suggests MAY be present. Use AB 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. > >
