What are the benefits of using a separate 'vermietung' table to track rental transactions compared to adding a 'kunden_id' column directly to the 'instrumente' table in PHP?

Using a separate 'vermietung' table to track rental transactions allows for better organization and normalization of data. It also prevents data duplication and makes it easier to query and analyze rental transactions separately from instrument data. Adding a 'kunden_id' column directly to the 'instrumente' table could lead to redundant data storage and potential inconsistencies.

// Create a separate 'vermietung' table to track rental transactions
CREATE TABLE vermietung (
    id INT PRIMARY KEY,
    instrument_id INT,
    kunden_id INT,
    start_date DATE,
    end_date DATE
);

// Example query to insert a rental transaction into the 'vermietung' table
INSERT INTO vermietung (instrument_id, kunden_id, start_date, end_date) VALUES (1, 123, '2022-01-01', '2022-01-07');