Answered: CREATE TABLE ARTISTS( artist_id…

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

CREATE TABLE ARTISTS(

artist_id CHAR(30),

artist_name CHAR(30),

artist_pop INT(5),

PRIMARY KEY (artist_id));

CREATE TABLE TRACKS(

track_id CHAR(30),

track_name CHAR(30),

duration INTL(10),

tempo REAL,

PRIMARY KEY (track_id));

CREATE TABLE USERS(

user_id CHAR(30),

user_name CHAR(30),

age INT(5),

nationality CHAR(30),

num_track_listened INT(10),

PRIMARY KEY (user_id));

CREATE TABLE RECORD(

artist_id CHAR(30),

track_id CHAR(30),

PRIMARY KEY (artist_id, track_id),

FOREIGN KEY (artist_id) REFERENCES ARTISTS,

FOREIGN KEY (track_id) REFERENCES TRACKS);

CREATE TABLE LISTEN(

user_id CHAR(30),

track_id CHAR(30),

PRIMARY KEY (user_id, track_id),

FOREIGN KEY (user_id) REFERENCES USERS,

FOREIGN KEY (track_id) REFERENCES TRACKS);

CREATE TABLE FOLLOW(

user_id CHAR(30),

artist_id CHAR(30),

follow_date datetime,

PRIMARY KEY (user_id, artist_id)

FOREIGN KEY (user_id) REFERENCES USERS,

FOREIGN KEY (artist_id) REFERENCES ARTISTS);

According to the six table, write a single SQL query for each request below.

Find the ids of those artist who have recorded tracks together with the artist named ‘Drake’. Drake’s id is “3TVXtAsR1Inumwj472S9r4” that should be included in the result.

Expert Solution

Step by step

Solved in 2 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