Now create the PROJECT and ASSIGNMENT tables as shown here. Note the Foreign Key relationships in these tables and set them up as explained above.

PROJECT

$\backslash$table$[[$Column Name,Type,Key,Required,Remarks$],[$ProjectiD$,$bigint,Primary Key,Yes,Long Integer$],[$Name$,$nvarchar$(50),$No$,$Yes,$],[$Department$,$nvarchar$(35),$Foroign Koy,Yes,$],[$MaxHours$,$float,No$,$Yos,Double$],[$StartDate$,$datetime,No$,$No$,],[$EndDate$,$datetime,No$,$No$,]]$

ASSIGNMENT

$\backslash$table$[[$Column Name,Type,Key,Required,Remarks$],[$ProjectiD$,$bigint,$\backslash$table$[[$Primary Key,$],[$Foreign Key$]],$Yes,Long Integer$],[$EmployeoNumber$,$bigint,$\backslash$table$[[$Primary Koy,$],[$Foreign Koy$]],$Yes,Long Integer$],[$HoursWorked$,$noat,No$,$No$,$Double$]]$

Populate the DEPARTMENT and EMPLOYEE tables with the same exact data provided here:

DEPARTMENT Data

$\backslash$table$[[$DepartmentName$,$BudgetCode,OfficeNumber,Phone$],[$Administration$,$BC$-100-10,$BLDG$01-300,360-285-8100$

Populate the PROJECT and ASSIGNMENT tables with the following data:

PRONECT Data

$\backslash$table$[[$ProjectiD$,$Name,Department,MaxHours,StartDate,EndDate$],[1000,2008$ Q$3$ Product Plan,Marketing,$135,\frac{05}{10}\frac{?}{08},\frac{06}{15}\frac{?}{08}$