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+---- -+-| CLAartists| couDescription| Classical | Orchestral music composed and performed by professionally trainedCountry Developed mostly in southern USA, with roots in traditional folk music,spirituals and blues || DRO | Droneclusters| GRU | Grunge|| PRC | Pop Rock| RAB | R&B| TEC | Techno| Minimalist music that emphasizes sustained or repeated sounds, notes, or toneAlternative rock inspired by hardcore punk, heavy metal, and indie rock| Rock music with less attitudeModern version of soul and funk African-American pop music| Electronic music7 rows in set (0.00 sec)mysql> desc genre;+-Field+-| Code| Name| Туре| Null | Key | Default | Extra || char(3)| NOvarchar(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 TypeID| TitleArtist| Beatles| Code || PRC| Taylor Swift | NULLLady Antebellum | COU|Lil Nas X| NULLJanet Jackson | RAB| Pearl Jam| GRU| Null | Key | Default | Extra |--+-| int| NOvarchar(60) | YES| PRI | NULL| NULL| NULL| Artist | varchar(60) | YES| Code|char(3)4 rows in set (0.01 sec)| YES | MUL | NULLmysql>

In music databases, good data organization is essential for maintaining large song and genre…

Answered: Please view attachment before…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

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

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

Step by step

Solved in 4 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

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.

Similar questions