Create a database named VRG and set it as the default database. VRG is used for a small art gallery, the View Ridge Gallery, which sells contemporary European and North American fine arts. The database consists of three tables.

Create an ARTIST table that tracks the information about artists whose works are on sell by VRG;

Create a WORK table that tracks the information about each piece of art work ever owned by VRG;

Create a Customer table that tracks the information about every customer of VGR;

The detail of those table requirements are as follows.

ARTIST Table

ColumnName	Data Type	NULL Status
ArtistID	Int	NOT NULL
LastName	Char(25)	NOT NULL
FirstName	Char(25)	NOT NULL
Nationality	Char(50)	NULL
DateofBirth	Date	NULL
DateDeceased	Date	NULL

WORK Table

ColumnName	Data Type	NULL Status
WorkID	Int	NOT NULL
Title	Char(35)	NOT NULL
Copy	Char(12)	NOT NULL
Medium	Char(35)	NULL
Description	VarChar(1000)	NULL
ArtistID	Int	NOT NULL

CUSTOMER Table

ColumnName	Data Type	NULL Status
CustomerID	Int	NOT NULL
LastName	Char(25)	NOT NULL
FirstName	Char(25)	NOT NULL
Street	Char(30)	NULL
City	Char(30)	NULL
State	Char(2)	NULL
Zipcode	Char(9)
Country	Char(30)
PhoneNumber	Char(30)
Email	Char(30)