Please help with the given statement:
Query 1: Write a CREATE TABLE statement for the DEPARTMENT TABLE.
Query 2: Write a CREATE TABLE statement for the EMPLOYEE TABLE. Email is required and is an alternate key, and the default value of Department is Human Resources. Cascade updates but not deletions from DEPARTMENT to EMPLOYEE.
Query 3: Write a CREATE TABLE statement for the ASSIGNMENT TABLE. Cascade only deletions from PROJECT to ASSIGNMENT; do not cascade either deletions or updates from EMPLOYEE to ASSIGNMENT