in your png is not clear how the three tables are linked.
So, you can structure your data model linking categories to products via categoryID, then products to orderDetails (where you would find the product ID) via productID and orderDetails to orders via OrderID.
But if you'll explain better the actual link in source tables we can be more helpful.
The scenario you shared is a case of Circular Reference. I would suggest you to read about this in Circular References
I dont see how shippers table is different from Categories table.
But to the data you gave I would suggest you to join Categories and Shippers table based on Order ID.
If you want Order Ids in two Different table to hold its uniqueness(to know which order ID is from which table) add one more column to the tables (which identify which Order ID it is). For suppose a column which holds CAT in Categories table. After this concatenate the two tables.
Finally load this table formed out of 'Categories and Shippers Table' and Orders table.
I want data modeling like STAR Schema using this data base.
In our data base product table field (ProductID(PID)) internally connect with orderID(OID) and table field Categories table fieldcategoryid + (ProductID(PID)) internally connect with orderID(OID). using composite key concept.will u know the procedure for this Plz slove it.