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 |
How to insert multiple rows with one insert statement in ms sql server?
What is dynamic cursor in SQL SERVER?
Define left outer join in sql server joins?
what is Equity join?
What is the purpose of using COLLATE in a query?
do views contain data ?
How do I start sql server 2017?
Why use “pivot” in sql server?
why SQL server is more used to store database rather than Access
What is a database table?
What are the benefits of using stored procedures over sql statements?
What is the concept of optimization?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)