Create the WP.accdb database with the following two tables: All the information from the book has been provided.
To perform the following projects, you will need a computer that has Microsoft Access installed. If you have no experience working with Microsoft Access, read Appendix A before you proceed. For this set of project questions, we will create a Microsoft Access database for Wedge wood Pacific (WP). Founded in 1987 in Seattle, Washington, the company manufactures and sells consumer drone aircraft. This is an innovative and rapidly developing market. In January 2016, the Federal Aviation Administration (FAA) said that 181,000 drones (out of the approximately 700,000 drones that may have been sold during the 2015 Christmas season) had been registered under the new FAA drone registration rules. WP currently produces three drone models: the Alpha III, the Bravo III, and the Delta IV. These products are created by WP's Research and Development group and produced at WP's production facilities. WP manufactures some of the parts used in the drones, but also purchases some parts from other suppliers. The company is located in two buildings. One building houses the Administration, Legal Finance, Accounting, Human Resources, and Sales and Marketing departments, and the second houses the Information Systems, Research and Development, and Production departments. The company database contains data about employees, departments, projects, assets (such as finished goods inventory, parts inventory, and computer equipment), and other aspects of company operations. In the following project questions, we will start by creating the WP.accdb database with the following two tables: DEPARTMENT (DepartmentName, BudgetCode, OfficeNumber, Department Phone) EMPLOYEE (Employee Number, FirstName, LastName, Department, Position, Supervisor, OfficePhone, EmailAddress) Where Department in EMPLOYEE must exist in Department Name 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 WPaccdb 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. NOTE: We will not create the recursive relationship and referential integrity constraint between Supervisor and EmployeeNumber in EMPLOYEE at this time. We will do this in the Chapter 2 Wedgewood Pacific Exercises after we have discussed queries on recursive relationships. 171 Figure 1-31 shows the data for the WP EMPLOYEE table. Using Datasheet view, enter the first three rows of the data shown in Figure 1.31 into your EMPLOYEE table. To perform the following projects, you will need a computer that has Microsoft Access installed. If you have no experience working with Microsoft Access, read Appendix A before you proceed. For this set of project questions, we will create a Microsoft Access database for Wedge wood Pacific (WP). Founded in 1987 in Seattle, Washington, the company manufactures and sells consumer drone aircraft. This is an innovative and rapidly developing market. In January 2016, the Federal Aviation Administration (FAA) said that 181,000 drones (out of the approximately 700,000 drones that may have been sold during the 2015 Christmas season) had been registered under the new FAA drone registration rules. WP currently produces three drone models: the Alpha III, the Bravo III, and the Delta IV. These products are created by WP's Research and Development group and produced at WP's production facilities. WP manufactures some of the parts used in the drones, but also purchases some parts from other suppliers. The company is located in two buildings. One building houses the Administration, Legal Finance, Accounting, Human Resources, and Sales and Marketing departments, and the second houses the Information Systems, Research and Development, and Production departments. The company database contains data about employees, departments, projects, assets (such as finished goods inventory, parts inventory, and computer equipment), and other aspects of company operations. In the following project questions, we will start by creating the WP.accdb database with the following two tables: DEPARTMENT (DepartmentName, BudgetCode, OfficeNumber, Department Phone) EMPLOYEE (Employee Number, FirstName, LastName, Department, Position, Supervisor, OfficePhone, EmailAddress) Where Department in EMPLOYEE must exist in Department Name 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 WPaccdb 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. NOTE: We will not create the recursive relationship and referential integrity constraint between Supervisor and EmployeeNumber in EMPLOYEE at this time. We will do this in the Chapter 2 Wedgewood Pacific Exercises after we have discussed queries on recursive relationships. 171 Figure 1-31 shows the data for the WP EMPLOYEE table. Using Datasheet view, enter the first three rows of the data shown in Figure 1.31 into your EMPLOYEE table
