1. (20 points) Shoes are sold in a variety of styles and sizes. A style is identified by a style. Each style has a single description (e.g. men's slippers) and the same description may apply to several styles. The attribute weekly-sales represents the number of shoes of a particular size and style sold in the previous week (e.g. 25 pairs style# 17, size 8). The attribute monthly-style-value represents the total sales value in the previous month for each style. Draw a FD diagram for the attributes stylell, style- description, size, weekly-sales, monthly-style-value. Convert your FD diagram into relations in 3NF. 2. (20 points) Consider the set of attributes A, B, C, D, E, F). Suppose that the following functional dependencies hold for these attributes: ABC BD CD E CEF FA a). Is AB E derivable from this set of FD's? b) Is CD A derivable from this set of FD's? c). Find one key for R(A, B, C, D, E, F). d). Find all keys for R(A, B, C, D, E, F). 3. (20 points) Let R(STUDENT#, NAME, BIRTHDAY, AGE, ADVISOR, DEPARTMENT, SEMESTER, COURSE, GRADE) be a relation with Key: STUDENT#, SEMESTER, COURSE FD= {STUDENT# NAME, STUDENT# BIRTHDAY, STUDENT# AGE, STUDENT# ADVISOR STUDENT# DEPARTMENT, BIRTHDAY AGE, ADVISOR DEPARTMENT, STUDENT#, SEMESTER, COURSE GRADE Find a 3NF database scheme for R