HWA1_P7_1.sql

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

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

USE DB9975
GO

CREATE TABLE PROJECT
(
	Id             NCHAR   (6)   NOT NULL,
	Title          NVARCHAR(100) NOT NULL,
	EstimatedStart DATETIME          NULL,
	EstimatedEnd   DATETIME          NULL,
	ActualStart    DATETIME          NULL,
	ActualEnd      DATETIME          NULL

	CONSTRAINT PK_PROJECT PRIMARY KEY (Id)
)
GO