What are security considerations for foreign keys?

    // Example of creating tables with foreign keys in MySQL
    CREATE TABLE authors (
        id INT AUTO_INCREMENT PRIMARY KEY,
        name VARCHAR(100) NOT NULL
    );

    CREATE TABLE books (
        id INT AUTO_INCREMENT PRIMARY KEY,
        title VARCHAR(200) NOT NULL,
        author_id INT,
        FOREIGN KEY (author_id) REFERENCES authors(id)
            ON DELETE CASCADE
            ON UPDATE CASCADE
    );