Interested to Buy Any Domain ? << Click Here >> for more details...
How do you implement one-to-one, one-to-many and many-to-
many relationships while designing tables?
- 4 Answers
- 27388 Views
- Credit Suisse, GCU, Symphony, TCS, I also Faced
- E-Mail Answers
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 are the difference between clustered and a non-clustered index?
What is the difference between a unique key and primary key?
how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration
What is a benefit of using an after insert trigger over using a before insert trigger?
How to filter out duplications in the returning rows in ms sql server?
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
What are the difference between data mart and data warehouse? : sql server analysis services, ssas
What is the difference between varchar and varchar(max) datatypes?
What is ms sql server service broker?
What is rs.exe utility?
What do you mean by recursive stored procedure?
Is a primary key unique?
What are the transaction properties?
List the types of recovery model available in sql server?
What is the latest version of microsoft sql server?
