Solution to Stream Problem

[sarthakforwet]

Right now we are inculcating Category type also to Stream attribute of Category_Stream relation but that makes it logically incorrect although there is not any problem in physical structure of the schema.
We need a solution such that either we replace that Stream attribute with Category_name (which in turn would make the physical structure distorted as for Cat-3 we would have to make new_fields regarding the two seperate streams mentioned under Cat-3). or we add Mixed value to Stream attribute for Cat-1 and Cat-2 so that all will contain Stream values (but this will include quite a bit confusion in data entry and we have to explicitly change its name at frontend).

• Come up with one type of field for Stream attr. under Category_stream .