Introduction to Structured Query Language - Database Processing: Fundamentals, Design, and Implementation - page 98

The company database contains data about company employees, departments,
company projects, company assets such as computer equipment, and other aspects
of company operations.
In the following project questions, we have already created the WPC.accdb
database with the following two tables (see Chapter 1 Project Questions):

DEPARTMENT ( DepartmentName , BudgetCode, OfficeNumber, Phone)
EMPLOYEE ( EmployeeNumber , FirstName, LastName, Department , Phone, Email)

Now we will add in the following two tables:

PROJECT ( ProjectID , Name, Department , MaxHours, StartDate, EndDate)
ASSIGNMENT ( ProjectID , EmployeeNumber , HoursWorked)

The four tables in the revised WPC database schema are shown in Figure 2-29.
The column characteristics for the PROJeCT table are shown in Figure 2-30, and the
column characteristics for the aSSIGNMeNT table are shown in Figure 2-32. Data for
the PROJeCT table are shown in Figure 2-31, and the data for the aSSIGNMeNT table
are shown in Figure 2-33.

Figure 2-29
The WPC Database
with the PROJECT and
ASSIGNMENT Tables

2.56 Figure 2-30 shows the column characteristics for the WPC PROJECT table. Using the
column characteristics, create the PROJECT table in the WPC.accdb database.

The PROJECT
table

The ASSIGNMENT
table

Figure 2-30
Column Characteristics
for the WPC Database
PROJECT Table

PROJECT

Column Name Type Key Required Remarks

ProjectID Number Primary Key Yes Long Integer

Name Text (50) No Yes

Department Text (35) Foreign Key Yes

MaxHours Number No Yes Double

StartDate Date No No

EndDate Date No No