Hello,

I am having issues getting my tables to work properly. If anyone would be able to write the steps out on how to do it (my book isnt very helpful in directions). Below are the directions for the first part of the lab.

Thanks.

The goal is develop a database for the Wedgewood Pacific Corporation using MS SQL Server . In MS SQL Server, create a new database called WPC. 2. Create the DEPARTMENT and EMPLOYEE tables shown below along with the PROJECT and ASSIGNMENT tables shown on the next page, and set the relationships between the tables explained below: DEPARTMENT Column Name Required Remarks Type nvarchar(35) Primary KeyYes nvarchar(30) No nvarchar(15) No nvarchar 12) No Key Yes Yes Yes OfficeNumber Phone EMPLOYEE Column Name Required Type bigint: Identity Primary KeyYes nvarchar(25) No nvarchar(25) No nvarchar(35) Foreign KeyYes nvarchar(12 No nvarchar(100) No Key Remarks Surrogate Key Yes Yes Phone No Emai