Inability to Insert Order_Items with Product IDs Beyond 16 in Products Table

[shirinyamani]

In the current database schema, the Order_Items table has a FOREIGN KEY constraint referencing the Products table on the 'product_id' column. However, the Products table contains only 16 unique product IDs. This setup poses a potential issue during data insertion into the Order_Items table. If more than 16 entries are attempted in the Order_Items table with product IDs exceeding 16, it will trigger a foreign key constraint violation. This limitation could be addressed by ensuring that the Order_Items table does not reference product IDs beyond the existing range in the Products table, or by expanding the range of product IDs in the Products table to accommodate future entries in Order_Items