Why (in the screenshot) is the Products table subdivided into several?

Question

SQL Server

Watching a video from ITVDN on MSSQL... https://itvdn.com/ru/video/sql-workshop
I don't understand why Products was divided into Stocks and ProductDetails. The "Qty" field in Stocks is "quantity".
After all, you can put all the information from these adjacent tables into one table - Products.

Answer 1

Perhaps it means that in the future - there will be warehouses and something like product_id, stock_id, qnt - that is, the number of positions in different warehouses.

Answer 2

With ProductDetail, the same is more or less clear: you can have iPhones: red, green, ...
With Stocks, it’s not clear why it is in this form. Perhaps something further in the video is explained.
Because this is a training material, then make allowance for the fact that this is a greatly simplified model, it is unlikely that it can be used in this form.