how to design data model for data across multiple business domains
Hi expert,
I have a data modeling question that I want to analyze service parts purchase, service parts sales, and stock info. I have service parts catalog table, vendor table, and parts order table, parts sales order table and a bunch of other tables related to sales and purchase business.
my question is how to bring these tables together so that I can analyze parts business from purchase to service. thanks.
furthermore, should I join their tables or I need to keep sales, purchase and other data separately?