In the SQL given to create the DEPARTMENT table in the Elmasri Company Database in Figure 6.1 is as follows: CREATE TABLE DEPT( ARCHAR (10) NOT NULL INTEGER DNAME DNUMBER MGRSSN CHAR (9) MGRSTARTDATE CHAR (9), PRIMARY KEY (DNUHBER), UNIQUE (DNAME FOREIGN KEY (MGRSSN) REFERENCES EMP (SSN) NOT NULL NOT NULL Having the MGRSSN specified as NOT NULL enforces the constraint that every department has to have a manager. Now suppose we were to look at an alternative way of capturing the department information by having two tables: one table DEPT2 for the department information, and another table MANAGES for the manager information as follows: CREATE TABLE DEPT2 ( VARCHAR (10) DNAME DNUMBER PRIMARY KEY (DNUMBER), UNIQUE (DNAME): NOT NULL NOT NULL INTEGER CREATE TABLE MANAGES NOT NULL DNUMBER INTEGER MGRSSN CHAR (9) MGRSTARTDATE CHAR (9), PRIMARY KEY (DNUHBER), FOREIGN KEY (HGRSSN) REFERENCES EMP (SSN) NOT NULL Does having MGRSSN be NOT NULL in the MANAGES table enforce the constraint that every department has to have a manager ? . Give a YES/NO answer 2. Explain your