For problems 1-3, answer/do the following based on the relations provided below: a) Identify (already done for #1) and label the type of the dependencies (student completes labeling). b) Identify what normal form the relation is in and explain why. c) Identify a set of 3NF relations (draw the relational schema). 1) Statesboro Zoo would just like to see if you can normalize a relation by testing you with the following scenario. GENERALTABLE Att1 Att2 Att3 Att4 Att5 Att6 1 2) CUSTOMER_OFFER CustID Address Name Zip OfferID OfferUsed Description MerchCode MerchDesc ExpirationDate Issue Date Customers receive offers for zoo merchandise (such as 20% off t-shirts through November 1). o The zoo wants to track the names and addresses of customers that receive offers. o The zoo wants to track the issue date, expiration date and description of the various offers. o The zoo also wants to track whether a customer used a particular offer. For problems 1-3, answer/do the following based on the relations provided below: a) Identify (already done for #1) and label the type of the dependencies (student completes labeling). b) Identify what normal form the relation is in and explain why. c) Identify a set of 3NF relations (draw the relational schema). 1) Statesboro Zoo would just like to see if you can normalize a relation by testing you with the following scenario. GENERALTABLE Att1 Att2 Att3 Att4 Att5 Att6 1 2) CUSTOMER_OFFER CustID Address Name Zip OfferID OfferUsed Description MerchCode MerchDesc ExpirationDate Issue Date Customers receive offers for zoo merchandise (such as 20% off t-shirts through November 1). o The zoo wants to track the names and addresses of customers that receive offers. o The zoo wants to track the issue date, expiration date and description of the various offers. o The zoo also wants to track whether a customer used a particular offer