How do you implement one-to-one, one-to-many and many-to-
many relationships while designing tables?
Answer Posted / sundar
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 ? | 7 Yes | 2 No |
Post New Answer View All Answers
What part does database design plays a role in performance of an sql server-based application?
How can you set the threshold at which sql server will generate keysets asynchronously?
Explain the concept of recursive stored procedure.
What are different types of collation sensitivity?
What is global temp table?
What is the default fill factor value?
what exactly sql injuction.how to overcome.....
Ways to improve the performance of a SQL Azure Database?
What is set nocount on and what is set nocount off?
What is a heap?
What is query optimizer in sql server?
What are the different types of triggers in SQL SERVER?
Is the primary key column of a table an index in ms sql server?
Will sql server 2005 allow you to reduce the size of a column?
How ssrs maintain security?