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 difference between table aliases and column aliases? Do they affect performance?
Write a sql query to sort on different column name according to the parameters passed in the function?
What is check constraint in sql server?
Explain what is lock escalation and what is its purpose?
What is a database table?
Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
What are the types of lock supported by ?
Can you edit the .rdl code associated with a linked report?
How to delete a login name in ms sql server?
How does clustered and non clustered index work?
Explain the Ways to improve the performance of a sql azure database?
Explain what are the restrictions that views have to follow? : SQL Server Architecture
What are Row versions of DataRow?
What is user-defined scalar function?
List the types of recovery model available in sql server?
