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
- 27236 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
Do you know spatial data types - geometry and geography in sql server 2008?
What are a database and a data warehouse?
What is sub-query in sql server?
What is stretch database in sql server?
Explain can SSRS reports Cache results?
How sql server enhances scalability of the database system?
You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?
What is the federation in sql azure?
What is bit data type?
Explain the properties of the relational tables?
Do you know what is rank function?
What is user-defined multi-statement table-valued function?
What is checkpoint process in the sql server?
Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture
What is dbcc updateusage?
