1.Consider the relation schema EMP_DEPT in Figure lO.3a and the following set G of
functional dependencies on EMP_DEPT: G = {SSN -7 ENAME, BDATE, ADDRESS, DNUMBER, DNUMBER -7 {DNAME, DMGRSSNn. Calculate the closures SSN+ and DNUMBER+ with respect toG.
2. Is the set of functional dependencies G in Exercise 10.20 minimal? If not, try to find a minimal set offunctional dependencies that is equivalent to G. Prove that your set is equivalent to G.