I have a simple ERD diagram as represented below for a supplier for inventory goods.
What would be the best way to turn this ERD into a Star Schema with one Fact Table and a few dimension tables?
To be specific, I'm having issues with the location table because both the customer and warehouse tables are sharing the same locationID.
Should I add locationID into the fact table and create a dimension table for location? But by doing so, wouldn't I need to add two types of locationIDs to the fact table, one for customer and one for warehouse since both might not necessarily have the same locationID.
Or should I add the attributes of the location table into the dimension tables of the customer and warehouse individually?