Help on data modeling

[admin_xlsior]

Hi guys,

Need a little help on data modeling. If we have one table that act as a filter to all the rest of tables, what would be the relationship look like ?

Something like these tables :

As you can see, the top table is Company table, is actually act as filter table that separated all data in all other tables with its "companyid" key. I would also want to know how other table interconnected each other.

I think for some background story, those typical tables are usual case for Sales management whereby there is Customer master, Vendor master, and Product master then we have SalesTable as well. For Customer and Vendor we also have its own Group table. 

Thanks,

[daxer-almighty]

The first question to ask is this: Which entities does Company really relate to? Is it the Company the customer belongs to? Or is it the Company that the product belongs to? Or is it the Company that the vendor has some relationship with? Without this business knowledge, it's not possible to tell you how to link these tables.

[admin_xlsior]

Hi both,

Thank you, I think I have clearer picture on the relation supposed to. By the diagram @Fowmy , so its mean we only need to relate company to the tables that has the most prioritized like Customer group/Item group because the rest will then following what already filter within those Customer group / Item group. 

@daxer-almighty  this Companyid in this case is the Company that operates this system, since this system support mulitple companies. 

Thanks,

[Fowmy]

@admin_xlsior 

Not sure how this company is related to both sales and purchases, could be a business unit concept. Check this sketch please:

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn