I try to figure out Partial dependenceis but not sure, but i cant find the transitive one Try to figure it out. Orange one are Primary key.
Functional dependencies are determined from the subject matter. I'm inferring the FDs here from the names of the columns.
The key is Ord_NO and Prod_ID. I didn't include CUS_ID in the primary key, because it depends on Ord_NO.
Name depends on CUS_ID which depends on Ord_NO.
This is a transitive dependency.
The only non key column which depends on the whole key is Qty_Ord. All the rest are partial dependencies.
Edit: I revised my answer to make the Column Names agree with the ones in the sample data.
The sample data is so small as to be anecdotal. Deriving FDs from such a small sample is risky, at best. You run the risk of seeing as patterns what are in reality mere coincidences.
Based on the Column names and an intuitive notion of how orders work, here are the FDs.
Cus_ID --> Name Ord_NO --> Ord_Date Ord_NO --> Cus_ID Prod_ID --> Description Ord_NO, Prod_ID --> Qty_Ord
While these are consistent with the sample data, they are NOT derived from it. As I already said, that's risky with such a small sample.