Re: Modelling specialized M:N relationships?

2004-04-21 Thread Leandro Melo
I'm actually i deep doubts with this. Price is not a thing itself, good point. But in my case, it was the best way i found out to model. Suppose you got a company the rents a place (just a big room, or a party house) for any kinda envents you'd to make. The company is clear an entity, and the

Modelling specialized M:N relationships?

2004-04-20 Thread Leandro Melo
Hi, i have a M:N relationship between PRODUCT and PRICE. 1 product may be associated to N prices and 1 prices may belong to N products. I got special cases the some kinda product MUST have only 1 price associated with it. I don't what would be the best way to model this flag for the special case.

Re: Modelling specialized M:N relationships?

2004-04-20 Thread Robert J Taylor
Leandro Melo wrote: Hi, i have a M:N relationship between PRODUCT and PRICE. Is Price an Entity or an Attribute? I'm not accustomed to using price as a Thing. What is it that causes a Product to have one, exactly, or more prices? Is it its relationship to some other thing? Or is it a special