Class Exercise: One-to-Many Table Administration 1. Write create table statements for the Department and Employee tables with attribute data types and lengths based upon the data provided: Name Type Width Constraint ---------- -------- ----- ----------- Department deptNo int 2 primary key dName char 10 location char 10 salary decimal 7 2 decimal places Employee empno int 4 primary key ename char 10 job varchar 9 manager int 4 hireDate date salary decimal 7 2 decimal places 2. Prepare dataload utility statements to import data into the Department and Employee tables. 3. Employees may be related to Department by their work assignment. To implement this relationship, alter Employee to include a deptNo column. Use the same data type and length as specified in Department. 4. Alter Employee to specify that deptNo is to be a foreign key that references deptNo in Department. 5. Update Employee to reflect the work assignments. Our web page has a link to the file "DeptAssignEmp.txt". This contains a list of department assignments. 6. To illustrate the relationship between Department and Employee, create a join view named Management that includes deptNo, dName, empNo, and eName for corresponding Department and Employee rows with job type 'MANAGER'. Query the Management view.