For problems 13, answer/do the following based on the relations provided for each: a. Label the dependencies. b. Identify what normal form the relation is in and explain why. c. Identify a set of 3NF relations (draw the relational schema). Problem 1: GENERAL_TABLE Eagle Hotel would just like to see if you can normalize a relation by testing you with the following scenario. a. label dependencies: b. identify the normal form: unnormalized, 1st normal form, or 2nd normal form? c. draw 3rd normal form relations (there are 3) Problem 2: PRODUCT_RECEIPT - Customers can purchase products at convenience marts in each of the hotels. - Products are supplied by vendors. - The hotel chain wants to track Product data, Vendor data, and Receipts. - The hotel chain wants the Receipt to include the sale date and the quantity sold of each Product. a. label dependencies b. what normal form is the relation in: unnormalized, 1st normal form, or 2nd normal form? c. 3rd normal form relations: - The hotel chain wants to track employee information. - The hotel would like to track the formal education level of each employee by tracking all degrees an employee has earned by degree name and type - The hotel chain also wants to track the training courses each employee has completed. Each course has a course number and title. - An employee can earn multiple degrees and complete multiple training courses. - The hotel chain wishes to track the date an Employee completed a Course, and the date an Employee earned a Degree Dalntinn b. what normal form is the relation in: unnormalized, 1st normal form, or 2nd normal form? c. 3rd normal form relations: (hint there are 5 )