Given the following tables, there is a university rule preventing a student from enrolling in a new class if there is an unpaid fine. Please write a table-level CHECK constraint to implement the rule. */

Assume the EMPLOYEE table contains four attributes, ID, DEPT, SALARY and NAME, and has the following rows ID      DEPT     SALARY   NAME    100   SALES     40000       Smith     101     RD         38000       Terry     102     HR         60000       David     103   SALES    58000       Ellie     104      RD       70000       Judy The DEPARTMENT table contains two attributes, DEPTNAME and PHONE, and has the following rows:  DEPTNAME    PHONE     RD               8596001234     SALES        8596005555    HR              8596009876  A.) The EMPLOYEE table needs to enforce the following integrity constraints: • The ID is the primary key.  • The DEPT column is a foreign key that references the DEPTNAME in the DEPARTMENT table, so that any value that appears in the DEPT column should also exist in the DEPARTMENT table.  • The value for the NAME column can never be null.  What should be the statement used to create the EMPLOYEE table, if 1) the table was created as a partitioned table such…