SQLize Online / PHPize Online  /  SQLtest Online

Create table Artist ( ArtistID int, FName varchar (32), LName varchar(32), Primary key (ArtistID) ); Create table song ( SongID int, ArtistID int, Title varchar(45), Duration DOUBLE (1,2) ); Alter table song ADD (constraint PK_Song Primary key SongID) ADD (constraint FK_ArtistPK Foreign key (ArtistID) References Artist (artistID) ); Create table Playlist (PlaylistID int, SongID int Name varchar(40) ); Alter table Playlist ADD (constraint PK_playlist Primary key playlistID) ADD (constraint FK_SongPK Foreign key (SongID) References Song (SongID) ); Create table Album ( AlbumID int, SongID int, Name varchar (40) Year Released year (4), Genre varchar (30) ); Alter table album ADD(constraint PK_Album Primary key AlbumID) ADD (Constraint FK_SongFK Foreign key (SongID) References Song (SongID) ); Create table artist_song ( ArtistID int SongID int ); Alter table album ADD(constraint PK_artistsong Primary key ArtistID) ADD (Constraint FK_SongFK Foreign key (SongID) References Song (SongID) );