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
- 27070 Views
- Credit Suisse, GCU, Symphony, TCS, I also Faced
- E-Mail Answers
Answer Posted / swapna
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.
It will be a good idea to read up a database designing
fundamentals text book.
| Is This Answer Correct ? | 48 Yes | 2 No |
Post New Answer View All Answers
What are the properties of the relational tables?
Do you know hot add cpu in sql server 2008?
What is page-level compression?
What is cursor in ms sql server?
what is blocking? : Sql server database administration
What are the benefits and tasks of object explorer? : sql server management studio
How to create an identity column?
How to retrieve field values using mssql_result()?
What are the 10 characteristics of data quality?
What are the indexes in sql server?
Why union all is faster than union?
What is read committed?
What does Master database contains?
Why it is recommended to avoid referencing a floating point column in the where clause?
Why Master database is required?
