enter image description here

New database student here. I am having troubles understanding this case for ER to relational database conversion.

So when mapping this to a database does the table for entity one look like this? enter image description here

Basically what I'm asking is if we bring the foreign key from entity two over once or do we need to show it 2 times in the table, one for relationshipattribute1 and one for relationonshipattribute2?

Edit: Assume both are 1 to many relationships with the many on the entity one side.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.