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
Explain the advantages of merge replication?
if no size is defined while creating the database, what size will the database have? : Sql server administration
What are subquery and its properties?
Explain optimistic and pessimistic concurrency?
What is sql server profiler?
hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.
How to rename an existing column with sql server management studio?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
explain how to create a new schema in a database? : Sql server database administration
How to backup SQL Server Reporting Services ?
What is indexing a document?
What is user-defined functions? What are the types of user-defined functions that can be created?
How many databases can we create in a single server?
What is the purpose of linked server configuration in sql server?
Why people hate cursor?