Forum Discussion
data model help needed
I have 3 tables, customer, customer_transaction_details, vendor customer - > customer_transaction_details --- 1 to many on customer_ID customer -> vendor -- 1 to many on c...
Anonymous
im confused .
shouldn't you have vendor id in the fact transaction table ?
thus your model should be :
vendor to transaction details --> 1 to many
customer to transaction details --> 1 to many .
vendor_id is not in the transcation_details table, because transcarion is at the customer level only.