1. Change the Salary column in the Employee table to reject nulls.

2. Change the length of the CITY column in the Employee table to 50 characters.

3. Change the department name in the Department table to Administration for the department name entitled Admin and Records.

4. Add a department in the Department table. You choose the data for the new department.

5. Delete the new department you added in #4.

6. Add foreign key constraints to Assignment table.

7. Change the column name Date_of_Birth to DOB in Dependent table.

8. Create a new table structure named dept_Locations with dept_no and location fields. You also have to put primary and foreign key constraints so that this table is connected to department table.

MSU Cergeration Databne St. Louis MO 63121 0000 542 M 999444444 99222222AminHyder Saside MarinaCA 9941 999555555 999444444 M |71900666666 03-29 2000422M Collinsville IL 66234 015 3800 332M 1975 43000 99444444 hu huWaiman Lindber SL Louis MO 63121 43000 3 62025 14 MontereyCA 93940 IL 6202s 5000 25000 402 25000 26F 999887777 Markis Marcia 1999555555 999888888 Prescl Shem 999444444 Project Pro Number Pro Name Location St. Louis Marina Collinsville 7 Edwardsville 1 Dept No Order Personnel Receivables Edwardsville7 Pay Benefits Marina 30 EMP SSN Dep Name Gender Date of Birth Relationship 9991111 Deanna 991 Jeff 1978-12-3 DAUGHTER 1978-01-01 SON 1957-05-05 SPOUSE 1998-10-25 SON 1996-04-05 DAUGHTER 1975-05-03 SPOUSE 1968-02-29 SPOUSE Ellen F 999444444 Jo Ellen 999555555 Allen