spool music
set echo on
alter session set nls_date_format = 'DD-MON-YYYY HH24:MI:SS';

select sysdate from dual;

drop table song;
drop table tour;
drop table album;
drop table artist;
drop table band;

create table album
(
 band   varchar2(20),
 name   varchar2(40),
 year   number
);

create table song
(
 name   varchar2(40),
 album  varchar2(30),
 track  number
);

create table artist
(
 name           varchar2(20),
 band           varchar2(20),
 job            varchar2(10),
 birthdate      date
);

create table band
(
 name           varchar2(20),
 year           number
);