In the following project questions, we will start by creating the WP.accdb database with the following two tables: DEPARTMENT (DepartmentName, BudgetCode, OfficeNumber, DepartmentPhone) EMPLOYEE (EmployeeNumber, FirstName, LastName, Department, Position, Supervisor, OfficePhone, EmailAddress) Where Department in EMPLOYEE must exist in DepartmentName in DEPARTMENT Supervisor in EMPLOYEE must exist in EmployeeNumber in EMPLOYEE Note the second referential integrity constraint shows two columns in the EMPLOYEE table. This indicates that this is a recursive relationship. Recursive relationships are discussed in Chapters 2, 5 and 6. 1.66 Create a Microsoft Access database named WP.accdb. 1.67 Figure 1-28 shows the column characteristics for the WP DEPARTMENT table. Using the column characteristics, create the DEPARTMENT table in the WP.accdb database. 1.68 Figure 1-29 shows the data for the WP DEPARTMENT table. Using Datasheet view, enter the data shown in Figure 1-29 into your DEPARTMENT table. 1.69 Figure 1-30 shows the column characteristics for the WP EMPLOYEE table. Using the column characteristics, create the EMPLOYEE table in the WP.accdb database. 1.70 Create the relationship and referential integrity constraint between DEPARTMENT and EMPLOYEE. Enable enforcing of referential integrity and cascading of data updates, but do not enable cascading of data from deleted records.