What is the key for this relation?

15 pts.
Tags:
ERD
ERD (Entity Relationship Diagram)
Please look at the ERD http://www.mepopo.com/image/1/38504 If I mapping the ERD into relational database schema R(k1, k2, k3, a, b) (which is before normalization). What will be the key for R? Thanks a lot! Jean

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • CharlieBrowne
    This seems to be a homework question and we do not do homework. How about you give us your answer and explain your reasoning for your choice. We may help you out then.
    41,430 pointsBadges:
    report
  • farfrom
    Hi Charlie, Thanks for your reply. Since I am learning Database from some book, and there is a passage about how to mapping ERD to relational schema, about N-ary relationship too few examples for me to clear the concept, I search from web to find this question. According my learning, the key is k3, because the cardinality constraints for the other two participating entity types E1, E2 are both "1" , only the cardinality constraints on E3 is "N". This is my answer, is it right? and also , is this means any relationship instance in E3 uniquely determines the instance of E1,E2 combination ? Thanks in advance Jean
    15 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following