Database – Functional database with test data. This should be in the form of a s

Database – Functional database with test data. This should be in the form of a script that constructs the database, all of the tables, and populates the tables with all of the data. The database should track Artist information, including the styles of art they produce, the art in the gallery including Artist, Year of making, Unique title, Style of art, price, consignment amount, and acquired date. A sales table for the art including commission amount, and a table for art shows including date, styles of art and the pieces that are/were on display. Analysis Questions Who is the most popular artist? What is the most popular style of art? What shows have resulted in the most sales? What customers have purchased the most art? What artists has generated the most and least assignment amounts? What artists showed at which shows?