Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / samba shiva reddy . m
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 ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is thr feature of change data capture?
List layers of abstraction microsoft architectured to provide relational db through cloud platform ?
Explain the rules for designing files and file groups in sql server?
How to generate create function script on an existing function?
Name few of the dcl commands in sql?
What is database replication? What are the different types of replication you can set up in sql server?
What is meant by referential integrity?
How can we migrate from SQL server to SQL Azure?
Can a synonym name of a table be used instead of a table name in a select statement?
Mention the different authentication modes in sql server.
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
Define indexes?
How extra digits are handled with numeric data type literals?
what's the difference between delete table and truncate table commands? : Sql server database administration
How do I partition a table in sql server?
