HWA1_P8_1.sql

/* -------------------------------------------------------------------------
   Yu Cheng
   ICS 321 Assignment 1
   September 18, 2008

   PART 8.1
   Create a script that will create the PROJECT_ROLE table as defined in the
   Metadata Dictionary documentation.
   ------------------------------------------------------------------------- */

USE DB9975
GO

CREATE TABLE PROJECT_ROLE
(
	Id          NCHAR   (5)  NOT NULL,
	Description NVARCHAR(50) NOT NULL

	CONSTRAINT PK_PROJECT_ROLE PRIMARY KEY (Id)
)
GO