Something

CREATE TABLE songs ( id int primary key,
    title varchar(50),
    artist varchar(50),
    album_id int,
    track_number int,
    length varchar(10),
    path varchar(100)
);

CREATE TABLE albums ( id int primary key,
    title varchar(50),
    composer varchar(50)
);