mysql> select * from song; +-----+ | ID | Title +-----+- 100 | Hey Jude --+ | Artist | GenreCode | Beatles | PRC 200 | You Belong With Me | Taylor Swift | NULL 300 Need You Now 400 Old Town Road | Lady Antebellum | COU | NULL Lil Nas X | Pearl Jam 500 | That's The Way Love Goes | Janet Jackson | RAB 600 | Even Flow +-----+-- 6 rows in set (0.00 sec) mysql> desc song; | GRU + | Field ID | Type | int | Null | Key | Default | Extra | -----+-----+- Title | NO varchar(60) | YES | PRI | NULL | | NULL Artist | varchar(60) | YES | | NULL | GenreCode | char(3) | YES | MUL | NULL +- 4 rows in set (0.00 sec) mysql> select * from genre; +------+-- | Code | Name +----- | CLA artists | Description | Classical | Orchestral music composed and performed by professionally trained | | COU❘ Country | Developed mostly in southern USA, with roots in traditional folk music, spirituals and blues | | DRO | Drone clusters GRU | Grunge Pop Rock R&B | PRC RAB | 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.01 sec) mysql> desc genre; | Field | Code Name | Type | Null | Key | Default | Extra | | NO | PRI | NULL |char(3) varchar(20) | YES | Description | varchar(200) | YES + 3 rows in set (0.01 sec) | NULL | NULL
mysql> select * from song; +-----+ | ID | Title +-----+- 100 | Hey Jude --+ | Artist | GenreCode | Beatles | PRC 200 | You Belong With Me | Taylor Swift | NULL 300 Need You Now 400 Old Town Road | Lady Antebellum | COU | NULL Lil Nas X | Pearl Jam 500 | That's The Way Love Goes | Janet Jackson | RAB 600 | Even Flow +-----+-- 6 rows in set (0.00 sec) mysql> desc song; | GRU + | Field ID | Type | int | Null | Key | Default | Extra | -----+-----+- Title | NO varchar(60) | YES | PRI | NULL | | NULL Artist | varchar(60) | YES | | NULL | GenreCode | char(3) | YES | MUL | NULL +- 4 rows in set (0.00 sec) mysql> select * from genre; +------+-- | Code | Name +----- | CLA artists | Description | Classical | Orchestral music composed and performed by professionally trained | | COU❘ Country | Developed mostly in southern USA, with roots in traditional folk music, spirituals and blues | | DRO | Drone clusters GRU | Grunge Pop Rock R&B | PRC RAB | 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.01 sec) mysql> desc genre; | Field | Code Name | Type | Null | Key | Default | Extra | | NO | PRI | NULL |char(3) varchar(20) | YES | Description | varchar(200) | YES + 3 rows in set (0.01 sec) | NULL | NULL
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
Related questions
Question
Transcribed Image Text:mysql> select * from song;
+-----+
| ID | Title
+-----+-
100 | Hey Jude
--+
| Artist
| GenreCode |
Beatles
| PRC
200 | You Belong With Me
| Taylor Swift
| NULL
300 Need You Now
400 Old Town Road
| Lady Antebellum | COU
| NULL
Lil Nas X
| Pearl Jam
500 | That's The Way Love Goes | Janet Jackson | RAB
600 | Even Flow
+-----+--
6 rows in set (0.00 sec)
mysql> desc song;
| GRU
+
| Field
ID
| Type
| int
| Null | Key | Default | Extra |
-----+-----+-
Title
| NO
varchar(60) | YES
| PRI | NULL
|
| NULL
Artist
| varchar(60) | YES
|
| NULL
| GenreCode | char(3)
| YES
| MUL | NULL
+-
4 rows in set (0.00 sec)
mysql> select * from genre;
+------+--
| Code | Name
+-----
| CLA
artists
| Description
| Classical | Orchestral music composed and performed by professionally trained
|
| COU❘ Country | Developed mostly in southern USA, with roots in traditional folk music,
spirituals and blues |
| DRO | Drone
clusters
GRU | Grunge
Pop Rock
R&B
| PRC
RAB
| 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.01 sec)
mysql> desc genre;
| Field
| Code
Name
| Type
| Null | Key | Default | Extra |
| NO | PRI | NULL
|char(3)
varchar(20) | YES
| Description | varchar(200) | YES
+
3 rows in set (0.01 sec)
| NULL
| NULL
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 1 steps
Recommended textbooks for you
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education