HWA1_P2_1.sql

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

   PART 2.1
   The PERSON table will satisfy this requirement. Create the PERSON table
   as as shown in figure 1.1. and defined in the Metadata Dictionary
   documents.
   ------------------------------------------------------------------------- */

USE DB9975
GO

CREATE TABLE PERSON
(
	Id               INT          NOT NULL,
	FirstName        NVARCHAR(20) NOT NULL,
	LastName         NVARCHAR(20) NOT NULL,
	MiddleName       NCHAR   (1)      NULL,
	DateOfBirth      DATETIME     NOT NULL,
	EmploymentStatus NCHAR   (1)  NOT NULL

	CONSTRAINT PK_PERSON PRIMARY KEY (Id)
)
GO