Re: Generalised approach to storing address details

> Just because they do this doesn't make it correct. A user's failings do
> not reflect on the system they are using. When you employ EAV to
> circumvent a schema, you are not using the RM as the logical model,
> full stop.

Please show a non-EAV solution that meets OP's requirements.

> RM's scope is unarguable. All information can be recorded as propositions,
> and all propositions can be represented in the relational model.

Any data model can theoretically record any proposition. But the ability to do it systematically varies. Please show how to record the proposition "john likes mary" such that db can answer 1) who likes mary 2) john likes who 3) john does what to mary. Received on Sun Dec 10 2006 - 22:27:31 CET