One Hierarchy in two dimensions

View previous topic View next topic Go down

One Hierarchy in two dimensions

Post  fabriciabarbosa on Wed Aug 20, 2014 11:16 am

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

fabriciabarbosa

Posts : 3
Join date : 2014-03-12
Age : 40
Location : Recife, Brazil

View user profile

Back to top Go down

Re: One Hierarchy in two dimensions

Post  ngalemmo on Wed Aug 20, 2014 9:53 pm

You could. What is a MER?
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: One Hierarchy in two dimensions

Post  fabriciabarbosa on Thu Aug 21, 2014 1:15 pm

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

fabriciabarbosa

Posts : 3
Join date : 2014-03-12
Age : 40
Location : Recife, Brazil

View user profile

Back to top Go down

Re: One Hierarchy in two dimensions

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum