The Gateway to Computer Science Excellence
+1 vote

From what I understood is that M: N relationship means (Many to Many).

And according to rules, Strong entities, each multivalued attributes, and many-to-many relationships requires a separate table.

Hence here we will require new table which will have an attribute as KEYS of both M and N.

But the KEYS included will be foreign keys or primary keys?

If keys will acts as foreign keys then, does that mean newly created table would not have any primary key?

And if someone can briefly and with example explain foreign keys(I always get confused)?

in Databases by Active (1.4k points) | 24 views

Option C is  correct 

whatever a new relation formed it will take primary key of both the relation and acts as FOREIGN KEY  of newly made relation 

BOTH the primary key that acts as foreign key of newly made relation combined to form PRIMARY key for newly made relation

NOTE: BOTH KEY acts as FOREIGN KEY AS separate but when combined acts as PRIMARY KEY

Please log in or register to answer this question.

No related questions found

Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true
50,833 questions
57,723 answers
107,815 users