CREATE TABLE CUSTOMER(
	CustomerID		int				NOT NULL,
	Name			char(25)		NOT NULL,
	Street			char(30)		NULL,
	City			char(35)		NULL,
	State			char(2)			NULL,
	ZipPostalCode	char(5)			NULL,
	Country			varchar(50)		NULL,
	AreaCode		char(3)			NULL,
	PhoneNumber		char(8)			NULL,
	Email			varchar(100)	NULL);

	ALTER TABLE CUSTOMER
		ADD CONSTRAINT CustomerPK PRIMARY KEY (CustomerID);

CREATE TABLE ARTIST(
	ArtistID		int				NOT NULL,
	Name			char(25)		NOT NULL,
	Nationality		varchar(30)	 	NULL,
	BirthDate		numeric(4,0)	NULL,
	DeceasedDate	numeric(4,0)	NULL,
	CONSTRAINT	ArtistPK	PRIMARY KEY (ArtistID));