SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Wizard Chris82's Avatar
    Join Date
    Mar 2002
    Location
    Osnabrück
    Posts
    1,003
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    ER-diagram, min / max notation

    Hello,

    recently the topic min / max notation was introduced in one of my courses as a more exact way of expressing the cardinality between entities.

    I have one question regarding the placing of the cardinality between entities:
    "A house has several rooms" that means there is a 1:n relationship between the entity-types "houses" and "rooms". Where do you usually put the "n" and where the "1".
    I would place the "n" at "rooms" and "1" at "houses". I have also seen the other way.
    Where are the cardinalities usually placed?

    My next question is in regards to the min / max notation. I think, I have understood how it works. What confuses me though is that the notation is completely inverse to the 1:n.
    I have attached an image with an example of what I mean.

    Thanks in advance,
    Christian
    Attached Images Attached Images

  2. #2
    SitePoint Addict FizixRichard's Avatar
    Join Date
    May 2003
    Location
    UK
    Posts
    372
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    well, a proper ER Diagram, or ER Model should follow SSADM Methodologies.

    So, thrat being my presumption, is a 1 to many, 1 to 1.

    As in, a house has many rooms and a room has one house.

    the diamond shape shouln'r be there, there "have" should be documented just below or above the line.

    as for your entity names (house and rooms) they should be singular not plural, NEVER use plural names.

    House and Room.

    The relationship naming convention, done properly should be one of three notes, one for each type of relationship.

    Relationships:

    1 to 1: (1:1)
    1 to many: (1:n)
    many to many: (n:n)

    Right, the 1's and n's should be placed on the side of the corresponding relationship. If that makes sense.

    You do not need two relationship notes at either side.

    I've attached an image of how it should look.

    Also, if you want to be proper, you have dependancies, which are a small circle at either end, a filled and not filled one, filled means MUST HAVE (compulsary) and not filed means CAN HAVE (not compulsary)
    Attached Images Attached Images


Bookmarks

Posting Permissions

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