Page 1 of 2 12 LastLast
Results 1 to 15 of 20

Thread: ER Vs EER

  1. #1
    Join Date
    Nov 2006
    Posts
    3

    ER Vs EER

    Any specific difference between ER and EER model.. other than generalization/specialization ??
    Which is better ?
    Whyy EER over ER ?

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    i think the difference is the extra E

    (what's that stand for, by the way?)
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by rudy
    (what's that stand for, by the way?)
    Entity
    Testimonial:
    pootle flump
    ur codings are working excelent.

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    pootle, you scare me

    the extra E in EER stands for Entity?

    so EER = entity entity relationship? "Are you sure?" (see below)





    Two molecules are walking down the street and they run in to each other. One says to the other, "Are you all right?"

    "No, I lost an electron!"

    "Are you sure?"

    "I'm positive!"
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    You didn't specifiy which E
    Testimonial:
    pootle flump
    ur codings are working excelent.

  6. #6
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    did too

    or have you been smoking so much wacky tobacky that your short term memory cannot make it from one sentence to the next?
    Quote Originally Posted by moi
    i think the difference is the extra E

    (what's that stand for, by the way?)
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  7. #7
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Nah - I was talking nonsense of course. I was going to argue that the extra E is just relative but I think that is just too weak.

    You know - I googled it last night and (I must have been tired) I was sure it came up as Entity Entity Relationship which I thought was jolly goofy. Of course, someone over night has rearranged the world wide web or maybe "they" hacked google or something because it now comes up as Extended Entity Relationship.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  8. #8
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    I think the extra E stands for Extreme. It is done on skateboards, being towed behind motorcycles.

    -PatP

  9. #9
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    I think it stands for "electronic", much like the extra "E" in "eCommerce". Or was it "esoteric"? ;-)

  10. #10
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    actually, i asked a very close friend of mine who happens to be an MCDBA, and the correct answer (as all readers of The Daily WTF know) is enterprise

    it's an Enterprise Entity Relationship diagram

    which is, like, so totally better than a simple ER diagram
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  11. #11
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    I though an ER diagram was just a floor plan for a hospital emergency room.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  12. #12
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by Pat Phelan
    I think the extra E stands for Extreme. It is done on skateboards, being towed behind motorcycles.

    -PatP
    So does the D in EERD stand for Dude?
    Testimonial:
    pootle flump
    ur codings are working excelent.

  13. #13
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Quote Originally Posted by pootle flump
    So does the D in EERD stand for Dude?
    Yes. It stands for "Dude".
    Extreme. Entity. Relationship. Dude.
    Awesome, bro'.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  14. #14
    Join Date
    Dec 2003
    Location
    Canada
    Posts
    710
    Enterprise Entity Relationship? Is this a trekkie thing? Your data model is illogical, captain.

    blindman, wasn't there a movie The Best Little Data Whorehouse In Texas? I'm sure it had lots of stars in it.

  15. #15
    Join Date
    Dec 2009
    Posts
    1

    Cool HAHA come on guys

    ER is really ERD which stands for Entity Relationship Diagram and the EERD stands for Enhanced Entity Relationship Diagram. Trust me I am a database administrator. Hope this helps

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •