What types of translations are possible

Assignment Help Computer Engineering

Reference no: EM132094096

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 relations in the 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 relation model, what types of translations are possible?

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

Reference no: EM132094096

Questions Cloud

Identify the problems on various carnival cruise lines : 1. Identify the problems on various Carnival Cruise Lines as included in the article. 2. What is the root cause of the problems?

Make the size of the fixation dot a variable : Matlab and Psychtoolbox programming for Cognitive Neuroscience Summative Assignment - Make the size of the fixation dot a variable

Which architecture for deploying a firewall is most used : What are the reasons that VPN technology has become the dominant method for remote workers to connect to the organizational network?

Statute of frauds applies : If the Statute of Frauds applies, does the specially-manufactured goods exception apply, so that the contract would not have to be in writing to be enforceable

What types of translations are possible : What are the three categories of relationships in ER diagrams? What distinguishes relationships in "roles" from all other relationships in an ER diagram?

Training and development industry : Now that you have completed this course, what do you see changing, going away, developing, etc. for the training and development industry

Create a vector to store point2d points : Write one line of code for each line below. What is the template type in each case?Create a vector to store student IDs.

Describes a dilemma faced by maria : Just Business, A Christian Ethic for Business, describes a dilemma faced by Maria. What do you think that Maria should do?

List all of the fire accident classification classes : List all of the fire accident classification classes. Find at least three different fire extinguishers (do not touch them) and document their location.

User Account

All Pages