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 > Basic ERD sematics question

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 12-08-04, 07:22
meeks meeks is offline
Registered User
 
Join Date: Dec 2004
Posts: 6
Basic ERD sematics question

The "normal" appearance of an ERD, like I know it, can be seen on here:
http://www.utexas.edu/its/windows/da...m/erintro.html
on the bottom of the page, right above "Summary"

Now I stumbled several times over another notation, which I will try to illustrate:

country--(1,n)---<is in>---(1,1)--city

where <> is kind of a rhombus, representing a "relationship-type". The cardinalities in parenthesises representing the (min,max). So one could think that, one city is in "n", where n is at least 1, countries.
That, I think, is just plain wrong. It is of course just the other way round. "n", where n is at least 1, cities are in one country (asuming that a country has at least one city, which is quite a safe asumption).
What am I misinterpreting?
Is this notation read backwards?
How would one design the city/country example in a "normal" ERD (with the first notation) ? Would it be something like this: country-1-----n-<city ?
Reply With Quote
  #2 (permalink)  
Old 12-09-04, 03:44
certus certus is offline
Registered User
 
Join Date: Dec 2003
Location: Canada
Posts: 710
There's nothing wrong with the example the left side shows the relationship of one country to many cities, the right side shows the relationship of one city to one country. In otherwords a country can have many cities, but a city of a certain name can exist in one and only one country.
__________________
visit: relationary
Reply With Quote
  #3 (permalink)  
Old 12-09-04, 09:12
r937 r937 is offline
SQL Consultant
 
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,524
no, not "a city of a certain name"

rather, a city of a certain identity

what constitutes unique identity for a city is a different question, but i can tell you it is not the city name

toronto is in canada and it is also in the united states more than once
__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote
  #4 (permalink)  
Old 12-09-04, 10:07
meeks meeks is offline
Registered User
 
Join Date: Dec 2004
Posts: 6
Ok, thanks for the replies.
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