/*----------------------------------------------------------------------*/
drop table artists;
create table artists (
   artist_name      varchar(20),
   age                  integer,
   birthplace         varchar(15),
   style                varchar(20)
);

insert into artists values ( 'Picasso' , 92, 'Spain' , 'Surrealism'
);
insert into artists values ( 'VanGogh' , 37, 'Netherlands', 'PostImpressionism'
);
insert into artists values ( 'Monet' , 86, 'France'  , 'Impressionism'
);
insert into artists values ( 'DaVinci' , 67, 'Italy'  , 'Renaissance'
);
insert into artists values ( 'Masaccio' , 27, 'Italy'  , 'Renaissance'
);
insert into artists values ( 'Delacroix' , 65, 'France'   , 'Romanticism'
);
insert into artists values ( 'Adams' , 82, 'America'   , 'Realsim'
);


/*----------------------------------------------------------------------*/
drop table customers;
create table customers (
   cust_name    varchar(20),
   address         varchar(30),
   amount          real
   );

insert into customers values ( 'David' , '3136 Main Street' ,
385.6);
insert into customers values ( 'Matt' , '1673 Lee Hwy'            ,
726.4);
insert into customers values ( 'Julie' , '135 Chain Bridge Road'        ,
632.8 );
insert into customers values ( 'Robert' , '216 Olley Lane'           ,
698.6);
insert into customers values ('Greg', '135 Chain Bridge Road', 567.3);


/*----------------------------------------------------------------------*/
drop table artwork_paints;
create table artwork_paints (
   title                varchar(40),
   artist_name    varchar(20),
   type               varchar(15),
   price              real,
   year    	          integer
);

insert into artwork_paints values ( 'Dora Maar au Chat' , 'Picasso' , 'Painting' , 40.7
, 1941);
insert into artwork_paints values ( 'Liberty Leading the People' , 'Delacroix'     , 'Painting'   , 26.8
, 1830);
insert into artwork_paints values ( 'Sunflowers',   'VanGogh'     , 'Painting'   , 39.7
, 1888);
insert into artwork_paints values ( 'Moonrise' , 'Adams'      , 'Photography' , 6.1
, 1948);
insert into artwork_paints values ( 'Mona Lisa' , 'DaVinci'   , 'Painting' , 670.0
, 1503);
insert into artwork_paints values ( 'Sunrise' , 'Monet'    , 'Painting'  , 78.9
, 1873);
insert into artwork_paints values ( 'Guernica' , 'Picasso'      , 'Painting' , 95.2
, 1937);
insert into artwork_paints values ( 'The Tribute Money' , 'Masaccio'     , 'Fresco' , 174.8
, 1386);
insert into artwork_paints values ( 'Au Lapin Agile' , 'Picasso' , 'Painting' , 40.7
, 1904);

                                            
/*----------------------------------------------------------------------*/
drop table like_artist;
create table like_artist (
   cust_name      varchar(20),
   artist_name     varchar(20)
); 

insert into like_artist values ( 'Julie' , 'Monet' );
insert into like_artist values ( 'Robert' , 'DaVinci' );
insert into like_artist values ( 'Matt' , 'Masaccio' );
insert into like_artist values ( 'Robert' , 'VanGogh' );
insert into like_artist values ( 'Greg' , 'DaVinci' );
insert into like_artist values ( 'David' , 'Picasso' );
insert into like_artist values ( 'Robert' , 'Picasso' );
insert into like_artist values ( 'Matt' , 'Delacroix' );
insert into like_artist values ( 'Greg' , 'Adams' );
insert into like_artist values ( 'David' , 'Masaccio' );
insert into like_artist values ( 'Robert' , 'Monet' );
insert into like_artist values ( 'Julie' , 'DaVinci' );


/*----------------------------------------------------------------------*/
drop table Art_group;
create table Art_group (
   group_name     varchar(20)
); 

insert into Art_group values ( '19th century art' );
insert into Art_group values ( 'Renaissance art' );
insert into Art_group values ( '20th century art' );


/*----------------------------------------------------------------------*/
drop table like_group;
create table like_group (
   cust_name      varchar(20),
   group_name    varchar(20)
); 

insert into like_group values ( 'Greg' , 'Renaissance art' );
insert into like_group values ( 'Matt' , '19th century art' );
insert into like_group values ( 'Matt' , 'Renaissance art' );
insert into like_group values ( 'David' , 'Renaissance art' );
insert into like_group values ( 'Julie' , '19th century art' );
insert into like_group values ( 'Greg' , '20th century art' );
insert into like_group values ( 'David' , '20th century art' );
insert into like_group values ( 'Robert' , '19th century art' );
insert into like_group values ( 'Robert' , 'Renaissance art' );
insert into like_group values ( 'Julie' , 'Renaissance art' );


/*----------------------------------------------------------------------*/
drop table classify;
create table classify (
   title                 varchar(40),
   group_name     varchar(20)
); 

insert into classify values ( 'Dora Maar au Chat' , '20th century art' );
insert into classify values ( 'Liberty Leading the People' , '19th century art' );
insert into classify values ( 'Sunflowers' , '19th century art' );
insert into classify values ( 'Moonrise' , '20th century art' );
insert into classify values ( 'Mona Lisa' , 'Renaissance art' );
insert into classify values ( 'Sunrise' , '19th century art' );
insert into classify values ( 'Guernica' , '20th century art' );
insert into classify values ( 'The Tribute Money' , 'Renaissance art' );
insert into classify values ( 'Au Lapin Agile' , '20th century art' );