One Hierarchy in two dimensions

Hi, Everyone

I have a question that is a problem for me.

I have to design a logical multidimensional model and MER for database too.

In the business model we have supplies and customers that shared the location hierarchy.

Customer
Name
Age
City of customer
state of customer
country of customer

Supplier
Name
Age
City of Supplier
state of Supplier
country of Supplier


Question: Can I create a location hierarchy and reuse it? If yes, how I design this in the MER?

Thanks in Advance!
Fabricia Barbosa

You could. What is a MER?

Hi, ngalemmo

thanks for the attencion.

Sorry about the MER, it means Entity Relationship Diagram (ERD) in portuguese.

My question is about how use the same hierarchy in the ERD. How to organize the tables. If I can reuse a hirarchy, I can use star model to this design?


thanks in advance.
Fabricia Barbosa