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. */

"3,4,and 5 are answered" as per our policy we are only allowed to solve 3 subparts.kindly reupload rest of the question 3 create table CREATE TABLE table1 (    day varchar(255),    client_code varchar(255),    client_name varchar(255),    team_ID varchar(255),    member int,   team_leader varchar(255),  leader_wage int,  total int);     Step 2 4.insert data into table INSERT INTO table1 (day,client_code,client_name,team_ID,member,team_leader,leader_wage,total) VALUES (  'monday','c4','aeliana gebahard','T3','6','jaymes merrickson','350','850'); INSERT INTO table1 (day,client_code,client_name,team_ID,member,team_leader,leader_wage,total) VALUES (' ','c10','alfher dareia','T1','6','geoffrey glover','250','750'); INSERT INTO table1 (day,client_code,client_name,team_ID,member,team_leader,leader_wage,total) VALUES (  ' ','c8','felina diodotus','T2','5','elmer victorson','300','700'); INSERT INTO table1 (day,client_code,client_name,team_ID,member,team_leader,leader_wage,total) VALUES ('…

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…