: Verify that the rental data is normalized (e.g., separate tables for Klienci (Customers), Obiekty (Properties/Items), and Wynajmy (Rentals)). Ensure there is no redundant storage of rental rates in the transaction table if they can be retrieved via a JOIN from the primary item table .
: Keywords should be in UPPERCASE (e.g., SELECT , FROM , WHERE ) to distinguish them from table and column names, which should follow a consistent snake_case or PascalCase naming convention. wynajem.sql
: Replace SELECT * with explicit column names. This reduces unnecessary data transfer and prevents issues if the table schema changes . : Verify that the rental data is normalized (e
: Use descriptive aliases for tables (e.g., FROM Wynajmy AS w ) instead of single letters to improve clarity in multi-table joins. 3. Performance & Optimization : Replace SELECT * with explicit column names