4) Consider the following relation GROUPS: Employee# Salary | Budget Group-Name Account:s Job Description 3000 4500Database 4500Architecture 5500Architecture 5500Database 5500 5000Accounts 5000Architecture 5000Architecture 5000Database 45 50 50 50 50 45 45 50 50 50 accountant rogrammer programmer manager consultant consultant manager Account:s ro er rogrammer manager Relation GROUPS stores information about working groups in a company. For each group, its name and budget are stored as well as the number of the employees assigned to it, their salary and job description. The key for GROUPS is composed of attributes Employee# and Group Name. a) What anomalies mav arise in this relation? (9%) b) Translate the following two assumptions into functional dependencie:s (6%) The salary of a given employee is unique and depends only on the employee (i.e., the salary corresponding to a given Employee# must (associated with relation GROUPS): be the same in all tuples containing such Employee#1 The money allocated for a given group is unique and depends only on the group (i.e., the value for the attribute Budget is the same in all tuples containing a given Group Name) c) d) Provide the precise definition of Third normal form What is the functional dependency generated by the key of this relation? (390) (7%)