Please view attachment before answering. The attachment includes the tables and its contents. I am in need of assistance with both parts, A and B. I am unsure on how i can go about attempting the question. I am using mysql terminal. Please explain solution in detail so i can fully understand . Attaching a visual will be of great help as well. (as in a screenshot or so) Thank you so much in advance! Part A - Modify the SELECT statement to perform a right join. Run the SQL and verify the result table includes genres that are not associated with any songs. Part B - Combine the left and right joins into one statement that performs a full join. Run the SQL and verify the result table includes all songs and genres.
Please view attachment before answering. The attachment includes the tables and its contents. I am in need of assistance with both parts, A and B. I am unsure on how i can go about attempting the question. I am using mysql terminal. Please explain solution in detail so i can fully understand . Attaching a visual will be of great help as well. (as in a screenshot or so) Thank you so much in advance! Part A - Modify the SELECT statement to perform a right join. Run the SQL and verify the result table includes genres that are not associated with any songs. Part B - Combine the left and right joins into one statement that performs a full join. Run the SQL and verify the result table includes all songs and genres.
Chapter3: Data Representation
Section: Chapter Questions
Problem 2RP
Related questions
Question
100%
Please view attachment before answering. The attachment includes the tables and its contents. I am in need of assistance with both parts, A and B. I am unsure on how i can go about attempting the question. I am using mysql terminal. Please explain solution in detail so i can fully understand . Attaching a visual will be of great help as well. (as in a screenshot or so) Thank you so much in advance!
Part A - Modify the SELECT statement to perform a right join. Run the SQL and verify the result table includes genres that are not associated with any songs.
Part B - Combine the left and right joins into one statement that performs a full join. Run the SQL and verify the result table includes all songs and genres.
**** use keyword UNION, since MySQL does not support FULL JOIN
![mysql> select * from genre;
+------+-
| Code Name
+---- -+-
| CLA
artists
| cou
Description
| Classical | Orchestral music composed and performed by professionally trained
Country Developed mostly in southern USA, with roots in traditional folk music,
spirituals and blues |
| DRO | Drone
clusters
| GRU | Grunge
|
| PRC | Pop Rock
| RAB | R&B
| TEC | Techno
| Minimalist music that emphasizes sustained or repeated sounds, notes, or tone
Alternative rock inspired by hardcore punk, heavy metal, and indie rock
| Rock music with less attitude
Modern version of soul and funk African-American pop music
| Electronic music
7 rows in set (0.00 sec)
mysql> desc genre;
+-
Field
+-
| Code
| Name
| Туре
| Null | Key | Default | Extra |
| char(3)
| NO
varchar(20) | YES
| Description | varchar(200) | YES
--+-
3 rows in set (0.01 sec)
mysql>
| PRI | NULL
| NULL
| NULL](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F1825a1e7-7298-4f12-824d-239410fc4a99%2Fa1343826-5435-4ca2-bb28-3ab201e846a6%2Fsa60kk8_processed.png&w=3840&q=75)
Transcribed Image Text:mysql> select * from genre;
+------+-
| Code Name
+---- -+-
| CLA
artists
| cou
Description
| Classical | Orchestral music composed and performed by professionally trained
Country Developed mostly in southern USA, with roots in traditional folk music,
spirituals and blues |
| DRO | Drone
clusters
| GRU | Grunge
|
| PRC | Pop Rock
| RAB | R&B
| TEC | Techno
| Minimalist music that emphasizes sustained or repeated sounds, notes, or tone
Alternative rock inspired by hardcore punk, heavy metal, and indie rock
| Rock music with less attitude
Modern version of soul and funk African-American pop music
| Electronic music
7 rows in set (0.00 sec)
mysql> desc genre;
+-
Field
+-
| Code
| Name
| Туре
| Null | Key | Default | Extra |
| char(3)
| NO
varchar(20) | YES
| Description | varchar(200) | YES
--+-
3 rows in set (0.01 sec)
mysql>
| PRI | NULL
| NULL
| NULL
![mysql> select * from song;
+-----+-
| ID | Title
+
| 100 | Hey Jude
| 200 | You Belong With Me
| 300 | Need You Now
| 400 | Old Town Road
| 500 | That's The Way Love Goes |
| 600 | Even Flow
+-- --+--
6 rows in set (0.00 sec)
mysql> desc song;
+-
| Field Type
ID
| Title
Artist
| Beatles
| Code |
| PRC
| Taylor Swift | NULL
Lady Antebellum | COU
|
Lil Nas X
| NULL
Janet Jackson | RAB
| Pearl Jam
| GRU
| Null | Key | Default | Extra |
--+-
| int
| NO
varchar(60) | YES
| PRI | NULL
| NULL
| NULL
| Artist | varchar(60) | YES
| Code
|char(3)
4 rows in set (0.01 sec)
| YES | MUL | NULL
mysql>](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F1825a1e7-7298-4f12-824d-239410fc4a99%2Fa1343826-5435-4ca2-bb28-3ab201e846a6%2Fd1c9bqv_processed.png&w=3840&q=75)
Transcribed Image Text:mysql> select * from song;
+-----+-
| ID | Title
+
| 100 | Hey Jude
| 200 | You Belong With Me
| 300 | Need You Now
| 400 | Old Town Road
| 500 | That's The Way Love Goes |
| 600 | Even Flow
+-- --+--
6 rows in set (0.00 sec)
mysql> desc song;
+-
| Field Type
ID
| Title
Artist
| Beatles
| Code |
| PRC
| Taylor Swift | NULL
Lady Antebellum | COU
|
Lil Nas X
| NULL
Janet Jackson | RAB
| Pearl Jam
| GRU
| Null | Key | Default | Extra |
--+-
| int
| NO
varchar(60) | YES
| PRI | NULL
| NULL
| NULL
| Artist | varchar(60) | YES
| Code
|char(3)
4 rows in set (0.01 sec)
| YES | MUL | NULL
mysql>
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 4 steps with 2 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
![Systems Architecture](https://www.bartleby.com/isbn_cover_images/9781305080195/9781305080195_smallCoverImage.gif)
Systems Architecture
Computer Science
ISBN:
9781305080195
Author:
Stephen D. Burd
Publisher:
Cengage Learning
![Principles of Information Systems (MindTap Course…](https://www.bartleby.com/isbn_cover_images/9781305971776/9781305971776_smallCoverImage.gif)
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781305971776
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
![Systems Architecture](https://www.bartleby.com/isbn_cover_images/9781305080195/9781305080195_smallCoverImage.gif)
Systems Architecture
Computer Science
ISBN:
9781305080195
Author:
Stephen D. Burd
Publisher:
Cengage Learning
![Principles of Information Systems (MindTap Course…](https://www.bartleby.com/isbn_cover_images/9781305971776/9781305971776_smallCoverImage.gif)
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781305971776
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning