e1artists.txt 2 Ames 3 Aserty 4 Baron 7 Blain 8 Blum 9 Budd 12 Chico 14 Cox 16 C

Question

e1artists.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 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 -------------------- e1arts.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 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 Exam 2 (Date: 03/06/2018) The purpose of this exam is to test your understanding of the following concepts: 1. Use of MySQL 2. Create a database. 3. Create Tables. 4. Populate tables. 5. Data manipulation using MySQL SQL language. . Note 1. This exam only tests your ability to use MySQL However, since the entire question set depends on your successful construction of database and tables, so failure of these basic operations will imply your incapability of taking this exam and render you a 0 grade for the exam. The next exam will be based upon the basic database operations tested in this exam, so the better grade of the next exam will replace this one. Therefore, do not be disheartened if you do it poorly this time. Nevertheless, the next exam will be more involved than this one, so do not take this exam lightly because you may not do it better next time As usual, no make-up exam without valid documents. 2 3. How the exam is graded: 1. 2. We start with the full 50 points. After your database and tables are constructed, 5 points will be taken off for failure of completing an operation, and 2 points will be taken off for every answer that does not conform to the specification. Specifications: You will need to use Snipping Tools to record the required steps to a file called "exam2 yourName.docx" under "exam2" sub-folder under "wwwlcsc264". Also, check the last step before you start, you should do it concurrently with the whole process. Consider the first two records of the following two files a. "e01artists.txt 2 Ames 3 Aserty The first field is "artistID and the second one is "artistName

Explanation / Answer

mysql -u username -p
Type the user's password, and then press Enter.

1)CREATE DATABASE myarts;

2)CREATE TABLE arts( artID number(5),
artName varchar(20),artistID number(5),artistName varchar(50),artValue number(10));

CREATE TABLE artists(artistID number(5),artistName varchar(50) );

3)show tables;

4)desc arts;
desc artists;

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.