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

What are the different authentication modes in sql server?

0 Answers  


What does it mean to normalize data?

0 Answers  


Explain various data region available in ssrs with their use?

0 Answers  


How to execute a sql statement using mssql_query()?

0 Answers  


What is a view?

6 Answers  






What are the underflow and overflow behaviors on float literals?

0 Answers  


What is public role in sql server?

0 Answers  


List out some of the requirements to set up a sql server failover cluster?

0 Answers  


How to find table changes in sql server?

0 Answers  


How do you drop an index?

0 Answers  


How to know the NAME of the Database and SIZE of the Database at the client node in Sql Server 2005

1 Answers  


explain different types of jions with examples briefly?

2 Answers   Accenture, Excellence, Zensar,


Categories