USE Art;
CREATE TABLE WORK (
	WorkID		int				NOT NULL IDENTITY (500, 1),
	Title		char(25)		NOT NULL,
	Copy		char(8)			NOT NULL,
	Description	varchar(1000)	NOT NULL,
	ArtistID	int				NOT NULL,

	CONSTRAINT	WorkPK PRIMARY KEY (WorkID),
	CONSTRAINT	WorkAK1 UNIQUE (Title, Copy),
	CONSTRAINT	ArtistFK FOREIGN KEY (ArtistID) REFERENCES ARTIST(ArtistID)
		ON DELETE NO ACTION
		ON UPDATE NO ACTION
);