allotting Single Row for the Single Brand , which should include Quantity,pid and brand name in such a way that it can be matched with "products" table
As you can see, this is what my OrderItems table is for. *BUT* you should *NEVER* put both pid and brand name into the OrderItems table. *ONLY* use the pid, as only it is guaranteed unique.
This is all part of the basic process of NORMALIZATION.