SOQ#52960415, MySQL

Language: Layout:

#MySQL 5.7.12
#please drop objects you've created at the end of the script 
#or check for their existance before creating
#'\\' is a delimiter

drop table if exists song_artist; 
drop table if exists song;
drop table if exists artist;

commit;
    CREATE TABLE IF NOT EXISTS Song (
        song_id INT(10) NOT NULL,
        song_name VARCHAR(255) NOT NULL,
        lyrics TEXT,
        genre_id INT(10) NOT NULL default 0,
        year_released INT(10),
        
        PRIMARY KEY (song_id)
    );

CREATE TABLE IF NOT EXISTS Artist (
        artist_id VARCHAR(25) NOT NULL,
        artist_fname VARCHAR(10),
        artist_lname VARCHAR(10),
        PRIMARY KEY (artist_id)
    );

create table Song_Artist
    (
       song_id int(10) NOT NULL,
       artist_id varchar(25) NOT NULL,
       PRIMARY KEY PK_song_artist (song_ID, artist_id), 
       FOREIGN KEY FK_Song (song_id) REFERENCES Song(song_id) ON DELETE CASCADE ON UPDATE CASCADE,
       FOREIGN KEY FK_Artist (artist_id) REFERENCES Artist(artist_id) ON DELETE CASCADE ON UPDATE CASCADE
        );
     
    Insert into Song (song_id, Song_Name) values (1,'Test1');
    Insert into Song (song_id, Song_Name) values (2,'Test2');
    Insert into Song (song_id, Song_Name)values (3,'Test3');
    Insert into Song (song_id, Song_Name)values (4,'Test4');
    Insert into Song (song_id, Song_Name)values (5,'Test5');
    Insert into Song (song_id, Song_Name)values (6,'Test6');
    Insert into Song (song_id, Song_Name)values (7,'Test7');
    Insert into Artist (artist_id, Artist_fname, artist_lname) values ('1','TFname', 'TLname');
    Insert into Artist (artist_id, Artist_fname, artist_lname) values ('2','TFname', 'TLname');
    Insert into Artist (artist_id, Artist_fname, artist_lname) values ('3','TFname', 'TLname');
    Insert into Artist (artist_id, Artist_fname, artist_lname) values ('4','TFname', 'TLname');
    Insert into Artist (artist_id, Artist_fname, artist_lname) values ('5','TFname', 'TLname');
    Insert into Song_artist values (1,'1');
    Insert into Song_artist values (2,'1');
    Insert into Song_artist values (3,'2');
    Insert into Song_artist values (4,'2');
    Insert into Song_artist values (5,'3');
    Insert into Song_artist values (6,'4');
    Insert into Song_artist values (7,'5');
    
    
    Delete from Song where song_ID = 4;
    delete from artist where artist_ID = '5';
    
    
    Select * from song;
    select * from artist;
    select * from song_artist;
    
    Update Song set song_ID = 10 where song_ID = 1;
    update artist set artist_ID = '10' where artist_ID = '1';
    
    Select * from song;
    select * from artist;
    select * from song_artist;


absolute service time: 0,41 sec