Create data bases and table using My SQL, based on two text files.

artists.txt

2 Ames

3 Aserty

4 Baron

7 Blain

8 Blum

9 Budd

12 Chico

14 Cox

16 Curtis

17 Dawson

19 Dill

22 Fratt

23 Garber

24 Garin

25 Giama

28 Guys

29 Hamend

32 Ibe

35 Irvin

38 Kritz

40 Long

43 Lutes

48 Metz

49 Miller

50 Mogan

52 Novarre

54 Ortega

55 Parker

56 Penn

59 Quiroz

60 Rath

=======

arts.txt

1042 Coffee on the Trail 2 7544

1013 Superstitions 3 78000

1021 Bead Wall 3 14000

1034 Beaver Pole Jumble 3 28000

1063 Asleep in the Garden 3 110000

1070 Beginnings 4 27500

1049 Buttercup with Red Lip 7 400

1018 Mountain Scene 8 2500

1055 Starlit Evening 9 9500

1003 Spring Flowers 12 2400

1039 Treachery 14 20000

1102 Crying Hats 14 10000

1052 American Rodeo 16 3500

1059 Dwelling 17 16000

1011 Eve 19 975

1109 Friends 22 16000

1084 Crossing the Platt River 23 2200

1072 Funnel 24 4500

1115 Starry Night 25 8500

1009 Amen 28 3000

1030 Ash Bench 28 13000

1043 Creosote Bushes 28 18000

1078 Chuckwagon 28 32000

1041 Night Version 29 3800

1082 Spring Flowers 29 20000

1006 House Remembered 32 700

1107 Striking It Rich 35 1750

1045 Leaf Patterns 38 2100

1100 Hungry Cowboys 38 750

1106 Horse Corral 40 12500

1044 Mexican Fiesta 43 14000

1024 Spirit and Nature 48 592

1067 Owl in Flight 49 7000

1001 Red Rock Mountain 50 18000

1028 Tired Cowboy 50 4700

1054 Snake Charmer 50 4500

1068 Moonlight 50 9750

1069 Renaissance 50 5500

1113 Shadow House 50 5500

1114 Storytelling at the Campfire 50 18000

1002 Offerings 52 10000

1091 Stone Palette 54 11500

1074 Storm on the Rise 55 8000

1098 Sweet Project 56 592

1080 The Dust Behind 59 18000

1058 The Gathering 60 250

All of this is just one part, so it's one question with steps on how.

O You will need to use Snipping Tools to record the required steps to a file called yourName.docx." Also, check the last step before you start, you should do it concurrently with the whole process. Submit that sql file as well Consider the first two records of the following two files O a. "artists.txt" 2 Ames 3 Aserty The first field is "artistID" and the second one is "artistName" b. "arts.txt 1042 Coffee on the Trail 1013 Superstitions 3 The names of the fields for each record are: "artID", "artName", "artistID", and "artValue" 7544 78000 O Do and record the following operations: (Just record the successful operations in the order specified.) 1) Build a database called "myarts" 2) Construct two tables: one is called "artists" and the other is called "arts". i. The names of the fields should be the same as specified above ii. You will choose the appropriate data type for each field iii Since "arts" table will rely on "artists" table for the artist name, so make sure that to limit the deletion of artist entry only when that particular "artistID" no longer exists in the "arts" table 3) 4) 5) Display what tables are there in the database "myarts" and display the field information of each table Populate two tables using the sample records given above and see if there are any records in these two tables. Display all records from "arts" table, display the art Value of art ID number 1013 and display the total value of arts. (i.e., the entire "artValue" column.), the average value of arts. (i.e., the entire "artValue" column.), and artName for the art piece that has the maximum value Display all records from "arts" but have Artist Name display after Artist ID. For example, you correct output will print something similar to the following: 6) artID artName 1042 Coffee on the Trail 1013 Superstitions artistIDartistName artValue 7544 78000 2 Ames 3 Aserty 7) Add 10% to the current value of all Art Values and add 5 more spaces to the "art Name" so that it can hold a longer name Display "artistID", "artistName", and "artName" for the art piece that has the maximum value Delete the record of artID of 1013 and try to delete Art ID 2 from "artists" table (Noe: "arts" table still has the entry with Artist ID 2. Delete all records from both tables, both tables from the database, and the database 8) 9) 10) Write a SQL file called "buildmyarts.sql" and use it to build the database 'myarts', construct the two tables mentioned previously, and populate the tables with the two sample records for each table