1. Given a big relation BB and full functional dependencies in the relation, BB (CID, CNAME, CADDRESS, CPHONE, FILM ID, TAPE NUM, TITLE, RATE, CONDITION, TYPE, PRICE, DUE_DATE) Customer Name (CNAME), Address (CADDRESS), and customer phone (CPHONE) can be determined by knowing the values of customer ID(CID) The title, rate, and type of a film can be identified by knowing the values of film identification number (FILM_ID). The rent price of a film (PRICE) is determined by the values of type of film (TYPE) The condition of a film (CONDITION) can be checked by the values of film identification number (FILM_ID) and tape number (TAPE_NUM). The due date (DUE_DATE) of a film by a customer can be determined by the value of customer ID (CID), film identification number (FILM_ID) and tape number (TAPE_NUM). a) Draw functional dependency diagram for BB to identify a partial and a transitive dependency. ) Decompose BB into smaller relations that all are in 3NF. Provide relations in 2NF and 3NF respectively