What are the three categories of relationships in er diagram

Assignment Help Computer Engineering

Reference no: EM132094065

Please answer the following questions about ER diagram and translation to the relational model.

a) When translating an ER diagram to the relational model, do all relationships end up as relational model? Explain your answer.

b) What are the three categories of relationships in ER diagrams?

c) What distinguishes relationships in "roles" from all other relationships in an ER diagram?

d) When ISAs in the ER diagram are translated to the relational model, what types of translations are possible?

e) When an attribute to a relationship to be multiple valued, i.e. a list of values, to match the natural language description database, how must the ER diagram be restructured?

Reference no: EM132094065

Questions Cloud

Review the approaches to innovation used by a corporation : Review the approaches to innovation used by a corporation such as Google, Microsoft, etc? What obstacles, as outlined in the article, did they overcome or not?

Plot the time-domain waveform for your filtered : EEET2369 - Signals and Systems Assignment - FIR Filters in Audio Processing. Plot the time-domain waveform for your filtered and non-filtered waveform

E-commerce initiative to support its marketing strategy : GE Healthcare has developed an e-commerce initiative to support its marketing strategy, which targets health-care organizations on a worldwide basis.

Essential skills great it project managers possess : One of the essential skills great IT Project Managers possess is the ability to craft complex project schedules clearly reflecting critical path while surfacing

What are the three categories of relationships in er diagram : When translating an ER diagram to the relational model, do all relationships end up as relational model? Explain your answer.

Do you think oracle might discontinue support for mysql : What reasons might Oracle have for maintaining both, especially considering MySQL is a free, open source option? Do they gain any advantages?

What is the main message of the macmillan : What is the main message of the MacMillan et al. article? How does it relate to concepts discussed in the text?

What is the propagation delay of the link : What is the propagation delay of the link? If the image is square, what is the minimum size of this image in pixels for the link to be continuously transmittin

Module six reading and resources section : After reading the article 10 Ways to Attract Top Talent by Improving Your Workplace Culture in the Module Six Reading and Resources section

User Account

All Pages