Question
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
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 tableStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started