Question

Exercise 4.3.2 We may think of relationships in the E/R model as having keys, just as...

Exercise 4.3.2 We may think of relationships in the E/R model as having keys, just as entity sets do. Let R be a relationship among the entity sets E1, E2, …,En. Then a key for R is a set K of attributes chosen from the attributes of E1, E2,…, En such that if (e1,e2,…,en) and (f1,f2,…,fn) are two different tuples in the relationship set for R, then it is not possible that these tuples agree in all the attributes of K. Now, suppose n=2; that is, R is a binary relationship. Also, for each I, let Ki be a set of attributes that is a key for entity set Ei. In terms of E1 and E2, give a smallest possible key for R under the assumption that:

R is many-many

R is many-one from E1 to E2.

R is many-one from E2 to E1.

R is one-one.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

`Hey,

Note: In case of any queries, just comment in box I would be very happy to assist all your queries

a Ris manj-many and E2 doesnt E doesnt detumine E2 Answer: Here а Кey he a neither Can detormine El SD from EI to E2 - hoou

Kindly revert for any queries

Thanks.

Add a comment
Know the answer?
Add Answer to:
Exercise 4.3.2 We may think of relationships in the E/R model as having keys, just as...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • For this DATABASE homework assignment you will create an Entity Relationship model for a business case...

    For this DATABASE homework assignment you will create an Entity Relationship model for a business case and then convert the model to a set of relations.  Read through the following business case for the “Drum Corps International”  Create an Entity relationship model with the necessary entities, attributes, identifiers and relationships to capture the data requirements.  All relationships should be labeled with verb phrases.  Use UML notation for this work.  Relationship lines should not cross. ...

  • please use dia to draw the e-r diagram to create Entity - Relationship Diagrams then use MS access This project requires you to create a database design. Your design will be documented in a set o...

    please use dia to draw the e-r diagram to create Entity - Relationship Diagrams then use MS access This project requires you to create a database design. Your design will be documented in a set of Entity-Relationship Crow's Foot diagrams using the representation as shown in the lecture materials. Draw a set of Entity-Relationship diagrams to model the following scenario. The Maggs Realty Company wants to track the Sales Offices that they have across all of Ontario They are interested...

  • does anyone know what High and low group means in this context? i really do not...

    does anyone know what High and low group means in this context? i really do not understand this article so anyone that does please explain it to me and what the hugh and low group mean in the figures. Received: 21 November 2018 Revised: 27 February 2019 Accepted: 6 March 2019 DOE: 10.1002p28546 ORIGINAL RESEARCnes-highdearee of intra modole connecHvity WILEYa Phypliology ARTICLE Four novel biomarkers for bladder cancer identified by weighted gene coexpression network analysis Zi-Xin Guo | Xiao-Ping Liu...

  • What an Executive Summary Is An executive summary is a specific type of document that does...

    What an Executive Summary Is An executive summary is a specific type of document that does two things: it summarizes a research article, and it offers recommendations as to how information from the article can be used. Some long reports can contain an executive summary section, as indicated in the Pearson handbook. Write a 2 pahe Executive Summary In business contexts, an executive summary is always written for a specific purpose: to explain the information in the article to a...

  • Using the book, write another paragraph or two: write 170 words: Q: Compare the assumptions of...

    Using the book, write another paragraph or two: write 170 words: Q: Compare the assumptions of physician-centered and collaborative communication. How is the caregiver’s role different in each model? How is the patient’s role different? Answer: Physical-centered communication involves the specialists taking control of the conversation. They decide on the topics of discussion and when to end the process. The patient responds to the issues raised by the caregiver and acts accordingly. On the other hand, Collaborative communication involves a...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT