What is the best practice for storing individual song titles in a PHP database for an album listing website?

When storing individual song titles in a PHP database for an album listing website, it is best practice to create a separate table for the songs with a foreign key referencing the album they belong to. This allows for better organization, flexibility, and scalability when managing the data.

// Create a table for songs with a foreign key referencing the album
CREATE TABLE songs (
    id INT AUTO_INCREMENT PRIMARY KEY,
    title VARCHAR(255) NOT NULL,
    album_id INT,
    FOREIGN KEY (album_id) REFERENCES albums(id)
);