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
- 27067 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
Tell me about pre-defined functions of sql?
What is the simplest way to create a new database in ms sql server?
What are the different authentication modes in sql server? How can it be changed?
How will you find out if there are expensive SQL statements running or not?
Explain query editor regions
Do you know what are the differences between lost updates and uncommitted dependencies?
How do triggers work?
What are the advantages of using stored procedures in sql server?
What do you understand by replication in sql server? Mention the different types of replication in sql server.
is there a column to which a default can't be bound? : Sql server database administration
Explain what is meant by replication of database?
How to change a login name in ms sql server?
What is database mirroring?
What is best institute to Learn DotNET And SQL in chennai?
Tell me what are the essential components of sql server service broker?
