How m-m relationships are implemented?
Answers were Sorted based on User's Feedback
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 |
What are the different authentication modes in sql server?
What does it mean to normalize data?
Explain various data region available in ssrs with their use?
How to execute a sql statement using mssql_query()?
What is a view?
What are the underflow and overflow behaviors on float literals?
What is public role in sql server?
List out some of the requirements to set up a sql server failover cluster?
How to find table changes in sql server?
How do you drop an index?
How to know the NAME of the Database and SIZE of the Database at the client node in Sql Server 2005
explain different types of jions with examples briefly?
2 Answers Accenture, Excellence, Zensar,