Results 1 to 5 of 5
  1. #1
    Join Date
    May 2008
    Posts
    9

    Relationship Cardinalities

    Hi
    Whenever we are going to design the Database we define relationship cardinalities likewise one-one, One-Many, Many-Many Relationships etc.
    Can anyone let me know in detail how to define these what are the steps we should take care while defining these Cardinalities.

    Thanks

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    dbconcept - we won't do your homework for you. What answer have you got for yourself so far?

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Carnality is a social condition of great interest to database professionals.

    One-one is most common in the western world, and is often referred to by its more common name of monogamy. This describes the normal form where one male and one female mate either for life or the duration of a relationship.

    One-many is less common, but still practiced in the Middle East, parts of Asia, and by the Islamic and some parts of the Mormon faith. It is usually known by its common name of pollygamy. While it could be used to describe one woman with many men, I've only heard about cases with one man with many women.

    Many-many relationships are generally very short lived. This is commonly called an orgy. Generally, this is a 24 hour or less event, usually associated with great excess or hedonism.

    -PatP

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    I think what these guys are trying to say (and succeeding in a most amusing manner) is that we won't do it for you - however we are happy to nudge you in the direction of the right answer if you show us that you've tried!

    Specific questions are (normally) met with much better answers.

    Give it a go; post what you've come up with so far and it will be constructively criticiesed.
    George
    Home | Blog

  5. #5
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Actually, I'm confused about the "Orgy" bit. Pat, you could you describe that in more detail please? How would I go about implementing this on my next team project?
    If it's not practically useful, then it's practically useless.

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

Posting Permissions

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