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

Is it possible to create trigger on views?

0 Answers  


How to Check if table exists in sql server?

0 Answers  


How check triggers in sql server?

0 Answers  


Which sql server table is used to hold the stored procedure script?

0 Answers  


What is mssql?

0 Answers  






What is policy management?

0 Answers  


What the class forname () does?

0 Answers  


How to get a list of all tables with "sys.tables" view in ms sql server?

0 Answers  


What command is used to create a database in the sql server and how?

0 Answers  


Consider a table with 8 rows 4 rows contains value 0 and 4 rows contains value 1.Now write a single update query to make all 0's as 1 and all 1's as 0

7 Answers   PMAM IT Services, TCS,


Can sql server be linked with other servers like oracle?

0 Answers  


How to select some specific rows from a table in ms sql server?

0 Answers  


Categories