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
How many types of dimensions are there and what are they? : sql server analysis services, ssas
Difference between LEN() and DATALENGTH() in sql server ?
When a primary key constraint is included in a table, what other constraints does this imply?
How to display a past time in days, hours and minutes?
what are constraints? Explain different types of constraints? : Sql server database administration
Sql server reporting services vs. Crystal reports.
How raid can influence database performance?
Explain the truncate command? : SQL Server Architecture
What is meant by indexing?
What is deploy, process and build? : sql server analysis services, ssas
Tell me what is difference between view and materialized view?
What is table join?
How to execute stored procedure in select statement sql server?
Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
Is it important for a database administrator to understand the operating system and file access?