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
- 27257 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 different replication agents and what's their purpose? : sql server replication
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
What is the difference between ddl,dml and dcl commands?
what is create database syntax? : Sql server database administration
How to transfer a table from one schema to another?
What stored by the master?
What is the function of sql server agent windows service?
What is tablix?
Explain the phases a transaction has to undergo?
What is a trigger and types of a trigger?
What is the difference between row_number and dense_rank?
What triggers long term care?
What is an indexing strategy?
What is data mart? : sql server analysis services, ssas
How can you set the threshold at which sql server will generate keysets asynchronously?
