If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > General > Database Concepts & Design > ER Vs EER

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 11-12-06, 23:39
varun8211 varun8211 is offline
Registered User
 
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 ?
Reply With Quote
  #2 (permalink)  
Old 11-13-06, 07:55
r937 r937 is offline
SQL Consultant
 
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,524
i think the difference is the extra E

(what's that stand for, by the way?)
__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote
  #3 (permalink)  
Old 11-13-06, 08:06
pootle flump pootle flump is offline
King of Understatement
 
Join Date: Feb 2004
Location: One Flump in One Place
Posts: 14,905
Quote:
Originally Posted by rudy
(what's that stand for, by the way?)
Entity
__________________
Testimonial:
Quote:
pootle flump
ur codings are working excelent.
Reply With Quote
  #4 (permalink)  
Old 11-13-06, 08:54
r937 r937 is offline
SQL Consultant
 
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,524
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!"
__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote
  #5 (permalink)  
Old 11-13-06, 09:01
pootle flump pootle flump is offline
King of Understatement
 
Join Date: Feb 2004
Location: One Flump in One Place
Posts: 14,905
You didn't specifiy which E
__________________
Testimonial:
Quote:
pootle flump
ur codings are working excelent.
Reply With Quote
  #6 (permalink)  
Old 11-13-06, 09:07
r937 r937 is offline
SQL Consultant
 
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,524
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?)
__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote
  #7 (permalink)  
Old 11-13-06, 10:24
pootle flump pootle flump is offline
King of Understatement
 
Join Date: Feb 2004
Location: One Flump in One Place
Posts: 14,905
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:
Quote:
pootle flump
ur codings are working excelent.
Reply With Quote
  #8 (permalink)  
Old 11-13-06, 14:09
Pat Phelan Pat Phelan is offline
Resident Curmudgeon
 
Join Date: Feb 2004
Location: In front of the computer
Posts: 12,605
I think the extra E stands for Extreme. It is done on skateboards, being towed behind motorcycles.

-PatP
Reply With Quote
  #9 (permalink)  
Old 11-13-06, 14:25
MCrowley MCrowley is offline
Wage drone 24601
 
Join Date: Jan 2003
Location: Massachusetts
Posts: 4,899
I think it stands for "electronic", much like the extra "E" in "eCommerce". Or was it "esoteric"? ;-)
Reply With Quote
  #10 (permalink)  
Old 11-13-06, 14:35
r937 r937 is offline
SQL Consultant
 
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,524
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
__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote
  #11 (permalink)  
Old 11-13-06, 15:20
blindman blindman is offline
World Class Flame Warrior
 
Join Date: Jun 2003
Location: Ohio
Posts: 11,726
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"
Reply With Quote
  #12 (permalink)  
Old 11-13-06, 17:14
pootle flump pootle flump is offline
King of Understatement
 
Join Date: Feb 2004
Location: One Flump in One Place
Posts: 14,905
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:
Quote:
pootle flump
ur codings are working excelent.
Reply With Quote
  #13 (permalink)  
Old 11-13-06, 19:09
blindman blindman is offline
World Class Flame Warrior
 
Join Date: Jun 2003
Location: Ohio
Posts: 11,726
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"
Reply With Quote
  #14 (permalink)  
Old 11-25-06, 03:43
certus certus is offline
Registered User
 
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.
__________________
visit: relationary
Reply With Quote
  #15 (permalink)  
Old 12-13-09, 15:53
glenjemin12 glenjemin12 is offline
Registered User
 
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
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On