How m-m relationships are implemented?

Answers were Sorted based on User's Feedback



How m-m relationships are implemented?..

Answer / samba shiva reddy . m

One-to-One relationship can be implemented as a single table and rarely as two tables with primary and foreign key relationships.
One-to-Many relationships are implemented by splitting the data into two tables with primary key and foreign key relationships.
Many-to-Many relationships are implemented using a junction table with the keys from both the tables forming the composite primary key of the junction table.

Is This Answer Correct ?    4 Yes 0 No

How m-m relationships are implemented?..

Answer / laxman

using junction table

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More SQL Server Interview Questions

Where are sql server usernames and passwords stored in the sql server?

0 Answers  


Do you know exporting and importing utility?

0 Answers  


How do I start sql server 2016?

0 Answers  


what is a stored procedure and trigger?

3 Answers  


When should you use an instead of trigger?

0 Answers  






What is DCL?

0 Answers  


can foreign key take role of primary key?

5 Answers   CarrizalSoft Technologies, TCS, Villa Marie,


Define master database?

0 Answers  


Is it safe to delete log files?

0 Answers  


Explain sql delete command?

0 Answers  


What are the different type of replication in sql server?

0 Answers  


What is cte (common table expression)?

0 Answers  


Categories