Google Answers Logo
View Question
 
Q: Questions about database ( Answered 4 out of 5 stars,   0 Comments )
Question  
Subject: Questions about database
Category: Computers > Software
Asked by: 888-ga
List Price: $10.00
Posted: 23 Jun 2003 23:43 PDT
Expires: 23 Jul 2003 23:43 PDT
Question ID: 221047
Could you give me an example of a ternary relationship, and show an
alternative model of the relationship that would provide greater
operational reliability.
Answer  
Subject: Re: Questions about database
Answered By: wlk115-ga on 24 Jun 2003 16:46 PDT
Rated:4 out of 5 stars
 
Hello 888-ga, 

Chill Source has some good examples of ternary relationships and
alternative models on their website with easy to understand examples
and lots of ERD, Data Structure & even tree diagrams.

Ternary Relationships
How do I model a ternary relationship in Database Design Studio? 

"As a deliberate choice, Database Design Studio does not have a
ternary relationship type. This is because we believe that a ternary
relationship can be better modeled using a Weak Entity as we discuss
below.


As an example consider this scenario: 

BOOK---BOOK_LOANS---LIBRARY_BRANCH
            |  
         BORROWER 

The relationship “book_loans” is a ternary relationship between the
three entities, and clearly must be a table, with its primary key made
up of the primary keys from the 3 entities to which it is related.


If you make “book_loans” a weak entity, with “PE [Parent Entity] to WE
[Weak Entity]” relationships to all of the three other entities you
will achieve the desired end result of a "ternary" type of
relationship, as shown in the ERD below:


You'll have to go to the website to see the ERD & The Data Structure
Diagram as I can not post them here.
http://www.chillisource.com/dds/tutorial/TutorialTernary_Relationships.htm



In another example they use


Student---attendance---Subject
               |
              Room

The relationship “attendance” is a ternary relationship between the
three entities, and clearly must be a table, with its primary key made
up of the primary keys from the 3 entities to which it is related.


If you make “attendance” a weak entity, with Weak Relationship to all
of the three other entities you will achieve the desired end result of
a "ternary" type of relationship, as shown in the ERD below..."

Go to the website to see the ERD The Data Structure Diagram as I can
not post them here.
http://www.chillisource.com/dds/faq/FAQTernary_Relationships.htm

I hope this answer helps you to better understand ternary
relationships. If you need more information please post Clarification
and I will be happy to provide such.

~wlk115

search terms used:
Ternary Relationship
Entity Relationship
Entity Relationship Models
888-ga rated this answer:4 out of 5 stars

Comments  
There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy