• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
One-to-one relationship
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

One-to-one relationship


  • Subject: One-to-one relationship
  • From: Francesco Romano <email@hidden>
  • Date: Sat, 29 Nov 2008 20:23:42 +0100

Hi... 
I'm having some problems passing from the "teorical" ER model , to design the real model using EOModeller.

Using the Entity-Relationship model I designed the following tables:

MERCEOLOGIA (nome,marca)
PRODOTTO (id,descrizione, referenza, prezzo, foto )
LUOGO (nome)
PRODOTTOESTERNO (PRODOTTO, qtaIniziale, note)
DISPONIBILITA (PRODOTTO,descrizione)
LUOGO-PRODOTTO (luogo, prodotto, quantita)

Where: the uppercase word is the Entity, between the brackets there are the attributes. The underlined words are the Primary Keys.

So..
MERCEOLOGIA has a 1-to-many relation with PRODOTTO, with the PK of PRODOTTO is id and the PK of MERCEOLOGIA
LUOGO and PRODOTTO has many-to-many relation (plus an attribute)
PRODOTTOESTERNO has a one - to-one relation with PRODOTTO. The PK of PRODOTTOESTERNO is the PK of PRODOTTO
DISPONIBILITA has a one-to-many relation with PRODOTTO.

I've no problem if EOM create a "id" PK for every entity.. I add a Unique key on my "teorical" PK and solve this problem...

but...

I don't know how to create one-to-one relations (I can't add them using the button..) and how to model the "foreign" PK..

Can somebody please help me solving this?

Thanks
Francesco

 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden

  • Follow-Ups:
    • Re: One-to-one relationship
      • From: Miguel Angel Torres Avila <email@hidden>
  • Prev by Date: Re: Secret to JVMOptions on build
  • Next by Date: Re: One-to-one relationship
  • Previous by thread: Re: Secret to JVMOptions on build
  • Next by thread: Re: One-to-one relationship
  • Index(es):
    • Date
    • Thread