For database management. Use the data to design a relational database schema in 3NF. Show all steps. We are supposed to take the data given and show how they are related in 1NF, then 2NF, then 3NF is what I am assuming by the "show all steps". I reuploaded the picture to make the info more clear.

Questions #4: The Mad Art Gallery wishes to maintain data on their inventory and their customers, artists and paintings. They may have several paintings by each artist in the gallery at one time. Paintings may be bought and sold several times. In other words, the gallery may sell a painting, then buy it back at a later date and sell it to another customer. Use the following sample data to design a relational database schema in 3NF. Show all the steps. (Note: artist and paintings are real - data from https://www.saatchiart.com Gallery Customer History Form Phone (206) 284-6783 Jackson, Elizabeth 123-6th Avenue Austin, TX 78702 Purchases Made Artist 03 Luca Brandi 15-Rebecca Bradley 03-Luca Brandi 15-Robert Gendron 15- Rebecca Bradley Title The red field Curious The red field Le bosquet Curious Purchase Date 09/17/2016 05/11/2014 10/24/2017 10/24/2017 08/21/2017 Sales Price 5,000.00 800.00 6,750.00 1,000.00 1,350.00 Gallery Customer Inventory Form: Artist Inventory (sample) Artist Country Dimensions Title Asking Price Elena Ivanova Marlise Witschi Flavio Man UK Canada Argentina (inches) 19.7 x 23.56x 0.6 36 x 36 x 1.8 9.8 x 13.8 x 1.2 $725 1,960 $660 Pink sunrise Seeing light everywhere La danza de San Vito