Answer Posted / 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 |
Post New Answer View All Answers
What happens to a statement batch if there is a compilation error?
What are the advantages of sql azure?
Working with TLogs
Do you know what is blocking?
Can two tables share the same primary key?
How will you make an attribute not process? : sql server analysis services, ssas
How to delete a login name in ms sql server?
What is raid and what are different types of raid levels?
How optimize sql query with multiple joins in sql server?
Explain the truncate command?
How to delete duplicate records based on single column from a table?
What is the use of nvl work?
What happens when unicode strings concatenate with non-unicode strings?
What are the different types of backups that exist?
What is the meaning of lock escalation and why/how to stop this? : sql server database administration
