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 |
Explain sub-query?
What are the different types of subquery?
Differentiate between ms sql server reporting services vs crystal reports?
Explain user defined functions?
i want table name basis on column name.
event classes in sql server
What does it mean to normalize data?
in how many ways we can use count()
Explain different types of index?
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
What is table join?
How to find the second highest salary of an employee?
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)