USE Art;
CREATE TABLE ARTIST(
	ArtistID	int				NOT NULL IDENTITY (1,1),
	Name		char(25)		NOT NULL,
	Nationality	char(30)		NULL,
	Birthdate	numeric(4,0)	NULL,
	DeceasedDate	numeric(4,0)	NULL,

	CONSTRAINT ArtistPK PRIMARY KEY (ArtistID),
	CONSTRAINT ArtistAK1 UNIQUE (Name),
	CONSTRAINT NationalityValues CHECK 
		(Nationality IN ('Canadian', 'English', 'French', 'Germen',
						 'Mexican','Russian','Spanish','US')),
	CONSTRAINT BirthValuesCheck CHECK (Birthdate < DeceasedDate),
	CONSTRAINT ValidBirthYear CHECK (Birthdate LIKE '[1-2] [0-9] [0-9] [0-9]'),
	CONSTRAINT ValidDeathYear CHECK (DeceasedDate LIKE '[1-2] [0-9] [0-9] [0-9]')
);