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 an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration
What is “asynchronous” communication in sql server service broker?
What is the difference between function and stored procedure in sql server?
What are the dis_advantages of stored procedures, triggers, indexes?
What is the most common trace flags used with sql server?
How to transfer a table from one schema to another?
Which are the third-party tools used in sql server and why would you use them?
What is the filtered index?
What is Transparent Data Encryption?
Explain what is raid and what are different types of raid levels?
When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?
What are the types of stored procedures in an sql server?
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
Explain having clause and where clause?
Difference between report and query parameter. Why do we need different type of parameter?
