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 |
Is it possible to create trigger on views?
How to Check if table exists in sql server?
How check triggers in sql server?
Which sql server table is used to hold the stored procedure script?
What is mssql?
What is policy management?
What the class forname () does?
How to get a list of all tables with "sys.tables" view in ms sql server?
What command is used to create a database in the sql server and how?
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?
How to select some specific rows from a table in ms sql server?