Stefano Bragaglia wrote:
> Good morning Jerry and thank you for your reply!
>
> I'm obviously doing something wrong, but I cannot find out where the error
> is!
>
> Can you please suggest me where to look for it? Or where my reasoning is
> leaking something?
>
> I can provide the description of the problem in natural language, the E/R
> diagram and the relational diagram if it can help...
>
> Thank you in advance,
> Stefano Bragaglia
>
>

You have a basic problem in your logic.

You are saying the "name" has the option "surname", which is linked to
"person". That's OK.

You're also saying that "name" has the option "nickname", which is
linked to "person". That in itself is OK.

But your problem is that, the way you have it, "surname" and "nickname"
could be from two different persons. And I don't think you want the
surname from "John Doe" and the nickname from "Chi Chi Cordova".

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================