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
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
Explain the Ways to improve the performance of a sql azure database?
How to execute the cursor queries with "open" statements?
Is it true, that there is no difference between a rule and a check constraint?
Define constraints and give an example of their use?
How to use wildcard characters in like operations in ms sql server?
What is difference between clustered index and non clustered index?
What are binary string data types in ms sql server?
Can a table be created inside a trigger?
What is RAID? What are the different types of RAID configurations?
What are the aggregate and scalar functions?
What is the recommended total size of your memory optimized tables?
What is the difference between mysql and sql server?
What is SQL Azure Federations?
How do I find the transaction log size in sql server?