What are the advantages of normalizing a database table in PHP when storing links and titles separately?

When storing links and titles separately in a database table, it is beneficial to normalize the data to avoid redundancy and improve data consistency. By creating separate tables for links and titles and establishing a relationship between them using foreign keys, you can ensure that each link is associated with the correct title without duplication.

// Create a table for storing titles
CREATE TABLE titles (
    id INT PRIMARY KEY,
    title VARCHAR(255)
);

// Create a table for storing links with a foreign key reference to titles
CREATE TABLE links (
    id INT PRIMARY KEY,
    link VARCHAR(255),
    title_id INT,
    FOREIGN KEY (title_id) REFERENCES titles(id)
);