What are some best practices for normalizing database tables in PHP?

Normalizing database tables in PHP involves organizing data in a database to minimize redundancy and dependency. This is achieved by breaking down large tables into smaller, more manageable tables and establishing relationships between them using foreign keys. This practice helps improve data integrity, reduce data duplication, and simplify database management.

// Example of normalizing database tables in PHP

// Create a users table
CREATE TABLE users (
    id INT PRIMARY KEY,
    username VARCHAR(50) NOT NULL,
    email VARCHAR(100) NOT NULL
);

// Create a posts table
CREATE TABLE posts (
    id INT PRIMARY KEY,
    user_id INT,
    title VARCHAR(100) NOT NULL,
    content TEXT,
    FOREIGN KEY (user_id) REFERENCES users(id)
);