I think you have to use the information in the SQL to create a web page. The web page must have a table with all the artists name and info on with a details button, which leads to a picture of the artist and their biography. There should be another button on that same page that leads to their artwork. Ive posted both SQL that have been provided for us.

SQL FOR ARTWORKS

CREATE TABLE `artworks` ( `artworkid` int(11) NOT NULL, `category` varchar(50) DEFAULT NULL, `title` varchar(70) DEFAULT NULL, `description` longtext, `medium` varchar(50) DEFAULT NULL, `image` varchar(256) DEFAULT NULL, `notes` longtext, `valuation` double DEFAULT NULL, `artistid` int(11) DEFAULT NULL ) ;

INSERT INTO `artworks` (`artworkid`, `category`, `title`, `description`, `medium`, `image`, `notes`, `valuation`, `artistid`) VALUES (5001, NULL, 'Vida la Vida, Watermelons, 1954', NULL, NULL, 'vida_la_vida_watermelons.jpg', NULL, NULL, 1003), (5002, NULL, 'The Two Fridas, 1939', NULL, NULL, 'the-two-fridas-1939.jpg', NULL, NULL, 1003), (5003, NULL, 'Rams Head', NULL, NULL, 'okeeffe_rams_head.jpg', NULL, NULL, 1005), (5004, NULL, 'Red Canna', NULL, NULL, 'okeeffe_red_canna.jpg', NULL, NULL, 1005), (5005, NULL, 'Lake George Reflection', NULL, NULL, 'lake-george-reflection-georgia-okeeffe.jpg', NULL, NULL, 1005), (5006, NULL, 'Frieze', NULL, NULL, 'frankenthaler_frieze.jpg', NULL, NULL, 3001), (5007, NULL, 'The Red Sea', NULL, NULL, 'the_red_sea_frankenthaler.jpg', NULL, NULL, 3001), (5008, NULL, 'Breakfast in Bed', NULL, NULL, 'cassatt_15102817.jpg', NULL, NULL, 4001), (5009, NULL, 'Portrait of the Artist', NULL, NULL, 'mary-cassatt.jpg', NULL, NULL, 4001), (5010, NULL, 'Judith and her Maidservant, 1625', NULL, NULL, 'judith-and-her-maidservant.jpg', NULL, NULL, 1010), (5011, NULL, 'David and Bathsheba, c. 16361637', NULL, NULL, 'bathsheba.jpg', NULL, NULL, 1010);

SQL FOR ARTISTS

CREATE TABLE `artists` (

`artistid` int(11) NOT NULL,

`surname` varchar(256) DEFAULT NULL,

`first_name` varchar(256) DEFAULT NULL,

`gender` varchar(1) DEFAULT NULL,

`birthyear` smallint(6) DEFAULT NULL,

`nationality` varchar(50) DEFAULT NULL,

`emailaddress` varchar(75) DEFAULT NULL,

`websiteaddress` varchar(256) DEFAULT NULL,

`biography` longtext,

`photograph` longtext

);

INSERT INTO `artists` (`artistid`, `surname`, `first_name`, `gender`, `birthyear`, `nationality`, `emailaddress`, `websiteaddress`, `biography`, `photograph`) VALUES

(1003, 'Kahlo', 'Frida', 'F', 1954, 'Mexican', NULL, NULL, 'Magdalena Carmen Frida Kahlo y Caldern (6 July 1907 13 July 1954) was a Mexican painter known for her many portraits, self-portraits, and works inspired by the nature and artifacts of Mexico. Inspired by the countrys popular culture, she employed a nave folk art style to explore questions of identity, postcolonialism, gender, class, and race in Mexican society. Her paintings often had strong autobiographical elements and mixed realism with fantasy. In addition to belonging to the post-revolutionary Mexicayotl movement, which sought to define a Mexican identity, Kahlo has been described as a surrealist or magical realist.', 'f_kahlo.jpg'),

(1005, 'O\'Keeffe', 'Georgia', 'F', 1887, 'American', NULL, NULL, 'Georgia Totto O\'Keeffe (November 15, 1887 March 6, 1986) was an American artist. She was known for her paintings of enlarged flowers, New York skyscrapers, and New Mexico landscapes. O\'Keeffe has been recognized as the \"Mother of American modernism\"', 'g_okeeffe.jpg'),

(1010, 'Gentileschi', 'Artemisia', 'F', 1593, 'Italian', NULL, NULL, 'Artemisia Lomi or Artemisia Gentileschi (July 8, 1593 c.1656) was an Italian Baroque painter, now considered one of the most accomplished seventeenth-century artists working in the dramatic style of Caravaggio. In an era when women had few opportunities to pursue artistic training or work as professional artists, Artemisia was the first woman to become a member of the Accademia di Arte del Disegno in Florence and had an international clientele. Artemisia specialized in scenes of female heroines and stories centered on women from myths, allegories, and the Bible, including victims, suicides, and warriors. Some of her best known subjects are Susanna and the Elders (particularly the 1610 version in Pommersfelden) and Judith Slaying Holofernes (her 16141620 version is in the Uffizi gallery) and Judith and Her Maidservant (her version of 1625 at the Detroit Institute of Arts). Artemisia was known for being able to depict the female figure with great naturalism, and her skill in handling color to express dimension and drama.', 'a_gentileschi.jpg'),

(3001, 'Frankenthaler', 'Helen', 'F', 1928, 'American', NULL, NULL, 'Helen Frankenthaler (December 12, 1928 December 27, 2011) was an American abstract expressionist painter. She was a major contributor to the history of postwar American painting. Having exhibited her work for over six decades (early 1950s until 2011), she spanned several generations of abstract painters while continuing to produce vital and ever-changing new work. Frankenthaler began exhibiting her large-scale abstract expressionist paintings in contemporary museums and galleries in the early 1950s. She was included in the 1964 Post-Painterly Abstraction exhibition curated by Clement Greenberg that introduced a newer generation of abstract painting that came to be known as Color Field. Born in Manhattan, she was influenced by Greenberg, Hans Hofmann, and Jackson Pollock\'s paintings. Her work has been the subject of several retrospective exhibitions, including a 1989 retrospective at the Museum of Modern Art in New York City, and been exhibited worldwide since the 1950s. In 2001, she was awarded the National Medal of Arts.', 'h_frankenthaler.jpg'),

(4001, 'Cassatt', 'Mary', 'F', 1844, 'American', NULL, NULL, 'Mary Stevenson Cassatt (May 22, 1844 June 14, 1926) was an American painter and printmaker. She was born in Allegheny City, Pennsylvania (now part of Pittsburgh\'s North Side), but lived much of her adult life in France, where she first befriended Edgar Degas and later exhibited among the Impressionists. Cassatt often created images of the social and private lives of women, with particular emphasis on the intimate bonds between mothers and children. She was described by Gustave Geffroy in 1894 as one of \"les trois grandes dames\" (the three great ladies) of Impressionism alongside Marie Bracquemond and Berthe Morisot. In 1879, Diego Martelli, compared her to Degas, as they both sought to depict movement, light, and design in the most modern sense.', 'm_cassatt.jpg');

- In this assignment, you will create a web application to display information on artists. - You will find the SQL needed to create the artists and artworks tables and populate them, along with some necessary pictures, in the .zip file attached to this assignment. - You will use your own database, which you have already. - You may choose whether to put your SQL queries in a DAO class, JSP or servlet. Oour application will retrieve information from the artists table and display it in a JSP like so: (i) localhost38960/Artists/getAritists Summary of Artists Information Clicking on the "Details" button will bring you to a JSP page where you will display the information bout the artist, like so: Frida Kahlo Biography Magdalena Carmen Frida kahlo y Caldern (6 July 190713 July 1954) was a Mexican painter known for her many portraits, self-portraits, and works inspired by the nature and artifacts of Mexico. Inspired by the countrys popular culture, she employed a naive folk arm style to explore questions of identity, postcolonialism, gender, class, and race in Mexican fantasy. In addition to belonging to the post-revolutionary Mexicayotl movement, which sought to define a Mexican identity, Kahlo has been described as a surrealist or magical realist. Clicking on the "Artworks" button will bring you to a JSP page where you will display the artists works, like this: Clicking on the "Artworks" button will bring you to a JSP page where you will display the artists works, like this: Artworks By: Frida Kahlo Vida la Vida, Watermelons, 1954 The Two Fridas, 1939